crodjob php script

Hello,

I am trying to create crobjob php script. and I get this error message:

Fatal error: Uncaught Error: Call to undefined function msql_connect() in C:\xampp\htdocs\ids-api\public\cronjob_script.php:5 Stack trace: #0 {main} thrown in C:\xampp\htdocs\ids-api\public\cronjob_script.php on line 5

I wonder why?

I thought msql_connect() would works for all php version. http://id1.php.net/manual/en/function.msql-query.php

cronjob_script.php

 $link = msql_connect("dbserver") or die("unable to connect to msql server: " . msql_error());
    msql_select_db("ids", $link) or die("unable to select database 'db': " . msql_error());
    
    $report = msql_query("SELECT * FROM tb_r_solusiorder LEFT JOIN tb_m_biller ON tb_r_solusiorder.billerid = tb_m_biller.biller_id LEFT JOIN tb_m_user_solusi ON tb_m_user_solusi.MobilePhone = tb_r_solusiorder.MobilePhone");        


    $report_string  =   "";        

    $url        =   "http://localhost/ids-api/public/api/list-report";        

    //open connection
    $ch = curl_init();

    //set the url, number of POST vars, POST data
    curl_setopt($ch,CURLOPT_URL, $url);
    curl_setopt($ch,CURLOPT_POST, count($report));
    curl_setopt($ch,CURLOPT_POSTFIELDS, $report_string);

    //execute post
    $result = curl_exec($ch);
    //close connection
    curl_close($ch);

    echo "<pre>";
    print_r($result); 
    echo "</pre>";

manelgavalda

7 years ago

Level 50

mysql_connect function has been removed from php7. If you are using PHP7 you should use mysqli_connect instead http://php.net/manual/es/function.mysqli-connect.php. Same for mysql_query and all the mysql_* functions. You should use the mysqli_* functions.

Mithrandir

7 years ago

Level 50

According to http://id1.php.net/manual/en/msql.installation.php in order to use this mSql extension, it needs to be compiled into PHP and there are special steps for Windows users.

(apart from that, I - like @globals - initially thought you had misspelled mysql_connect)

davy_yg

7 years ago

Level 27

Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\xampp\htdocs\ids-api\public\cronjob_script.php on line 6

Warning: mysqli_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\xampp\htdocs\ids-api\public\cronjob_script.php on line 6

Fatal error: Uncaught Error: Call to undefined function msql_error() in C:\xampp\htdocs\ids-api\public\cronjob_script.php:6 Stack trace: #0 {main} thrown in C:\xampp\htdocs\ids-api\public\cronjob_script.php on line 6

line 6 : $link = mysqli_connect("dbserver") or die("unable to connect to msql server: " . msql_error());

manelgavalda

7 years ago

Best Answer

Level 50

@DAVY_YG - mysqli_connect syntax is different than mysql_connect. You should call the function like this.

mysqli_connect('localhost', 'user', 'password', 'database');

davy_yg

7 years ago

Level 27

Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in C:\xampp\htdocs\ids-api\public\cronjob_script.php on line 6

Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\ids-api\public\cronjob_script.php on line 6 unable to select database 'db':

line 5: $link = mysqli_connect('localhost', 'root', '', 'ids') or die("unable to connect to msql server: " . msql_error());

line 6: mysqli_select_db("ids", $link) or die("unable to select database 'db': " . mysqli_error());

The ids database does exist and the user also correct.

soulpay21

7 years ago

Level 1

hello dude~ I think you mustn't include the query in there otherwise many people can hack it dude~

Please or to participate in this conversation.