Getting mysqli_query() expects parameter 1 to be mysqli, null given in go daddy server but when i am running on localhost its running correctly

Question

my code on localhost running correctly but when i am putting code on go daddy server its keep showing this error what is problem i don't know here is database connection code

<?php

$hostname="148.72.232.172";
$username="iam4raj";
$password="*******";
$dbname="iam4raj_";
    $con=mysqli_connect($hostname,$username, $password,$dbname);

when i am running this code individually its running and when i am using this $con variable in other code i am getting that error,why here is code where i am getting error

  <?php
                $c_query="select  * from  goverment ";
                $c_run=mysqli_query($con,$c_query);
                if(mysqli_num_rows($c_run)>0)
                {
                    while($row=mysqli_fetch_array($c_run))
                    {
                        $id=$row['id'];
                        $cat=$row['category'];

                ?>

someone help me please .Here is error

PHP Warning: mysqli_query() expects parameter 1 to be mysqli, null given
PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given

$con is null means your database connection is wrong and it cant connect to database. please double check db information eg. password.hostname — スージン, Nov 27 '17 at 06:11
@scarletwitch i checked database connection is running correctly — Raj, Nov 27 '17 at 06:13
local and server host name is same ? can you please vardump $con? — スージン, Nov 27 '17 at 06:17
@KshitijKumar no , i cannot use becuase go daddy host correct , i talked to them and they told me so , fyi i did check and its giving error , connection denied — Raj, Nov 27 '17 at 06:21
@scarletwitch no , its not same , i checked all possible value and only database is ruining on this code . — Raj, Nov 27 '17 at 06:23
@KshitijKumar that is name of table and i made a spell ,mistake that time , so that same table name i am using in query — Raj, Nov 27 '17 at 06:25
@Sean , i did't understand there , can you help me by telling me how , please — Raj, Nov 27 '17 at 06:26
Please add this after $con=mysqli_connect($hostname,$username, $password,$dbname); : if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } — Kshitij Kumar, Nov 27 '17 at 06:28
Add this after $c_run=mysqli_query($con,$c_query); : if (!$c_run) { echo("Error description: " . mysqli_error($con)); } — Kshitij Kumar, Nov 27 '17 at 06:30
host name is always localhost and use the db user name and password not the cpanel user name — Swadesh Ranjan Dash, Nov 27 '17 at 07:18
while using localhost its showing access denied , and i am using db username and password not cpanel @SwadeshDash — Raj, Nov 27 '17 at 07:27
@raj please check httpd.conf file or .htacess file. may be deny for all is their. allow it — Swadesh Ranjan Dash, Nov 27 '17 at 07:31

Getting mysqli_query() expects parameter 1 to be mysqli, null given in go daddy server but when i am running on localhost its running correctly

0 Answers0