open('forsale.db'); } } $db = new MyDB(); if(!$db) { echo $db->lastErrorMsg(); } else { // echo "Opened database successfully\n".'
'; } //$result = SELECT * FROM "zipof" WHERE "City" LIKE 'Seattle' LIMIT 0, 30 ; //$result = $db->query("SELECT * FROM zipof WHERE City LIKE 'Seattle' " ; $results = $db->query("SELECT * FROM forsale WHERE CATEGORY LIKE '$earch_string' ORDER BY RECORD"); while($row = $results->fetchArray(SQLITE3_ASSOC) ) { // echo "Number = ". $row['Number'] . PHP_EOL.'
' ; echo ' '; echo '

'; echo "[". $row['RECORD'].']       '; echo "". $row['MAKE'].', '; echo "". $row['MODEL'] ." ".''; echo "". $row['DESC'] ." ".''; echo "". $row['CONDITION'] ." ".''; echo "     $". $row['PRICE'] ."   \n\n"; echo '

'; //$s4tring = preg_replace('/\s+/', '_', $row['MODEL']); echo "$s4string"; //$userImage = 'http;//circadea.com/pictures/' . $row['PICTLINK']. '.jpg'; //$defaultImage = 'http://circadea.com/pictures/blank.jpeg'; //$image = (file_exists($userImage)) ? $userImage : $defaultImage; echo ''; //echo ''; echo '

'; echo '

---

'; } //echo "Operation done successfully\n"; echo "____\n".'
'; $db->close(); ?>