Re: Wow, this is weird

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.