MYSQL | PDO_MySQL |
---|---|
mit der Datenbank verbinden $db_link = mysql_connect ( "MYSQL_HOST", "MYSQL_USER", "MYSQL_PASSWORD" ); ... mysql_close($db_link); Verbindung beenden |
mit der Datenbank verbinden $dsn = "mysql:host=$host; dbname=$db_name; charset=utf8"; $opt = array( PDO::ATTR_ERRMODE => PDO::ERRMODE_SILENT, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC ); $pdo = new PDO($dsn, $db_name, $pdo_pw, $opt); ... $pdo = null; Verbindung beenden |
Anzahl der Zeilen in einer Tabelle ermitteln $lines_query = mysql_query("SELECT COUNT(COLUMNAME) FROM TABLE"); $line_amount = mysql_fetch_row($lines_query); $line_amount = $line_amount[0]; echo $lines_amount." lines"; |
Anzahl der Zeilen in einer Tabelle ermitteln $count_lines = $pdo->query('SELECT * FROM TABLE'); $lines_count = $count_lines->rowCount(); echo $lines_count.' lines'; |