Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > PHP connection mysql database problem

PHP connection mysql database problem

WBOY
Release： 2016-08-04 09:22:07
Original
1112 people have browsed it

Database connection code: 

<code>$server="localhost";
$username="root";
$password="";
$database="library";

$conn=mysqli_connect($server,$username,$password);
if (!$conn) {
    die("mysqli_connect failed".mysql_error());
}
$db_selected = mysql_select_db($database,$conn);
if (!$db_selected) {
    die("select db error:".mysql_error());
}</code>
Copy after login
Copy after login

The connection returns a prompt: select db error:
Why is this? Navicat can be used to connect to the library database.

Reply content:

Database connection code: 

<code>$server="localhost";
$username="root";
$password="";
$database="library";

$conn=mysqli_connect($server,$username,$password);
if (!$conn) {
    die("mysqli_connect failed".mysql_error());
}
$db_selected = mysql_select_db($database,$conn);
if (!$db_selected) {
    die("select db error:".mysql_error());
}</code>
Copy after login
Copy after login

The connection returns a prompt: select db error:
Why is this? Navicat can be used to connect to the library database.

$db_selected = mysql_select_db($database,$conn);

Change to $db_selected = mysqli_select_db($database,$conn);

Yes, you wrote mysqli as mysql

Related labels：
mysql php connect
source：php.cn
Previous article：Are regular expressions in java the same as regular expressions in JavaScript? Is it the same as in php etc.? Next article：When using miniui treegrid1, the interface will be requested twice, as shown in the code;
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template