modification mysql vers mysqli

Rechercher

modification mysql vers mysqli

Par john33  -  1 reponse  -  Le 18/10/2018 20:24  -  Editer  - 

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

Par Cyrano  -  Le 19/10/2018 08:03  -  Haut de page  - 

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.

 

Ajouter une réponse à la discussion

Seuls les membres connectés sont autorisés à poster dans les forums !

Identifiez-vous
Join |  ID/MDP? |