You are probably having problems with "Array[name]" because of the way
you are inserting variables into the query.
You're doing this:
"this is my string with '$_POST[image][name]'."
Instead, try this:
"This is my string with '{$_POST['image']['name']}' in it."
or this:
"This is my string with '" . $_POST['image']['name'] , "' in it, using
the concatenate operator."
-Matt
On 08/27/2012 04:43 PM, David McGlone wrote:
On Monday, August 27, 2012 03:36:41 PM Matt Pelmear wrote:
David,
Try using $_FILES['image']['name'] (like you do elsewhere in the script)
instead of $_POST['image'] ?
I just your tried suggestion and now it does insert something into the
database, but it's inserting "Array[name]" instead of the intended image name.
So I believe my first mistake was, I should have realized the line
$_FILES['image']['name'] is an array, so of course the image name isn't going
to be there until I extract it from the array. Correct?
Also, if you're not just doing a simple test script, you should probably
use mysql_real_escape_string() on your parameters in the query.
I started with a simple form and I'm working my way up the ladder, from
posting stuff, sticking stuff in a db using stuff like getimagesize(), and then
next I'm going to work some more with sanitization of forms and inserted data
in the db. :-)
By the time I'm done with this, I'm hoping to have a much greater
understanding of FILTER_SANITIZE_STRING, getimagesize, and whatever else I
would need to know about forms and inserting into db's. :-)
You may want to also look at the alternative mysql drivers, as the API
you're using is planned for deprecation at some point.
http://php.net/manual/en/mysql.php
http://www.php.net/manual/en/mysqlinfo.api.choosing.php (this page
seems to leave out the mysqlnd driver)
Thank you for the heads up, I'll most certainly take a look at this.
David M.
-Matt
On 08/27/2012 03:04 PM, David McGlone wrote:
Hi Everyone
I have written some code that works almost 100% like I expect, but for the
life of me I cannot figure out why the image name is not being inserted
into the database. I've posted the code on pastebin, can anyone spot
something amis?
http://pastebin.com/mGBFrxwP
David M.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
