function reccount($name, $user, $compteur)
{
if ($compteur != 0) {
$tempname = $name . " (" . $compteur . ")";
} else {
$tempname = $name;
}
$sql = "SELECT * FROM panneaux WHERE Nom = '{$tempname}' AND owner = '{$user}'";
$servername = "localhost";
$username = "******";
$password = "";
$dbname = "diagnosol";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$reponse = mysqli_query($conn, $sql);
while ($donnees = mysqli_fetch_array($reponse)) {
$compteur = $compteur + 1;
return 1 + reccount($name, $user, $compteur);
}
return 0;
}
function update($conn, $tablename, $targettablename, $sql, $count)
{
$recs = reccount($conn, $tablename);
$added = addedcount($conn, $targettablename);
echo "\n Records - " . $recs;
$attempts = get_attempts($recs - $added, $count);
for ($x = 0; $x < $attempts; $x++) {
$start = $added + $x * $count;
$tmp = $sql . " LIMIT " . $start . "," . $count . ";";
//echo "\n" . $tmp;
runsql($conn, $tmp);
}
}
