Site Tools


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