Cron Job PHP Script Error -

this question has answer here:

• bash script run php script 8 answers

i had made cron job comment : "/home/username/public_html/cron.php"

my php (cron.php)

    <?php       $server = 'localhost';     $user = 'name';     $pass = 'password';     $dbname = 'dbname';      $conn = new mysqli($server, $user, $pass, $dbname);      $sql = "update table;";     $conn->query($sql);      $conn->close();     ?> 

and error :

/home/username/public_html/cron.php: line 1: ?php: no such file or directory /home/username/public_html/cron.php: line 3: =: command not found /home/username/public_html/cron.php: line 4: =: command not found /home/username/public_html/cron.php: line 5: =: command not found /home/username/public_html/cron.php: line 6: =: command not found /home/username/public_html/cron.php: line 8: syntax error near unexpected token `(' /home/username/public_html/cron.php: line 8: `$conn = new mysqli($server, $user, $pass, $dbname);' 

anyone can in solving this? thank you.

your script being interpreted shell script. run php script @ command line:

php /home/username/public_html/cron.php 

or add top of file , make executable:

#!/usr/bin/php 

(or whatever path php executable)