PHP Won't Insert Data Into Mysql Database
Posted: Sat Feb 14, 2009 10:31 pm
Hello, I've probably spent the last 6 hours trying to figure this one out
. I'm fairly new to PHP and i prefer to learn by looking at code, removing it parts, seeing what it changes, then reinserting it. It may be an odd way to learn, but i find it to be the best way i've found lol. Anyway here is my problem. I found this tutorial on how to make a photo gallery using PHP. I thought "what the hell" and got down to work. I have completed the tutorial and have it working fine, what i want to do now, is insert new albums, which it does not talk about in the tutorial. First off, i'll explain my Tables (sorry for the bad quality lol)
Tutorial: http://www.sitepoint.com/article/php-ga ... m-minutes/
-------------------------------------------------------
| Field Name | Field Type |
-------------------------------------------------------
| category_id | Integer |
-------------------------------------------------------
| category_name | Text |
-------------------------------------------------------
Here is my "add_category.html":
And here is my "/photo1/add_category.php":
The Way i look to see if any data was added is there is page called "preupload.php" that has you select a category... Obviously something is going on, because i used to just see "My First Gallery" (I inserted that via terminal) And now i just see blank spaces... If anyone would care to see my "preupload.php" script here is it....
Sorry for having such a vage post, But i'd very very very much appreciate any help on the matter!!!!! Again, MANY thanks!!!!
Tutorial: http://www.sitepoint.com/article/php-ga ... m-minutes/
-------------------------------------------------------
| Field Name | Field Type |
-------------------------------------------------------
| category_id | Integer |
-------------------------------------------------------
| category_name | Text |
-------------------------------------------------------
Here is my "add_category.html":
Code: Select all
<html><body> <form type="POST" action="/photo1/add_category.php"> <table> <tr> <td> Name: <input type="text" name="cateogry_name" /> </td> <td> <input type="submit" /> </td> </tr> </table> </form></body></html> Code: Select all
<?php
$mysql_link = mysql_connect("localhost", "justin", "password");
mysql_select_db("gallery") or die("Could not select database");
mysql_query( "INSERT INTO gallery_category(`category_name`) VALUES('".addslashes( $_POST[category_name] )."' )" );
?>
The Way i look to see if any data was added is there is page called "preupload.php" that has you select a category... Obviously something is going on, because i used to just see "My First Gallery" (I inserted that via terminal) And now i just see blank spaces... If anyone would care to see my "preupload.php" script here is it....
Code: Select all
<?php
include("/var/www/photo1/config.inc.php");
// initialization
$photo_upload_fields = "";
$counter = 1;
// default number of fields
$number_of_fields = 5;
// If you want more fields, then the call to this page should be like,
// preupload.php?number_of_fields=20
if( $_GET['number_of_fields'] )
$number_of_fields = (int)($_GET['number_of_fields']);
// Firstly Lets build the Category List
$result = mysql_query( "SELECT category_id,category_name FROM gallery_category" );
while( $row = mysql_fetch_array( $result ) )
{
$photo_category_list .=<<<__HTML_END
<option value="$row[0]">$row[1]</option>\n
__HTML_END;
}
mysql_free_result( $result );
// Lets build the Photo Uploading fields
while( $counter <= $number_of_fields )
{
$photo_upload_fields .=<<<__HTML_END
<tr>
<td>
Photo {$counter}:
<input name=' photo_filename[]' type='file' />
</td>
</tr>
<tr>
<td>
Caption:
<textarea name='photo_caption[]' cols='30' rows='1'></textarea>
</td>
</tr>
__HTML_END;
$counter++;
}
// Final Output
echo <<<__HTML_END
<html>
<head>
<title>Lets upload Photos</title>
</head>
<body>
<form enctype='multipart/form-data' action='upload.php' method='post' name='upload_form'>
<table width='90%' border='0' align='center' style='width: 90%;'>
<tr>
<td>
Select Album
<select name='category'>
$photo_category_list
</select>
</td>
</tr>
<tr>
<td>
<p> </p>
</td>
</tr>
<!-Insert the photo fields here -->
$photo_upload_fields
<tr>
<td>
<input type='submit' name='submit' value='Add Photos' />
</td>
</tr>
</table>
</form>
</body>
</html>
__HTML_END;
?>
Sorry for having such a vage post, But i'd very very very much appreciate any help on the matter!!!!! Again, MANY thanks!!!!