Php ile Sqlite bağlanma ?
7
●2.064
- 04-07-2010, 22:36:39Üyeliği durduruldu
if ($db = sqlite_open("veritabani.db", 0666, $hata)) { $sql = "SELECT * FROM tablo"; $ergebnis = sqlite_query($db, $sql); echo "<ul>"; $alles = sqlite_fetch_all($ergebnis); foreach ($alles as $zeile) { echo "<li>" . htmlspecialchars($zeile["id"]) . ": " . htmlspecialchars($zeile["feld"]) . "</li>"; } echo "</ul>"; sqlite_close($db); } else { echo "Fehler: $fehler"; } - 05-07-2010, 18:06:22Kurulum Tablosu Bu Bununla Veritabanına Bağlanıyor
if($UploadsWritableOK==1 && $SQLiteOK==1 && !file_exists('uploads/uploads.sqlite')){ // all settings are fine, and there is no database file. Create it now. $db = sqlite_open('uploads/uploads.sqlite'); sqlite_query($db," CREATE TABLE 'temp' ( hash text, file_id integer, file_name text, user_info text, date integer ); CREATE TABLE 'uploads' ( id integer(32) not null primary key unique, filename text(100), date integer, user_info text, hash text ); "); sqlite_close($db); } echo $buf;Ama Bir Türlü Bağlanamadım