Hello, i am trying to get the filenames from the images in the mysql database but the filenames does not shows up. I think i am using the INSERT INTO codes wrong, but i don't know where i am going wrong.
[syntax=php]$images = glob('*.{jpg,JPG,jpeg,JPEG,png,PNG,gif,GIF}', GLOB_BRACE);
mysql_query("INSERT INTO `fotogallery` . `photographs` {`id` ,`filename`} VALUES (NULL, '$images')") ;
[/syntax]
In my database i am using
[syntax=sql]->id INT(11) NOT NULL AUTO_INCREMENT,
->filename VARCHAR(255) NOT NULL[/syntax]
I hope somebody can help me out here,
Thanks.
Image data into database
- Robbedoesie
- Posts: 97
- Joined: Thu May 19, 2011 7:37 pm
- Location: Enkhuizen, Holland