PHP Funktion neu ID ermitteln.
beispiel.php |
||
<?php function NewID($host,$us,$pw,$db,$tab){ if(function_exists('mysqli_connect')){ $mysqli = new mysqli($host, $us, $pw, $db); $result = $mysqli->query("SELECT MAX(ID) FROM $tab;"); $mid = mysqli_fetch_row($result); }else{ $con = @mysql_connect ($host,$us,$pw); $sdb = mysql_select_db($db); $selmaxid = "SELECT MAX(ID) FROM $tab;"; $result = mysql_query($selmaxid) or die(mysql_error()); $mid = mysql_fetch_row($result); } $maxid = $mid[0]; $newid = $maxid + 1; return $newid; } /*** Funktion aufrufen ***/ $id = NewID("host","mysql_user","mysql_password","datenbank","tabelle_name"); echo $id; ?> |
||