TalkPHP
 
 
Account Login
Latest Articles
» The basic usage of PHPTAL, a XML/XHTML template library for PHP
» Vulnerable methods and the areas they are commonly trusted in.
» Simple way to protect a form from bot
» The Basics On: How Session Stealing Works
» How to keep your forms from double posting data
IRC Channel
IRC Speech Bubble Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.
Associates
Associates
CSS Tutorials
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 04-03-2008, 05:04 PM   #1 (permalink)
The Acquainted
 
wGEric's Avatar
 
Join Date: Nov 2007
Posts: 166
Thanks: 0
wGEric is on a distinguished road
Default mysqli

Looking through a lot of the code posted here I noticed most of you use the mysql functions instead of mysqli. Is there a reason for this? Seems like you guys would want to use mysqli because it can be OOP.
__________________
Eric
wGEric is offline  
Reply With Quote
Old 04-03-2008, 05:59 PM   #2 (permalink)
The Addict
 
Join Date: Nov 2007
Posts: 264
Thanks: 2
TlcAndres is on a distinguished road
Default

I use it because of my familiarity with the mysql functions, I *should* port over to mysqli because of speed or atleast write an add on to my db wrapper but I haven't learned how to use the mysqli extension as of yet and don't really have the time to do so.
__________________
"What everyone seems to forget is that while knowledge certainly is something - it's the implementation of knowledge that brings power" - Andres Galindo.
TlcAndres is offline  
Reply With Quote
Old 04-03-2008, 06:10 PM   #3 (permalink)
is cute and cuddly
 
delayedinsanity's Avatar
 
Join Date: Mar 2008
Location: Vegas, Baby
Posts: 963
Thanks: 31
delayedinsanity is on a distinguished road
Default

I actually just learned about them after picking up Larry Ullman's PHP and MySQL book. Personally I'm not using them yet because, as is probably apparent, I'm new to all of this in general, and they're also not loaded in on my test machine (lazyness is not an acceptable excuse I know, but when you're learning... ).

Trying to load them in right now on my windows system, added the php_mysqli.dll, added libMySQL.dll to the path, and changed all my functions in a class to test it, restarted everything... and... not working. Page tries to load forever, so it's trying to do something because it won't die with an error. Hmmm... oh there it just loaded. Blank. Well then.
-m
delayedinsanity is offline  
Reply With Quote
Old 04-03-2008, 06:17 PM   #4 (permalink)
is cute and cuddly
 
delayedinsanity's Avatar
 
Join Date: Mar 2008
Location: Vegas, Baby
Posts: 963
Thanks: 31
delayedinsanity is on a distinguished road
Default

Apparently it doesn't matter if I get it running on my local box, my host doesn't have it running either. Those bastards.
-m
delayedinsanity is offline  
Reply With Quote
Old 04-03-2008, 06:40 PM   #5 (permalink)
The Acquainted
 
freenity's Avatar
 
Join Date: Feb 2008
Posts: 119
Thanks: 17
freenity is on a distinguished road
Default

Quote:
Originally Posted by wGEric View Post
Looking through a lot of the code posted here I noticed most of you use the mysql functions instead of mysqli. Is there a reason for this? Seems like you guys would want to use mysqli because it can be OOP.
Hi
Could you suggest any paper to read about it?
I just heard about it, but never learn mysqli
__________________
http://feudal-times.net - My PBB Game
http://gwphp.feudal-times.net - My Blog "Gaming With PHP"
freenity is offline  
Reply With Quote
Old 04-04-2008, 02:33 AM   #6 (permalink)
The Acquainted
 
wGEric's Avatar
 
Join Date: Nov 2007
Posts: 166
Thanks: 0
wGEric is on a distinguished road
Default

Quote:
Originally Posted by freenity View Post
Hi
Could you suggest any paper to read about it?
I just heard about it, but never learn mysqli
The 'i' stands for improved. It's pretty much the same thing as the mysql functions but suppose to be better. I'm not exactly sure what has been improved.

Best place to go for documentation on mysqli is php.net.
__________________
Eric
wGEric is offline  
Reply With Quote
The Following User Says Thank You to wGEric For This Useful Post:
freenity (04-04-2008)
Old 04-06-2008, 06:00 PM   #7 (permalink)
The Frequenter
Newcomer 
 
xenon's Avatar
 
Join Date: Dec 2007
Location: Bucharest, Romania
Posts: 438
Thanks: 3
xenon is on a distinguished road
Default

If you're running PHP 5, then you'd better see PDO. Or, use an open-source ORM, like Zend_Db or Doctrine, for example.
__________________
I have optimistic thoughts, even though sometimes (if not always) life's a bitch.
xenon is offline  
Reply With Quote
Old 04-04-2008, 02:32 AM   #8 (permalink)
Orc
The Prestige
 
Orc's Avatar
 
Join Date: Dec 2007
Posts: 1,044
Thanks: 193
Orc is on a distinguished road
Default

When I'm making PHP Applications, I usually associate PHP Version, so if it's php 4, then we do the standard MySQL, if it's PHP5, then we do mysqli. I love mysqli cause you can connect everything into one class, and use it as an object:
$sql->query();
__________________
VillageIdiot can have my babbies ;d
Orc is offline  
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 06:17 AM.

 
     

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Inactive Reminders By Icora Web Design