Newer
Older
<?
// Global vars
$today = strtotime("now");
$date = date("Y-m-d");
// Connect to database
$servername = "localhost";
$username = "c30localfaircoop";
$password = "yya@KyDVD68";
$database = "c30localfaircoop";
$conn = new mysqli($servername, $username, $password, $database);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Update data
$sql = "SELECT id FROM ln";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
$id = $row['id'];
$icon = "img/" . $id . ".png";
// $icon = "";
//var_dump($icon); exit;
$sqm = "UPDATE ln SET icon = '$icon'";
$resulu = mysqli_query($conn, $sqm);
}
echo "Correct!";
$conn->close(); //Close connection
?>