Skip to content
Snippets Groups Projects
dvre56n75nytbt2.php 716 B
Newer Older
. biopablo's avatar
. biopablo committed
<?
// 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
?>