Android Question I need help to make a php file using MySQLi commands

Espinosa4 · May 15, 2016

Hello everyone.

I moved my database from the a site to a new one. Now I have one error when I am trying to connect with my database.

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in

Can you help me to make a new one please? A conversión?
For me is very complicated. I am little by little learning things but still need a lot of help. I looked for info in our forum but I couldn't find anything.

Thank you very much indeed!

PHP:

<?
$databasehost = "host";
$databasename = "db";
$databaseusername = "user";
$databasepassword = "pass";
$con = mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());
mysql_select_db($databasename) or die(mysql_error());
mysql_query("SET CHARACTER SET utf8");
$query = file_get_contents("php://input");
$sth = mysql_query($query);
if (mysql_errno()) {
    header("HTTP/1.1 500 Internal Server Error");
    echo $query.'\n';
    echo mysql_error();
}
else
{
    $rows = array();
    while($r = mysql_fetch_assoc($sth)) {
        $rows[] = $r;
    }
    print json_encode($rows);
}
?>

DonManfred · May 15, 2016

Get inspired here for ex.

https://github.com/joshcam/PHP-MySQLi-Database-Class

Espinosa4 · May 15, 2016

DonManfred said:
Get inspired here for ex.

https://github.com/joshcam/PHP-MySQLi-Database-Class

Once again many thanks DonManfred!
Interesting reading but is more orientated to sql sentences. I make the sentence in my program but I connected the database using mysqli but I can write correctly the json parameters into the php file.

Thanks

DonManfred · May 15, 2016

just google for mysqlI samples... I´m sure you can find some good tutorials as thre are alot of it

Espinosa4 · May 15, 2016

Ummmm I am still looking info around the world but no results at the moment it is for that reason I wrote here my question.

Many thanks for your help and advises. Very appreciated for me.

KMatle · May 15, 2016

It's all about:

- adding an i to the commands: mysql_query -> mysqli_query
- adding the connection (e.g. "$con" to the command:

$con = mysqli_connect($host,$user,$pw) or die(mysqli_error());
mysqli_select_db($con,$db) or die(mysqli_error());
mysqli_query($con,"SET CHARACTER SET utf8");
mysqli_query($con,"SET NAMES 'utf8'");

B4X:

<?
$databasehost = "host";
$databasename = "db";
$databaseusername = "user";
$databasepassword = "pass";
$con = mysqli_connect($databasehost,$databaseusername,$databasepassword) or die(mysqli_error());
mysqli_select_db($con, $databasename) or die(mysqli_error());
mysqli_query($con, "SET CHARACTER SET utf8");
$query = file_get_contents("php://input");
$sth = mysqli_query($con, $query);
if (mysql_errno()) {
    header("HTTP/1.1 500 Internal Server Error");
    echo $query.'\n';
    echo mysqli_error();
}
else
{
    $rows = array();
    while($r = mysqli_fetch_assoc($con, $sth)) {
        $rows[] = $r;
    }
    print json_encode($rows);
}
?>

Espinosa4 · May 15, 2016

KMatle said:
It's all about:

- adding an i to the commands: mysql_query -> mysqli_query
- adding the connection (e.g. "$con" to the command:

$con = mysqli_connect($host,$user,$pw) or die(mysqli_error());
mysqli_select_db($con,$db) or die(mysqli_error());
mysqli_query($con,"SET CHARACTER SET utf8");
mysqli_query($con,"SET NAMES 'utf8'");

B4X:

<? $databasehost = "host"; $databasename = "db"; $databaseusername = "user"; $databasepassword = "pass"; $con = mysqli_connect($databasehost,$databaseusername,$databasepassword) or die(mysqli_error()); mysqli_select_db($con, $databasename) or die(mysqli_error()); mysqli_query($con, "SET CHARACTER SET utf8"); $query = file_get_contents("php://input"); $sth = mysqli_query($con, $query); if (mysql_errno()) { header("HTTP/1.1 500 Internal Server Error"); echo $query.'\n'; echo mysqli_error(); } else { $rows = array(); while($r = mysqli_fetch_assoc($con, $sth)) { $rows[] = $r; } print json_encode($rows); } ?>

Hi KMatle!
Many many thanks for your reply. I am still learning and I need to see examples to understand how it works.

Thank you very much indeed!
Best regards

PS I tried to add the i but some commands give me some parameters error (numbers). Still learning sorry.

KMatle · May 15, 2016

Espinosa4 said:
I am still learning and I need to see examples to understand how it works.

Yep. As Manfred said it's good to browse for examples. An excellent site is: http://www.w3schools.com/php/php_examples.asp

Espinosa4 · May 15, 2016

Sure. Ive just read something from there and it is very interesting. I am learning basically seeing example but sometimes I can't fine the exactly thing I need. But... With your advices (thanks to you all for expending your time with us) little by little we have more knowledge.

Thanks

Espinosa4 · May 15, 2016

qqq

KMatle said:
Yep. As Manfred said it's good to browse for examples. An excellent site is: http://www.w3schools.com/php/php_examples.asp

Hi again KMatle

Can you help one more time please?

The php return this warning
Warning: mysqli_query(): Empty query in /home/u703357939/public_html/linea4vlc.php on line 12

Warning: mysqli_fetch_assoc() expects exactly 1 parameter, 2 given in /home/u703357939/public_html/linea4vlc.php on line 21

I am study the functioin mysqli_fetch_assoc()

I retouched the line like this...
while($r = mysqli_fetch_assoc($sth)) {

but nothing happen.
I am blind in this area. Sorry
Thank you!!!

Android Question I need help to make a php file using MySQLi commands

Espinosa4

Active Member

DonManfred

Expert

Espinosa4

Active Member

DonManfred

Expert

Espinosa4

Active Member

KMatle

Expert

Espinosa4

Active Member

KMatle

Expert

Espinosa4

Active Member

Espinosa4

Active Member

Similar Threads

Android Question I need help to make a php file using MySQLi commands

Active Member

Expert

Active Member

Expert

Active Member

Expert

Active Member

Expert

Active Member

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency