Unable to connect to mysqli database through php
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I am working on a website where it has just had its php updated so now the custom plugin wont connect to the database. Originally I was getting an error saying the mysql() function was not defined so I changed it to mysqli() now that error has gone but I still cannot connect. I have checked and I have mysqli activated.
heres my code:
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-config.php' );
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-includes/wp-db.php' );
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
die('Not connected : ' . mysqli_error());
}
if (! mysqli_select_db(DB_NAME)) {
die ('Can't use db : ' . mysqli_error());
}
All I keep getting is 'Can't use db:'. I have also tried defining the DB_HOST ect and that didn't work. Any ideas?
php mysql database
asked Nov 22 '18 at 10:22
ReeceReece
74221028
add a comment |
I am working on a website where it has just had its php updated so now the custom plugin wont connect to the database. Originally I was getting an error saying the mysql() function was not defined so I changed it to mysqli() now that error has gone but I still cannot connect. I have checked and I have mysqli activated.
heres my code:
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-config.php' );
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-includes/wp-db.php' );
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
die('Not connected : ' . mysqli_error());
}
if (! mysqli_select_db(DB_NAME)) {
die ('Can't use db : ' . mysqli_error());
}
All I keep getting is 'Can't use db:'. I have also tried defining the DB_HOST ect and that didn't work. Any ideas?
php mysql database
asked Nov 22 '18 at 10:22
ReeceReece
74221028
is your DB_NAME defined?
– matiit
Nov 22 '18 at 10:23
Try tu put the db_name inside the mysqli_connect function mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db")
– ErDiablo
Nov 22 '18 at 10:24
1
mysqli_error()needs the database link to report the error - which if the connection fails is not going to happen - usemysqli_connect_error()instead. (Note that all calls tomysqli_error()will need to be updated with the connection)
– Nigel Ren
Nov 22 '18 at 10:24
what's output ofecho DB_NAME;
– Robert
Nov 22 '18 at 10:24
@matiit Thanks but I have already tried putting DB_NAME inside the function I still got the same result
– Reece
Nov 22 '18 at 10:28
add a comment |
I am working on a website where it has just had its php updated so now the custom plugin wont connect to the database. Originally I was getting an error saying the mysql() function was not defined so I changed it to mysqli() now that error has gone but I still cannot connect. I have checked and I have mysqli activated.
heres my code:
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-config.php' );
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-includes/wp-db.php' );
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
die('Not connected : ' . mysqli_error());
}
if (! mysqli_select_db(DB_NAME)) {
die ('Can't use db : ' . mysqli_error());
}
All I keep getting is 'Can't use db:'. I have also tried defining the DB_HOST ect and that didn't work. Any ideas?
php mysql database
asked Nov 22 '18 at 10:22
ReeceReece
74221028
I am working on a website where it has just had its php updated so now the custom plugin wont connect to the database. Originally I was getting an error saying the mysql() function was not defined so I changed it to mysqli() now that error has gone but I still cannot connect. I have checked and I have mysqli activated.
heres my code:
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-config.php' );
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-includes/wp-db.php' );
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
die('Not connected : ' . mysqli_error());
}
if (! mysqli_select_db(DB_NAME)) {
die ('Can't use db : ' . mysqli_error());
}
All I keep getting is 'Can't use db:'. I have also tried defining the DB_HOST ect and that didn't work. Any ideas?
php mysql database
php mysql database
asked Nov 22 '18 at 10:22
ReeceReece
74221028
asked Nov 22 '18 at 10:22
ReeceReece
74221028
asked Nov 22 '18 at 10:22
ReeceReece
74221028
asked Nov 22 '18 at 10:22
ReeceReece
74221028
asked Nov 22 '18 at 10:22
ReeceReece
74221028
74221028
is your DB_NAME defined?
– matiit
Nov 22 '18 at 10:23
Try tu put the db_name inside the mysqli_connect function mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db")
– ErDiablo
Nov 22 '18 at 10:24
1
mysqli_error()needs the database link to report the error - which if the connection fails is not going to happen - usemysqli_connect_error()instead. (Note that all calls tomysqli_error()will need to be updated with the connection)
– Nigel Ren
Nov 22 '18 at 10:24
what's output ofecho DB_NAME;
– Robert
Nov 22 '18 at 10:24
@matiit Thanks but I have already tried putting DB_NAME inside the function I still got the same result
– Reece
Nov 22 '18 at 10:28
add a comment |
is your DB_NAME defined?
– matiit
Nov 22 '18 at 10:23
Try tu put the db_name inside the mysqli_connect function mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db")
– ErDiablo
Nov 22 '18 at 10:24
1
mysqli_error()needs the database link to report the error - which if the connection fails is not going to happen - usemysqli_connect_error()instead. (Note that all calls tomysqli_error()will need to be updated with the connection)
– Nigel Ren
Nov 22 '18 at 10:24
what's output ofecho DB_NAME;
– Robert
Nov 22 '18 at 10:24
@matiit Thanks but I have already tried putting DB_NAME inside the function I still got the same result
– Reece
Nov 22 '18 at 10:28
is your DB_NAME defined?
– matiit
Nov 22 '18 at 10:23
is your DB_NAME defined?
– matiit
Nov 22 '18 at 10:23
Try tu put the db_name inside the mysqli_connect function mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db")
– ErDiablo
Nov 22 '18 at 10:24
Try tu put the db_name inside the mysqli_connect function mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db")
– ErDiablo
Nov 22 '18 at 10:24
1
1
mysqli_error() needs the database link to report the error - which if the connection fails is not going to happen - use mysqli_connect_error() instead. (Note that all calls to mysqli_error() will need to be updated with the connection)– Nigel Ren
Nov 22 '18 at 10:24
mysqli_error() needs the database link to report the error - which if the connection fails is not going to happen - use mysqli_connect_error() instead. (Note that all calls to mysqli_error() will need to be updated with the connection)– Nigel Ren
Nov 22 '18 at 10:24
what's output of
echo DB_NAME;– Robert
Nov 22 '18 at 10:24
what's output of
echo DB_NAME;– Robert
Nov 22 '18 at 10:24
@matiit Thanks but I have already tried putting DB_NAME inside the function I still got the same result
– Reece
Nov 22 '18 at 10:28
@matiit Thanks but I have already tried putting DB_NAME inside the function I still got the same result
– Reece
Nov 22 '18 at 10:28
add a comment |
2 Answers
2
active
oldest
votes
mysqli_select_db expects the first argument to be a MySQL link, try the following:
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-config.php' );
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-includes/wp-db.php' );
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
die('Not connected : ' . mysqli_error());
}
if (! mysqli_select_db($link, DB_NAME)) {
die ('Can't use db : ' . mysqli_error());
}
For the future, I would recommend you to read about error reporting in PHP, it will help you to spot such mistakes much quicker.
answered Nov 22 '18 at 10:25
matiitmatiit
5,90053258
... just like the calls tomysqli_error()?
– Nigel Ren
Nov 22 '18 at 10:27
Thanks this fixed my issue
– Reece
Nov 22 '18 at 10:30
add a comment |
if you use mysqli_error() you would have to give the latest function with it.
in you case mysqli_error($link)
answered Nov 22 '18 at 10:35
PatrickStelPatrickStel
318
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53428746%2funable-to-connect-to-mysqli-database-through-php%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
mysqli_select_db expects the first argument to be a MySQL link, try the following:
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-config.php' );
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-includes/wp-db.php' );
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
die('Not connected : ' . mysqli_error());
}
if (! mysqli_select_db($link, DB_NAME)) {
die ('Can't use db : ' . mysqli_error());
}
For the future, I would recommend you to read about error reporting in PHP, it will help you to spot such mistakes much quicker.
answered Nov 22 '18 at 10:25
matiitmatiit
5,90053258
... just like the calls tomysqli_error()?
– Nigel Ren
Nov 22 '18 at 10:27
Thanks this fixed my issue
– Reece
Nov 22 '18 at 10:30
add a comment |
mysqli_select_db expects the first argument to be a MySQL link, try the following:
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-config.php' );
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-includes/wp-db.php' );
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
die('Not connected : ' . mysqli_error());
}
if (! mysqli_select_db($link, DB_NAME)) {
die ('Can't use db : ' . mysqli_error());
}
For the future, I would recommend you to read about error reporting in PHP, it will help you to spot such mistakes much quicker.
answered Nov 22 '18 at 10:25
matiitmatiit
5,90053258
... just like the calls tomysqli_error()?
– Nigel Ren
Nov 22 '18 at 10:27
Thanks this fixed my issue
– Reece
Nov 22 '18 at 10:30
add a comment |
mysqli_select_db expects the first argument to be a MySQL link, try the following:
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-config.php' );
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-includes/wp-db.php' );
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
die('Not connected : ' . mysqli_error());
}
if (! mysqli_select_db($link, DB_NAME)) {
die ('Can't use db : ' . mysqli_error());
}
For the future, I would recommend you to read about error reporting in PHP, it will help you to spot such mistakes much quicker.
answered Nov 22 '18 at 10:25
matiitmatiit
5,90053258
mysqli_select_db expects the first argument to be a MySQL link, try the following:
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-config.php' );
require_once( $_SERVER['DOCUMENT_ROOT'] . '/wp-includes/wp-db.php' );
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
die('Not connected : ' . mysqli_error());
}
if (! mysqli_select_db($link, DB_NAME)) {
die ('Can't use db : ' . mysqli_error());
}
For the future, I would recommend you to read about error reporting in PHP, it will help you to spot such mistakes much quicker.
answered Nov 22 '18 at 10:25
matiitmatiit
5,90053258
answered Nov 22 '18 at 10:25
matiitmatiit
5,90053258
answered Nov 22 '18 at 10:25
matiitmatiit
5,90053258
answered Nov 22 '18 at 10:25
matiitmatiit
5,90053258
5,90053258
... just like the calls tomysqli_error()?
– Nigel Ren
Nov 22 '18 at 10:27
Thanks this fixed my issue
– Reece
Nov 22 '18 at 10:30
add a comment |
... just like the calls tomysqli_error()?
– Nigel Ren
Nov 22 '18 at 10:27
Thanks this fixed my issue
– Reece
Nov 22 '18 at 10:30
... just like the calls to
mysqli_error()?– Nigel Ren
Nov 22 '18 at 10:27
... just like the calls to
mysqli_error()?– Nigel Ren
Nov 22 '18 at 10:27
Thanks this fixed my issue
– Reece
Nov 22 '18 at 10:30
Thanks this fixed my issue
– Reece
Nov 22 '18 at 10:30
add a comment |
if you use mysqli_error() you would have to give the latest function with it.
in you case mysqli_error($link)
answered Nov 22 '18 at 10:35
PatrickStelPatrickStel
318
add a comment |
if you use mysqli_error() you would have to give the latest function with it.
in you case mysqli_error($link)
answered Nov 22 '18 at 10:35
PatrickStelPatrickStel
318
add a comment |
if you use mysqli_error() you would have to give the latest function with it.
in you case mysqli_error($link)
answered Nov 22 '18 at 10:35
PatrickStelPatrickStel
318
if you use mysqli_error() you would have to give the latest function with it.
in you case mysqli_error($link)
answered Nov 22 '18 at 10:35
PatrickStelPatrickStel
318
answered Nov 22 '18 at 10:35
PatrickStelPatrickStel
318
answered Nov 22 '18 at 10:35
PatrickStelPatrickStel
318
answered Nov 22 '18 at 10:35
PatrickStelPatrickStel
318
318
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53428746%2funable-to-connect-to-mysqli-database-through-php%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
is your DB_NAME defined?
– matiit
Nov 22 '18 at 10:23
Try tu put the db_name inside the mysqli_connect function mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db")
– ErDiablo
Nov 22 '18 at 10:24
1
mysqli_error()needs the database link to report the error - which if the connection fails is not going to happen - usemysqli_connect_error()instead. (Note that all calls tomysqli_error()will need to be updated with the connection)– Nigel Ren
Nov 22 '18 at 10:24
what's output of
echo DB_NAME;– Robert
Nov 22 '18 at 10:24
@matiit Thanks but I have already tried putting DB_NAME inside the function I still got the same result
– Reece
Nov 22 '18 at 10:28