[SOLVED] HELP mysqli_connect() problem. Different to the one in the Faq section

[xkyogre]

Whenever I use a mysqli_connect() function in my programs the browser goes blank but when iI take away that function everything else works perfectly.

Why is this happening?

How do I solve it

[Wildbug]

Check for errors and post code.

[wildteen88]

Whenever I use a mysqli_connect() function in my programs the browser goes blank but when iI take away that function everything else works perfectly.

Why is this happening?

How do I solve it

Add the following two lines of code at the top of the page which gives a blank page:

display_errors('1');
error_reporting(E_ALL);

 

Retest. Do you get any error messages now? If you do post all errors here in full.

[xkyogre]

The browser window still stays blank when you type in http://localhost/Crime.php

which is the directory of the file.

I tried to add

display_errors('1');

error_reporting(E_ALL);

but nothing changed.

Any more suggestions???

[Wildbug]

Try checking mysqli_error and mysqli_connect_error()

[xkyogre]

The screen goes blank even if I  make a new document with just mysqli_connect_error() in it.

However, if I put phpinfo() it works fine.

I think its the mysqli functions but I configured php as all the books and tutorials told me.

[Wildbug]

Is there a mysqli section in the phpinfo output?

[xkyogre]

No there isn't. Should there be one?

[Wildbug]

There is in mine.  I wonder why you're not getting any errors such as "function not found" or something.  It looks like you need to install mysqli

[xkyogre]

i done what it said on the link but still nothing has changed

[Wildbug]

Is it enabled in php.ini?

[xkyogre]

Yes but it isn't in safe mode. Could that be the cause of the problem?

[Wildbug]

You mean PHP isn't running in safe mode?  I don't think that would cause it.

 

What OS are you running PHP on?  Can you post your connection code?

[xkyogre]

Microsoft windows 2000 sp4 whot do you mean connection code???

The mysql tcp port is 3306

[per1os]

What version of PHP are you running? mysqli is only supported for PHP 5

[Wildbug]

whot do you mean connection code???

 

I mean the code you are using to connect that is failing.

 

(I didn't know about requiring PHP 5.0+.  That very well may be it.)

[per1os]

mysqli_connect,

 

(PHP 5)

 

mysqli_connect, mysqli->__construct() — Open a new connection to the MySQL server

Description

 

http://us.php.net/manual/en/function.mysqli-connect.php

 

Yep only PHP 5 can use mysqli.

[xkyogre]

I am using php 5. What does the code above do

[Wildbug]

Can you post the code surrounding and including your failed call to mysqli_connect(), please?

[xkyogre]

Thank you using the code above it solved my problem.

The only thing is how do I say that this topic is solved?

[Wildbug]

There's a link around the bottom of the page somewhere that will mark the topic solved.

[xkyogre]

Thanks again