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); } }