Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #13319

Re: MYSQL PHP Query Not Working

Show all headers | View raw

On 4/3/2014 12:18 PM, Salvatore wrote:
> On 2014-04-03, cuteywithlove@gmail.com <cuteywithlove@gmail.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@attglobal.net
==================

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

MYSQL PHP Query Not Working cuteywithlove@gmail.com - 2014-04-03 08:46 -0700
  Re: MYSQL PHP Query Not Working Salvatore <sal@yojimbo.hack.invalid> - 2014-04-03 16:18 +0000
    Re: MYSQL PHP Query Not Working Jerry Stuckle <jstucklex@attglobal.net> - 2014-04-03 13:08 -0400
    Re: MYSQL PHP Query Not Working The Natural Philosopher <tnp@invalid.invalid> - 2014-04-03 18:30 +0100
      Re: MYSQL PHP Query Not Working Jerry Stuckle <jstucklex@attglobal.net> - 2014-04-03 14:38 -0400
        Re: MYSQL PHP Query Not Working cuteywithlove@gmail.com - 2014-04-04 00:48 -0700
          Re: MYSQL PHP Query Not Working Erwin Moller <erwinmollerusenet@xs4all.nl> - 2014-04-04 12:28 +0200
          Re: MYSQL PHP Query Not Working bill <william@TechServSys.com> - 2014-04-04 06:45 -0400
            Re: MYSQL PHP Query Not Working "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2014-04-05 21:30 +0200

csiph-web