MYSQL > MARIADB avec INSERT INTO et UPDATE
bonjour,
voila un script qui fonctionnait avant sous MySQL, mais devant changer de serveur, j'ai maintenant une base MariDB.
Ces lignes ne semblent pas fonctionner ... bon, je suis "bas niveau" en php et autre ... mais j'essaie ...
pouvez vous m'aider ??
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
| include("functions.php");
include_once($installed_config_file);
$id=$_POST['id'];
$name=$_POST['name'];
$scriptpath=$_POST['scriptpath'];
$hours=$_POST['hours'];
$days=$_POST['days'];
$weeks=$_POST['weeks'];
$time_last_fired=$_POST['time_last_fired'];
if ($hours>0) $time_interval=$hours * 3600;
elseif ($days>0) $time_interval=$days * 86400;
else $time_interval=$weeks * 604800;
if ($id>0)
{
$fire_time = $time_last_fired + $time_interval;
$query="UPDATE table1
SET
name='$name',
scriptpath='$scriptpath',
time_interval='$time_interval',
fire_time='$fire_time',
time_last_fired='$time_last_fired'
WHERE id='$id'";
}
else
{
$time_last_fired = time();
$fire_time = $time_last_fired + $time_interval;
$query="INSERT INTO table1
(scriptpath, name, time_interval, fire_time, time_last_fired)
VALUES
('$scriptpath','$name','$time_interval','$fire_time','$time_last_fired')";
}
db_connect();
$result = mysqli_query($db_link, $query);
if (!$result) js_msg("There has been an error: ".mysqli_connect_error() );
db_close();
?>
<script language="JavaScript"><!--
function moveit()
{
url2open="index.php";
document.location=url2open;
}
moveit();
// --></script> |