mysqli transition

[laulau]

Hi,
I'm trying to convert some of my scripts using mysql to mysqli. (it's time )
I have a problem with a request that works in phpmyadmin but when calling from a php script I have an error:

ERROR - Bad Select Statement: SELECT UNIX_TIMESTAMP(LogDateTime), Temp, Hum FROM AllCdata WHERE LogDateTime > (SELECT MAX(LogDateTime) - INTERVAL 12 day FROM AllCdata) ORDER BY LogDateTime ASC

this query is working with mysql , but isn't with mysqli !

[laulau]

Hi,
No SQL Guru ? who can tell me where to look

[mcrossley]

Perhaps you could post the actual code that sends the command, the SQL statement looks OK to me.

[laulau]

Hi,
with mysqli not working http://meteo.laurentmey.fr/sqli/monthLo ... p?view=sce
old mysql : http://meteo.laurentmey.fr/sqli/monthLo ... p?view=sce
The basic script is yours
Thanks

[kocher]

Good morning Laurent

I think for the modification to work you must also modify the connection file:

As an example I put two connection files to the same database, but one is mysql and the other is mysqli:

1): mysql

Code: Select all

<?php
$server ="your server";
$user="user";
$pass="your password";
$db="your database";
mysql_connect($server,$user,$pass) or die ("Erreur SQL : ".mysql_error() );
mysql_select_db($db) or die ("Erreur SQL : ".mysql_error() );
?>

2): mysqli

Code: Select all

<?php
$server ="your server;
$user = "user";
$pwd = "your password";
$db ="your database";
$conn=mysqli_connect($server,$user,$pwd,$db);
If(! $conn) {
exit("Echec de la connexion");
}
?>

Then you have to check that this connection file works correctly.

[laulau]

I don't understand.
I have the script to insert the realtime.txt in realtime database working well with mysqli !

begin: Running from web server
Script start: 19/03/20 - 14:29:26
Importing file: ../../cm1/realtime.txt, To table: Realtime ...
Connected to database OK.
Set MySQL TZ OK.
Processing realtime file...
Target table already exists.
Prepared SQL statement OK.
Inserting data...
Data insert done, 1 rows inserted
Deleting old realtime records...
done. Deleted 1 old rows.
Script complete: 19/03/20 - 14:29:26
Execution time: 0 secs
end

[Mapantz]

I don't have time to check what's different, but i've uploaded the one I use.

It works fine on the latest version of PHP.

realtimeLogSql.txt

[mcrossley]

It is essentially the same as my current version of that script that I use on my home page - the resulting SQL query is the same, and it is working with mysqli for me?

I'm currently using MariaDB 10.1

[mcrossley]

Ah! You are not connecting to a database, you just connect to the server. So like kocher said above. You have...

Code: Select all

// Connect to the datbase
$mysqli = new mysqli($dbhost, $dbuser, $dbpassword);
if ($mysqli->connect_errno) {
	die('Failed to connect to the database server');
}

But then no database connect. I do it one call like this...

Code: Select all

// Connect to the datbase
$mysqli = new mysqli($dbhost, $dbuser, $dbpassword, $database);
if ($mysqli->connect_errno) {
	die('Failed to connect to the database server');
}

[laulau]

Thanks
I don't see that $database was missing !