Error Mysql PHP connection

Question

Error Mysql PHP connection

Asked 5 years, 2 months ago

Viewed 201 times

0

Good evening, everyone,

I am trying to connect my wordpress application to the remote database, so I can list users within the application.

I already tested some things between some researches, but I could not solve the problem yet.

Can anyone tell me what’s wrong with the code?

I’m using the following code:

<?php
define('hostname', 'http://thorpeinnovation.com/painfree/');
define('user', 'admin');
define('password', 'senha');
define('databaseName', 'osmoc913_wp786');
$connect = mysqli_connect(hostname, user, password, databaseName, 80) or trigger_error(mysql_error(),E_USER_ERROR);

$query = sprintf("SELECT name FROM wp2n_frm_items");

$dados = mysql_query($query, $connect) or die(mysql_error());

$linha = mysql_fetch_assoc($dados);

$total = mysql_num_rows($dados);
?>

<html>
    <head>
    <title>Exemplo</title>
</head>
<body>
<?php

    if($total > 0) {
        do {
?>
            <p><?=$linha['name']?> </p>
<?php
        }while($linha = mysql_fetch_assoc($dados));
    // fim do if 
    }
?>
</body>
</html>
<?php
mysql_free_result($dados);
?>

And it’s returning these errors:

Warning: mysqli_connect(): (HY000/2005): Unknown MySQL server host 'https://thorpeinnovation.com/painfree/wp-content/plugins/wp-phpmyadmin-extension/lib/phpMyAdmin_nwuP' (0) in /home/osmoc913/public_html/thorpeinnovation.com/painfree/wp-content/plugins/insert-php-code-snippet/shortcode-handler.php(65) : eval()'d code on line 6

Fatal error: in /home/osmoc913/public_html/thorpeinnovation.com/painfree/wp-content/plugins/insert-php-code-snippet/shortcode-handler.php(65) : eval()'d code on line 6

1 answer

Browser other questions tagged php wordpress mysqli phpmyadmin select-sql

You are not signed in. Login or sign up in order to post.

by Pedro Henrique • **1,247** points · Answer 1 · 2019-04-11T03:59:20+00:00

You must inform the address of the database (your hostname), which may be a domain, but should not contain http or paths.

define('hostname', 'thorpeinnovation.com');

If it does not work try to inform the IP address of the server.

Another thing is the function mysqli_connect, which can receive the port of the database, but it is almost never the port 80 as reported, try to change to port 3306

$connect = mysqli_connect(hostname, user, password, databaseName, 3306)

It is also valid to note that the SQL query does not seem to pull user names, unless you use a table with a different default name.

By default Wordpress uses the table PREFIX_users, in your case probably wp2n_users, column-named user_nicename.

Based on this, you may have to change the line below as well.

$query = sprintf("SELECT name FROM wp2n_frm_items");

As last tips, you don’t need this sprintf on the line above, you can only use:

$query = "SELECT name FROM wp2n_frm_items";

Also note that you use functions mysqli in some places and in other capacities mysql, try to use the variants of mysqli if possible always (mysqli_query, mysqli_fetch_assoc, mysqli_num_rows).

Source: https://usersinsights.com/wordpress-user-database-tables/