FUDforum: comp.lang.php » MYSQL PHP Query Not Working

Home » Imported messages » comp.lang.php » MYSQL PHP Query Not Working

Show: Today's Messages :: Polls :: Message Navigator

Re: MYSQL PHP Query Not Working [message #185485 is a reply to message #185484]

Thu, 03 April 2014 17:08

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 4/3/2014 12:18 PM, Salvatore wrote:
> On 2014-04-03, cuteywithlove(at)gmail(dot)com <cuteywithlove(at)gmail(dot)com> wrote:
>> I've spent hours on this and can't understand why this doesn't work.
>>
>> [snip]
>> $blog_id = filter_input(INPUT_GET, 'blogId', FILTER_SANITIZE_NUMBER_INT);
>> [snip]
>> if (!$stmt->bind_param("ii", $id, $blog_Id)) {
>> [snip]
>>
>> If I copy and paste the query into phpmyadmin and run it with the values
>> hard coded it works.
>>
>> No errors are returned.
>>
>> The user has privileges to delete and everything else.
>>
>> Is there anyway I can check it? or see any errors any other way?
>
> The first thing I see wrong is that you mistyped "$blog_id" as
> "$blog_Id".
>

Good eye, Salvatore! Can I get you to proof my next project? :)

I would also mention that enabling E_NOTICE would have shown this error
(assuming, of course, the OP doesn't also have $blog_Id defined, of course).

--
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		MYSQL PHP Query Not Working By: cuteywithlove on Thu, 03 April 2014 15:46
		Re: MYSQL PHP Query Not Working By: Salvatore on Thu, 03 April 2014 16:18
		Re: MYSQL PHP Query Not Working By: Jerry Stuckle on Thu, 03 April 2014 17:08
		Re: MYSQL PHP Query Not Working By: The Natural Philosoph on Thu, 03 April 2014 17:30
		Re: MYSQL PHP Query Not Working By: Jerry Stuckle on Thu, 03 April 2014 18:38
		Re: MYSQL PHP Query Not Working By: cuteywithlove on Fri, 04 April 2014 07:48
		Re: MYSQL PHP Query Not Working By: Erwin Moller on Fri, 04 April 2014 10:28
		Re: MYSQL PHP Query Not Working By: bill on Fri, 04 April 2014 10:45
		Re: MYSQL PHP Query Not Working By: M. Strobel on Sat, 05 April 2014 19:30

Previous Topic:	Strange but true! Working with interfaces in PHP
Next Topic:	PDF extract text

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 16:09:32 GMT 2024

Total time taken to generate the page: 0.05014 seconds