#First we include our credentials file include('config.inc.php'); #And now we connect to the database //connection String $connect = mysql_connect($ebis_sql_host, $ebis_sql_user, $ebis_sql_pass) or die('Could not connect: ' . mysql_error()); //select database mysql_select_db($ebis_sql_db, $connect); //Select The database $bool = mysql_select_db($ebis_sql_db, $connect); if ($bool === False){ print "can't find $database"; }
if(!isset($search) || $search == '') {
// get data and store in a json array $query = "SELECT MainId, MainCatalogNo, MainTitel, MainEraID FROM train_item_main" ; if ($sort != "") { $query .= " ORDER BY MainCatalogNo "; } #$query .= " LIMIT ".$start.",".$limit; $result = mysql_query($query) or die("SQL Error 1: " . mysql_error()); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $MyStore1[] = array( 'MainId' => $row['MainId'], 'MainCatalogNo' => $row['MainCatalogNo'], 'MainEraID' => $row['MainEraID'], 'MainTitel' => $row['MainTitel'] ); }
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.