Re: Getting PHP 5 w/mysqli to communicate with MySQL 5

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



did you turn on display_errors and set error reporting to E_ALL in php.ini?
if not you should

On 1/20/06, Allen Schultz <allen.schultz@xxxxxxxxx> wrote:
>
> Sorry, I was in a rush to work guys.
>
> All these were downloaded pre-compliled for Win32.
> Apache 2.0.55
> PHP 5.1.1 w/php_mysqli.dll (improved mysql)
> MySQL 5.0.18
>
> This script:
>
> <html><head></head><body>
> <?php
> $link = mysqli_connect('localhost','root','xxxxxx');
> if (mysqli_connect_errno()) {
> echo "error";
> exit();
> } else { echo "no error"; }
> ?>
> </body></html>
>
> turns into this:
>
> <html><head></head><body>
> no error
> </body></html>
>
> And this script:
>
> <html><head></head><body>
> <?php
> $link = mysqli_connect('localhost','root','xxxxxx');
> if (mysqli_connect_errno()) {
> echo "error";
> exit();
> }
> if (!mysqli_select_db($link,"pers")) {
> echo "pers not found"; }
> else {
> if ($result = mysqli_multi_query($link, "select helloworld();")) {
>    $row = mysqli_fetch_array($result, MYSQLI_NUM);
>    echo $row[0];
> } else { echo "problem :("; }
> }
> ?>
> </body></html>
>
> turns to this:
>
> <html><head></head><body>
> </body></html>
>
> In summary again, It seems to want to connect to the database, but
> doesnt see anything after connecting using mysqli functions. That
> helloworld() function in the database exists.
> I'm following this page for a tutorial to find out why I cant use the
> database:
>
> http://mysql.gilfster.com/page.php?parent_id=4&page_id=4.0.2
>
> On 1/19/06, Julien Bonastre <julien@xxxxxxxxxxxxxxxx> wrote:
> > If you only compiled php with the mysqli libraries then you need to use
> > them
> >
> > What exactly are you have troubles with? A code snippet or version
> > examples would be good. Also is your database mysql5 engine I take it?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--
Hi Everyone, I am running PHP 5 on Windosws XP SP2 with MySQL5, Bye Now!

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux