You are here: Re: Getting results from MySQL Database in PHP « PHP Programming Language « IT news, forums, messages
Re: Getting results from MySQL Database in PHP

Posted by Jerry Stuckle on 05/13/07 03:07

Mike P2 wrote:
> On May 11, 10:28 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> Mike,
>>
>> Actually, he is using the OO mysqli code. But he has multiple problem,
>> including:
>>
>> 1) he never issued a SELECT statement.
>> 2) $db is out of scope where it is used
>> 3) he's trying to mix mysql commands and mysqli objects
>>
>> And once he gets these problems fixed he'll have more. He needs a new
>> book...
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================
>
> I realize that. I fixed those things in my example. The DB being out
> of scope doesn't really matter, he's not passing $db to the MySQL
> functions anyway. The connection is open, and PHP will find it.
>
> I think that after looking at my example of how it should be, he
> should be able to do some more research and/or figure out what he
> needs to be doing.
>
> -Mike PII
>

Mike,

But what you're doing is even worse - mixing OO and non-OO calls to the
database. Your mysql() calls will not update the variables in the
mysqli objects for instance.

You shouldn't try to mix and match mysql and mysqli code in the same
page - it's just asking for trouble.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация