LinuxQuestions.org
Review your favorite Linux distribution.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 04-02-2008, 08:31 AM   #1
helptonewbie
Member
 
Registered: Aug 2006
Location: England Somewhere
Distribution: Mandriva, PCLinuxOS, Karoshi, Suse, Redhat, Ubuntu
Posts: 518

Rep: Reputation: 39
Question Php and MySQL Whats this New stuff (Mysqli)?


Hi All,
I've been beginning to delve into the world of mysql and php, and looking at it again now i'm seeing things like mysqli being i believe something php have created as an edition to the latest php and mysql versions. I'm not understanding quite how this works...basically i believe previously to get php working and talk to mysql you required to have mysql installed on ther server php was running on so you were able to build php to use the mysql client libraries used for connections to the remote MySQL server. Now am i right in thinking this is no longer the case and that php can be built with some form of mysql stuff (mysqli) and various other bits, and i don't need to run up MySQL client libraries at all to enable php to connect to Mysql. Is this correct does that all sound about right. i'm a little new to the MySQL php thing so some guidance is appreciated.

Cheers all

ps - i believe its php's replacement to mysql libraries however if you require it you can also still have php build with the libraries as well and therefore have both methods available to use, the extra functions the php mysqli stuff provides as well as the normal method. If that sounds along the correct lines?
 
Old 04-03-2008, 12:46 PM   #2
kotnik
Member
 
Registered: Nov 2004
Location: Novi Sad, Serbia
Distribution: Debian, Slackware, Gentoo, openSuSE
Posts: 254

Rep: Reputation: 31
If you use MySQL 4.1 or higher, than use MySQLi. It's just improved interface to MySQL, hence 'i'.
 
Old 04-03-2008, 12:53 PM   #3
prad77
Member
 
Registered: Mar 2008
Posts: 101

Rep: Reputation: 15
MySQLi is an improved database layer for PHP 5 and MySQL 4.1+.
It is recommended that MySQLi be used if your MySQL server is at version 4.1 or higher !

Gentoo

Last edited by prad77; 04-17-2008 at 03:38 AM.
 
Old 04-03-2008, 01:25 PM   #4
helptonewbie
Member
 
Registered: Aug 2006
Location: England Somewhere
Distribution: Mandriva, PCLinuxOS, Karoshi, Suse, Redhat, Ubuntu
Posts: 518

Original Poster
Rep: Reputation: 39
perhaps i wasn't quite clear enough what i'm really trying to find out is if installing php with mysqli is all i need to do to be able to get php and mysql working together or if i still need to point php at the ./configure point to the mysql client libraries??

Cheers
 
Old 04-04-2008, 09:51 AM   #5
kotnik
Member
 
Registered: Nov 2004
Location: Novi Sad, Serbia
Distribution: Debian, Slackware, Gentoo, openSuSE
Posts: 254

Rep: Reputation: 31
Yes.

Installing PHP with mysqli enabled is all you need to start coding.
 
Old 04-04-2008, 10:59 AM   #6
helptonewbie
Member
 
Registered: Aug 2006
Location: England Somewhere
Distribution: Mandriva, PCLinuxOS, Karoshi, Suse, Redhat, Ubuntu
Posts: 518

Original Poster
Rep: Reputation: 39
thanks...thats kind of how i understood it but i'm just making sure.

Thanks Again
 
  


Reply



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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP - mysqli_connect doesn't exist but mysqli is enabled? Splenden Linux - Server 2 04-23-2012 10:39 PM
apache 2.0 + PHP 5 + mysql AND mysqli? nyttoc Linux - Server 1 05-08-2007 08:28 AM
LXer: Performing Basic Tasks with MySQL 4.1 and Above, using mysqli with ... LXer Syndicated Linux News 0 07-02-2006 09:33 PM
MySQL php database and financial stuff esteeven Linux - Software 1 11-06-2003 03:35 AM
ok whats with all this ISO. md5 stuff Shrike Slackware 2 10-25-2003 05:52 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:44 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration