Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,150,607 members, 7,809,220 topics. Date: Friday, 26 April 2024 at 05:47 AM

Pros $ Cons Of PDO And Mysqli - Webmasters (2) - Nairaland

Nairaland Forum / Science/Technology / Webmasters / Pros $ Cons Of PDO And Mysqli (6922 Views)

What Are The Pros And Cons Of Using An Online Payment Gateway / What Are The Pros And Cons Of Sharing Adsense With A Friend / Pros And Cons Of Buying Facebook Likes & Twitter Followers (2) (3) (4)

(1) (2) (Reply) (Go Down)

Re: Pros $ Cons Of PDO And Mysqli by exHuman: 12:58pm On May 06, 2015
Will comment in......
Re: Pros $ Cons Of PDO And Mysqli by abeltolu: 3:58pm On May 06, 2015
Thats why I love my CakePHP. No need for all this code jargons. I can build most apps half the time it will take you to do raw php.
Re: Pros $ Cons Of PDO And Mysqli by nwadiuko1(m): 4:01pm On May 06, 2015
What in blackberry's name are all ya niggies talkin about?
Re: Pros $ Cons Of PDO And Mysqli by udokpuenyi(m): 5:51pm On May 06, 2015
abeltolu:
Thats why I love my CakePHP. No need for all this code jargons. I can build most apps half the time it will take you to do raw php.

Inasmuch as frameworks accelerate the programming job, but knowing the core php codes, functions syntax and functionalities is very important in case if you run into issues that may require a custom logic. Many a times, the is always the case
Re: Pros $ Cons Of PDO And Mysqli by olareed(m): 6:04pm On May 06, 2015
Confused
Re: Pros $ Cons Of PDO And Mysqli by Nobody: 6:13pm On May 06, 2015
Usually,
$db = mysqli("host", "username", "password", "db" );

if($db->connect_errno) die('Connection failed:' .connect_error);

$sql_query = "SELECT * FROM 'tableName'";

$result = $db->query($sql_query);
                    
while ($row = $result->fetch_array()){
//process rows here
}

$result->close();
$db->close();
Re: Pros $ Cons Of PDO And Mysqli by osile2012: 9:33am On May 07, 2015
lordjay:


OP, except i don't understand what you're talking about, but I use rowCount() to fetch number of rows in PDO and it works perfectly for me.

Returns the number of affected rows in Delete, Insert and Update statement not select in most dbases.
Re: Pros $ Cons Of PDO And Mysqli by osile2012: 1:40pm On May 07, 2015
olukenzo:
Usually,
$db = mysqli("host", "username", "password", "db" );

if($db->connect_errno) die('Connection failed:' .connect_error);

$sql_query = "SELECT * FROM 'tableName'";

$result = $db->query($sql_query);
                    
while ($row = $result->fetch_array()){
//process rows here
}

$result->close();
$db->close();

This will work, but not for prepared statements

(1) (2) (Reply)

Get Free 7.5gb Data From Mtn / 10 Blogging Mistakes You Should Avoid / Guide: How To Succeed If You Are Blogging For The Money.

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 11
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.