Re: problem in connecting to mysql from php
| From: | Richard Quadling | Date: | Mon, 13 Jun 2011 12:35:40 +0000 |
| Subject: | Re: problem in connecting to mysql from php | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47844@lists.php.net to get a copy of this message | ||
On 13 June 2011 13:26, C0mf0rtably Numb <08.kushal@gmail.com> wrote:
> Okay. I tried using that too. If I run this:
> <?php
> $link = mysql_connect('localhost', 'root',
>
> 'Password123');
> if (!$link) {
> die('Could not connect: ' . mysql_error());
> }
> echo 'Connected successfully';
> mysql_close($link);
> ?>
>
> I get the error: *Fatal error*: Call to undefined function mysql_connect()
> in *C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\a.php* on
> line *2
>
> *I think there is something wrong with my configuration.
>
> On Mon, Jun 13, 2011 at 6:00 PM, mrfroasty <mrfroasty@gmail.com> wrote:
>
>> Your error message is about class not found.That means there is no class
>> named "MySQLi".Please use a textbook with online manual
>> http://www.php.net/manual/en/ref.mysql.php
>>
>> On 06/13/2011 02:08 PM, C0mf0rtably Numb wrote:
>> > Hello everyone,
>> >
>> > I am in the process of learning php and I was trying to connect to a
>> mysql
>> > database on my own computer(localhost). I have done the following as
>> > prerequisites:
>> >
>> > copied the dll files in system32
>> > removed the semicolon(;) from extension=php_mysqli.dll
>> >
>> > In spite of doing the above when I try to run the following :
>> >
>> > <?php
>> > $db = new MySQLi('localhost', 'root', 'Password123',
>> > 'test');
>> > $sql = 'SELECT * FROM a123';
>> > $result = $db->query($sql);
>> >
>> > while($row = $result->fetch_object()) {
>> > echo '<div>' . $row->name . '</div>';
>> > }
>> >
>> > $db->close();
>> > ?>
>> >
>> > I get the error: *Fatal error*: Class 'MySQLi' not found in *C:\Program
>> > Files\Apache Software Foundation\Apache2.2\htdocs\a.php* on line *2
>> >
>> > *Please guide me as to how can I get rid of this error?
>> >
>> > Regards,
>> > Kushal
>> >
>>
>>
>> --
>> Extra details:
>> OSS:Gentoo Linux
>> profile:x86
>> Hardware:msi geforce 8600GT asus p5k-se
>> location:/home/muhsin
>> language(s):C/C++,PHP,SQL,HTML
>> Typo:40WPM
>> url:http://www.mzalendo.net
>> url:http://www.zanbytes.com
>>
>>
>>
>>
>
Copying the files to windows\system ... what files? Where were you
told to do this?
Normally the extension files you need for PHP are in C:\PHP5\ext (or PHPx).
I've never copied a single file into my Windows folder for PHP.
--
Richard Quadling
Twitter : EE : Zend : PHPDoc
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea