FUDforum: comp.lang.php » database access

Home » Imported messages » comp.lang.php » database access

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

Re: database access [message #174201 is a reply to message #174200]

Thu, 26 May 2011 14:33

sheldonlg
Messages: 166
Registered: September 2010

Karma:

Senior Member

On 5/26/2011 10:30 AM, sheldonlg wrote:
> On 5/26/2011 9:37 AM, Jivanmukta wrote:
>>> Do you really need to use PDO ?
>>> Whats wrong with the regular PHP mysql_XXXX() functions ?
>>
>> I could not solve some problem with mysqli and this problem did not
>> occur using PDO. Nobody could help me with this problem on newsgroups.
>> If I remember correctly fetching some nonempty query returned false in
>> mysqli, in PDO the same query returned proper set.
>
> If the query is non-empty, you should have no problem in fetching the
> results with the standard mysql functions. Why were you even bothering
> with mysqli? Look for mysql_query, mysql_fetch_assoc, and
> mysql_fetch_array in www.php.net. They are all you need.
>
> What I regularly use most is:
>
> $theArray = array();
> $result = mysql_query("The query text");
> if (FALSE !== $result) {
> while ($row = mysql_fetch_assoc($result) {
> $theArray[] = $row;
> }
> }
>
> if (count($theArray)) {
> .....
> }
>
>
> You could even put the query into your database class as a
> getArray($query) method.
>

Ooops. Make that
if (count($theArray) > 0) {

--
Shelly

Report message to a moderator

[Message index]

		database access By: Jivanmukta on Wed, 25 May 2011 17:17
		Re: database access By: Jerry Stuckle on Wed, 25 May 2011 21:37
		Re: database access By: sheldonlg on Thu, 26 May 2011 12:09
		Re: database access By: Jerry Stuckle on Thu, 26 May 2011 13:00
		Re: database access By: sheldonlg on Thu, 26 May 2011 14:22
		Re: database access By: Jerry Stuckle on Thu, 26 May 2011 15:41
		Re: database access By: sheldonlg on Thu, 26 May 2011 16:07
		Re: database access By: sheldonlg on Thu, 26 May 2011 16:14
		Re: database access By: sophal chao on Sun, 29 May 2011 20:41
		Re: database access By: Jerry Stuckle on Mon, 30 May 2011 03:12
		Re: database access By: JohnT on Thu, 26 May 2011 13:05
		Re: database access By: Jivanmukta on Thu, 26 May 2011 13:37
		Re: database access By: sheldonlg on Thu, 26 May 2011 14:30
		Re: database access By: sheldonlg on Thu, 26 May 2011 14:33
		Re: database access By: Jerry Stuckle on Thu, 26 May 2011 15:43
		Re: database access By: Michael Fesser on Thu, 26 May 2011 17:48
		Re: database access By: Erwin Moller on Mon, 30 May 2011 08:56

Previous Topic:	Stats comp.lang.php (last 7 days)
Next Topic:	a more elegant way?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 05:57:13 GMT 2024

Total time taken to generate the page: 0.03410 seconds