the first one to save the image path to database:
Code: Select all
<?php
$db = odbc_connect("asas","asass","asasa");
$sql = "INSERT INTO foto (id, url) VALUES ("
. " 101, 'gg/Fotos/bild1.jpg')";
$res = odbc_exec($db, $sql);
if (!$res) {
print("SQL statement failed with error:\n");
print(odbc_error($db).": ".odbc_errormsg($db)."\n");
} else {
print("One data row inserted.\n");
}
$sql = "INSERT INTO foto (id, url) VALUES ("
. " 102, 'gg/Fotos/bild2.jpg')";
$res = odbc_exec($db, $sql);
print("One data row inserted.\n");
odbc_close($db);
?>
Code: Select all
<?php
$db = odbc_connect("asas","asass","asasa");
$sql = "SELECT id, url FROM foto";
$res = odbc_exec($db, $sql);
while ($row = odbc_fetch_array($res)) {
print($row['id'].",<img src='".$row['url']."'>,".$row['time']."\n");
}
odbc_free_result($res);
odbc_close($db);
?>