500 - Internal server error on index.php
Hey guys,
So I'm making a basic website form to do CRUD operations on a database, and all of my components work, but I keep getting 500 - Internal server error on my index.php
Heres my code:
[PHP]View All Alien Interactions';
/* Start the table with the fields we want to display
Remember $fields is now in config.php */
echo '';
foreach($fields AS $label){
// th is a table header; the column's title or label.
echo "";
}
//Add the edit and delete columns at the end of the table
echo '';
echo '';
/*
Select the fields we want, from all the rows
The first line takes the array keys from our $fields array
and implodes them, using backticks and commas. The end result
will look like `first_name`, `last_name`, `phone_number`...
The next line creates a SELECT query using that string.
*/
$fields_str = '`contact_id`, `'.implode(array_keys($fields), '`, `').'`';
$sql = "SELECT {$fields_str} FROM `aliens_abduction`";
foreach($dbh->query($sql) as $row) {
echo '';
// Loop through the fields again to display them for this row.
// Note: The tutorial originally contained an error here, this has been updated.
foreach($fields AS $field=>$value){
// if the field is blank, we want to empty a blank space, otherwise the HTML won't work properly
echo '');
}
echo '';
echo '';
echo '';
echo '';
echo '
';
?>[/PHP]
and heres my config.php code (idk if this is the root of the problem, i dummied out my credentials):
[PHP]setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
//Define the fields for our CRUD application
$fields = array(
'first_name' => 'First Name',
'last_name' => 'Last Name',
'when_it_happened' => 'When it happened',
'how_many' => 'How many',
'alien_description' => 'Alien description',
'what_they_did' => 'What they did',
'fang_spotted' => 'Fang spotted',
'email' => 'Email'
);
?>[/PHP]
| {$label} | Edit | Delete |
|---|---|---|
| '.(isset($row[$field]) && strlen($row[$field]) ? $row[$field] : ' '.' | ||
| .'">Edit | .'">Delete |
-
Hello :) Please post the output from /usr/local/apache/logs/error_log when the "500" error code appears. Thank you. 0
Please sign in to leave a comment.
Comments
1 comment