php-windows Digest 7 Sep 2008 02:54:41 -0000 Issue 3516
Topics (messages 29020 through 29022):
Re: MySQL and PHP5
29020 by: Tim
29021 by: Elizabeth M Smith
29022 by: Tim
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
I spoke to soon. Your tip did manage to get the MySQL section to show up in
the output of phpinfo(), and the connect command doesn't throw an error
anymore, but now I get the same Undefined Function error on the line to
create a db:
mysql_create_db("dbName") or die(mysql_error());
Why would it be letting my connect command pass without an error, but this
line generate the error?
""Tim"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> That was it! Thank you so much!
>
> I'm working through a tutorial/book, and the text didn't even mention
> this!
>
> Wow, good tip for newbies!
>
> Thanks again!
>
> Tim R.
> "Elizabeth M Smith" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>>
>>> However, the results of my phpinfo() do not show a MySQL section (I
>>> don't
>>> know if there should be one, I'm new to this).
>>
>> Mysql should show up - one piece of information that I DON'T see that is
>> probably the most important - is your php.ini being loaded? You should
>> see a section in the top of your phpinfo() page telling you where it's
>> looking for php.ini, and which one is being loaded.
>>
>> If you're using apache the easiest way to MAKE SURE you're getting the
>> right php.ini discovered and used is to place the following in your
>> httpd.conf file
>>
>> PHPIniDir "C:\php\"
>>
>> and restart your server - if you've altered your PATH recently might be
>> smart to reboot your machine - windows can be a bit flakey.
>>
>>> Is there something I am missing? I had heard that you need to compile
>>> php
>>> yourself if you want MySQL.
>>
>> Only on *nix machines - PHP provides binaries for windows so you don't
>> have to compile anything.
>>
>> Thanks,
>> Elizabeth
>
>
--- End Message ---
--- Begin Message ---
Tim wrote:
> I spoke to soon. Your tip did manage to get the MySQL section to show up in
> the output of phpinfo(), and the connect command doesn't throw an error
> anymore, but now I get the same Undefined Function error on the line to
> create a db:
>
> mysql_create_db("dbName") or die(mysql_error());
>
> Why would it be letting my connect command pass without an error, but this
> line generate the error?
>
Because mysql_create_db doesn't exist for mysql client libs above 4.0 -
read the documentation at php.net please
If you want to create a db, do a CREATE DATABASE query
Thanks,
Elizabeth Smith
--- End Message ---
--- Begin Message ---
Thanks, again, Elizabeth! Makes sense. I hadn't started the documentation
yet because I was trying to get a working understanding of things first by
going through a tutorial. I realize now that my tutorial was for an earlier
version of PHP and MySQL, so things like this are going to be a problem.
Anyway, thanks for setting me straight.
Tim R.
"Elizabeth M Smith" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Tim wrote:
>> I spoke to soon. Your tip did manage to get the MySQL section to show up
>> in
>> the output of phpinfo(), and the connect command doesn't throw an error
>> anymore, but now I get the same Undefined Function error on the line to
>> create a db:
>>
>> mysql_create_db("dbName") or die(mysql_error());
>>
>> Why would it be letting my connect command pass without an error, but
>> this
>> line generate the error?
>>
>
> Because mysql_create_db doesn't exist for mysql client libs above 4.0 -
> read the documentation at php.net please
>
> If you want to create a db, do a CREATE DATABASE query
>
> Thanks,
> Elizabeth Smith
--- End Message ---
