Hotfix release available: 2025-05-14b "Librarian".
upgrade now! [56.2] (what's this?)
Hotfix release available: 2025-05-14a "Librarian".
upgrade now! [56.1] (what's this?)
New release available: 2025-05-14 "Librarian".
upgrade now! [56] (what's this?)
Hotfix release available: 2024-02-06b "Kaos".
upgrade now! [55.2] (what's this?)
Hotfix release available: 2024-02-06a "Kaos".
upgrade now! [55.1] (what's this?)
New release available: 2024-02-06 "Kaos".
upgrade now! [55] (what's this?)
Hotfix release available: 2023-04-04b "Jack Jackrum".
upgrade now! [54.2] (what's this?)
code-schnipsel:mysql:mysql-2mysqli
Übergang von mysql_XXX-Funktionen zu mysqli
MySQLi gibt es als prozedurale Aufrufe und als objektorientiere Verwendung.
Hier wir die objektorientierte Variante angesetzt.
| mySQL | mySQLi |
|---|---|
$dbRes=mysql_connect($DB_HOST,$DB_USER,$DB_PASS)
OR die("Der Server ($DB_HOST) konnte "
."nicht konnektiert werden.");
mysql_select_db($DB_NAME)
OR die("Die Datenbank ($DB_NAME) konnte "
."nicht ausgewählt werden.");
| $dbRes = new mysqli($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
if ($dbRes->connect_error) {
die('Connect Error ('
.$dbRes->connect_errno.') '
.$dbRes->connect_error);
};
|
$quRes = mysql_query("sql statement");
| $quRes = $dbRes->query("sql statement");
|
$ergRow = mysql_fetch_assoc($quRes); $ergObj = mysql_fetch_object($quRes); $ergRow = mysql_fetch_array($quRes,MYSQL_ASSOC); | $ergRow = $quRes->fetch_assoc(); $ergObj = $quRes->fetch_object(); $ergRow = $quRes->fetch_array(MYSQLI_ASSOC); |
$rows = mysql_num_rows($quRes); | $rows = $quRes->num_rows; ist ein Attribut, keine Methode |
code-schnipsel/mysql/mysql-2mysqli.txt · Last modified: 2024/01/05 13:07 by 127.0.0.1