modification mysql vers mysqli
Bonjour
Je modifie actuellement une script afin de fonctionner avec php 7.2
vu que mysql_ est maintenant deprecated et remplacer par mysqli ou pdo
j'ai changer tout mes mysql_ vers mysqli_
j'ai verifier si les extensions sont bien dispo dans ma config php
puis je recoit cette ereur visitant ma page
Fatal error: Uncaught Error: Call to undefined function mysqli_connect() in /home/cp945229p15/public_html/function.php:25 Stack trace: #0 /home/cp945229p15/public_html/header.php(3): connectdb() #1 /home/cp945229p15/public_html/index.php(3): include('/home/cp945229p...') #2 {main} thrown in /home/cp945229p15/public_html/function.php on line 25
mon code pour function.php est
<?php
$domain = "http://sphg.fr/"; ////// Root of Domain
$baseurl = "http://sphg.fr/member"; ////// Member Panel URL
$adminurl = "http://sphg.fr/admin"; ////// Admin Panel URL
$fronturl = "http://sphg.fr/"; ////// Admin Panel URL
date_default_timezone_set("Asia/Dhaka");
$tm = time();
error_reporting(1);
$dbname = "cp945229_*****";
$dbhost = "localhost";
$dbuser = "cp945229_*****";
$dbpass = "***********";
function connectdb()
{
global $dbname, $dbuser, $dbhost, $dbpass;
$conms = @mysqli_connect($dbhost,$dbuser,$dbpass); //connect mysql
if(!$conms) return false;
$condb = @mysqli_select_db($dbname);
if(!$condb) return false;
return true;
}
function attempt($username, $password)
{
$mdpass = md5($password);
$data = mysqli_fetch_array(mysqli_query("SELECT COUNT(*) FROM users WHERE email='".$username."' and password='".$mdpass."'"));
if ($data[0] == 1) {
# set session
$_SESSION['username'] = $username;
return true;
} else {
return false;
}
}
function attemptadmin($username, $password)
{
$mdpass = md5($password);
$data = mysqli_fetch_array(mysqli_query("SELECT COUNT(*) FROM admin WHERE username='".$username."' and password='".$mdpass."'"));
if ($data[0] == 1) {
# set session
$_SESSION['username'] = $username;
return true;
} else {
return false;
}
}
function you_valid($usssr)
{
$aa = mysqli_fetch_array(mysqli_query("SELECT verstat FROM users WHERE mid='".$usssr."'"));
if ($aa[0]==0){
return true;
}
}
function is_user()
{
if (isset($_SESSION['username']))
return true;
}
function redirect($url)
{
header('Location: ' .$url);
exit;
}
/////////////-------------PRINT
function printBV($mid)
{
$cbv = mysqli_fetch_array(mysqli_query("SELECT lbv, rbv FROM member_bv WHERE mid='".$mid."'"));
$rid = mysqli_fetch_array(mysqli_query("SELECT refid FROM users WHERE mid='".$mid."'"));
$rnm = mysqli_fetch_array(mysqli_query("SELECT username FROM users WHERE mid='".$rid[0]."'"));
echo "<b>Referred By:</b> $rnm[0] <br>";
echo "<b>Current BV:</b> L-$cbv[0] | R-$cbv[1] <br>";
}
function printBelowMember($mid)
{
$bmbr = mysqli_fetch_array(mysqli_query("SELECT lpaid, rpaid, lfree, rfree FROM member_below WHERE mid='".$mid."'"));
echo "<b>Paid Member Below:</b> L-$bmbr[0] | R-$bmbr[1] <br>";
echo "<b>Free Member Below:</b> L-$bmbr[2] | R-$bmbr[3] <br>";
}
/////////////-------------PRINT
/////////////////////////// UPDATE BV
function updateDepositBV($mid='', $deposit_amount=0)
{
$formid=$mid;
while($mid!=""||$mid!="0")
{
if(isMemberExists($mid))
{
$posid=getParentId($mid);
if($posid=="0")
break;
$position=getPositionParent($mid);
$currentBV = mysqli_fetch_array(mysqli_query("SELECT lbv, rbv FROM member_bv WHERE mid='".$posid."'"));
//echo "$posid - $position ----<br/> ";
if($position=="L")
{
$new_lbv=$currentBV[0]+$deposit_amount;
$new_rbv=$currentBV[1];
}
else
{
$new_lbv=$currentBV[0];
$new_rbv=$currentBV[1]+$deposit_amount;
}
mysqli_query("UPDATE member_bv SET lbv='".$new_lbv."', rbv='".$new_rbv."' WHERE mid='".$posid."'");
$mid =$posid;
} else {
break;
}
}//while
return 0;
}
function isMemberExists($mid='0')
{
$count = mysqli_fetch_array(mysqli_query("SELECT COUNT(*) FROM users WHERE mid='".$mid."'"));
if ($count[0] == 1){
return true;
}else{
return false;
}
}
function getParentId($mid ="")
{
$count = mysqli_fetch_array(mysqli_query("SELECT COUNT(*) FROM users WHERE mid='".$mid."'"));
$posid = mysqli_fetch_array(mysqli_query("SELECT posid FROM users WHERE mid='".$mid."'"));
if ($count[0] == 1){
return $posid[0];
}else{
return 0;
}
}
function getPositionParent($mid ="")
{
$count = mysqli_fetch_array(mysqli_query("SELECT COUNT(*) FROM users WHERE mid='".$mid."'"));
$position = mysqli_fetch_array(mysqli_query("SELECT position FROM users WHERE mid='".$mid."'"));
if ($count[0] == 1){
return $position[0];
}else{
return 0;
}
}
############################# LAST CHILD
function getLastChildOfLR($parentUserName="",$position='')
{
$parentid= mysqli_fetch_array(mysql_query("SELECT mid FROM users WHERE username='".$parentUserName."'"));
$childid= getTreeChildId($parentid[0], $position);
if($childid!="-1"){
$mid=$childid;
} else {
$mid=$parentid[0];
}
$flag=0;
while($mid!=""||$mid!="0")
{
if(isMemberExists($mid))
{
$nextchildid= getTreeChildId($mid, $position);
if($nextchildid=="-1")
{
$flag=1;
break;
} else {
$mid = $nextchildid;
}
}//if
else
break;
}//while
return $mid;
}
function getTreeChildId($parentid="",$position="")
{
$cou = mysqli_fetch_array(mysqli_query("SELECT COUNT(*) FROM users WHERE posid='".$parentid."' AND position='".$position."'"));
$cid = mysqli_fetch_array(mysqli_query("SELECT mid FROM users WHERE posid='".$parentid."' AND position='".$position."'"));
if ($cou[0] == 1){
return $cid[0];
}else{
return -1;
}
}
############################# LAST CHILD
///////////////////////// UPDATE BELOW MEMBER
function updateMemberBelow($mid='', $type='')
{
$formid=$mid;
while($mid!=""||$mid!="0")
{
if(isMemberExists($mid))
{
$posid=getParentId($mid);
if($posid=="0")
break;
$position=getPositionParent($mid);
$currentCount = mysqli_fetch_array(mysqli_query("SELECT lpaid, rpaid, lfree, rfree FROM member_below WHERE mid='".$posid."'"));
$new_lpaid = $currentCount[0];
$new_rpaid = $currentCount[1];
$new_lfree = $currentCount[2];
$new_rfree = $currentCount[3];
if($position=="L")
{
if($type=='FREE'){
$new_lfree = $new_lfree+1;
}else{
$new_lpaid = $new_lpaid+1;
}
}
else
{
if($type=='FREE'){
$new_rfree = $new_rfree+1;
}else{
$new_rpaid = $new_rpaid+1;
}
}
mysqli_query("UPDATE member_below SET lpaid='".$new_lpaid."', rpaid='".$new_rpaid."', lfree='".$new_lfree."', rfree='".$new_rfree."' WHERE mid='".$posid."'");
$mid =$posid;
} else {
break;
}
}//while
return 0;
}
///////////////////////// TREE AUTH
function treeeee($mid='', $uid='')
{
$formid=$mid;
while($mid!=""||$mid!="0")
{
if(isMemberExists($mid))
{
$posid=getParentId($mid);
if($posid=="0")
break;
$position=getPositionParent($mid);
if($posid==$uid){
return true;
}
$mid =$posid;
} else {
break;
}
}//while
return 0;
}
function updatePaid($mid)
{
$formid=$mid;
while($mid!=""||$mid!="0")
{
if(isMemberExists($mid))
{
$posid=getParentId($mid);
if($posid=="0")
break;
$position=getPositionParent($mid);
$currentCount = mysqli_fetch_array(mysqli_query("SELECT lpaid, rpaid, lfree, rfree FROM member_below WHERE mid='".$posid."'"));
$new_lpaid = $currentCount[0];
$new_rpaid = $currentCount[1];
$new_lfree = $currentCount[2];
$new_rfree = $currentCount[3];
if($position=="L")
{
$new_lfree = $new_lfree-1;
$new_lpaid = $new_lpaid+1;
}
else
{
$new_rfree = $new_rfree-1;
$new_rpaid = $new_rpaid+1;
}
mysqli_query("UPDATE member_below SET lpaid='".$new_lpaid."', rpaid='".$new_rpaid."', lfree='".$new_lfree."', rfree='".$new_rfree."' WHERE mid='".$posid."'");
$mid =$posid;
} else {
break;
}
}//while
return 0;
}
function ip_info($ip = NULL, $purpose = "location", $deep_detect = TRUE) {
$output = NULL;
if (filter_var($ip, FILTER_VALIDATE_IP) === FALSE) {
$ip = $_SERVER["REMOTE_ADDR"];
if ($deep_detect) {
if (filter_var(@$_SERVER['HTTP_X_FORWARDED_FOR'], FILTER_VALIDATE_IP))
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
if (filter_var(@$_SERVER['HTTP_CLIENT_IP'], FILTER_VALIDATE_IP))
$ip = $_SERVER['HTTP_CLIENT_IP'];
}
}
$purpose = str_replace(array("name", "\n", "\t", " ", "-", "_"), NULL, strtolower(trim($purpose)));
$support = array("country", "countrycode", "state", "region", "city", "location", "address");
$continents = array(
"AF" => "Africa",
"AN" => "Antarctica",
"AS" => "Asia",
"EU" => "Europe",
"OC" => "Australia (Oceania)",
"NA" => "North America",
"SA" => "South America"
);
if (filter_var($ip, FILTER_VALIDATE_IP) && in_array($purpose, $support)) {
$ipdat = @json_decode(file_get_contents("http://www.geoplugin.net/json.gp?ip=" . $ip));
if (@strlen(trim($ipdat->geoplugin_countryCode)) == 2) {
switch ($purpose) {
case "location":
$output = array(
"city" => @$ipdat->geoplugin_city,
"state" => @$ipdat->geoplugin_regionName,
"country" => @$ipdat->geoplugin_countryName,
"country_code" => @$ipdat->geoplugin_countryCode,
"continent" => @$continents[strtoupper($ipdat->geoplugin_continentCode)],
"continent_code" => @$ipdat->geoplugin_continentCode
);
break;
case "address":
$address = array($ipdat->geoplugin_countryName);
if (@strlen($ipdat->geoplugin_regionName) >= 1)
$address[] = $ipdat->geoplugin_regionName;
if (@strlen($ipdat->geoplugin_city) >= 1)
$address[] = $ipdat->geoplugin_city;
$output = implode(", ", array_reverse($address));
break;
case "city":
$output = @$ipdat->geoplugin_city;
break;
case "state":
$output = @$ipdat->geoplugin_regionName;
break;
case "region":
$output = @$ipdat->geoplugin_regionName;
break;
case "country":
$output = @$ipdat->geoplugin_countryName;
break;
case "countrycode":
$output = @$ipdat->geoplugin_countryCode;
break;
}
}
}
return $output;
}
function urlmod($txt){
$string = strtolower($txt);
//Make alphanumeric (removes all other characters)
$string = preg_replace("/[^a-z0-9_\s-]/", "", $string);
//Clean up multiple dashes or whitespaces
$string = preg_replace("/[\s-]+/", " ", $string);
//Convert whitespaces and underscore to dash
$string = preg_replace("/[\s_]/", "-", $string);
$url = $string;
return $url;
}
?>
Merci pour vos info afin que je puis ressoudre ce problemme d'erreur
Bonne soiree
John
Réponses apportées à cette discussion
Salut,
cette erreur indique que l'extension n'est pas disponible. C'est dans un phpinfo qu'il faudrait vérifier ça, et vérifier qu'il y a bien un bloc mysqli.
