PHP mysqli_query not working on actual hosting server

Question

My following code is working on my local host server. when I host it to actual server the query is not working though connection was established.
output was

"result problem"

<?php
include_once 'db_connect.php'; 

class test{
    public function test1(){
        $db_connect = new db_connect();
        $con = $db_connect->connect();
        if(!$con){
            echo "connection fail";
        }else{
            $sql = "select * from tbl_admin where name='abc' ";
            $query = mysqli_query($con,$sql);
            if(!$query){
                    echo "result problem";
                }else{
                        $result = mysqli_fetch_array($query);
                        echo $result['ad_tp'];
                    }
        }
    }
}

$t = new test();
$t->test1();

Are you sure that you have setup database and table in host server? — Thamilhan, Oct 26 '15 at 08:53
use this : instead of "echo result problem"; use echo "mysqli query error " . $mysqli_error($con); — DannyZB, Oct 26 '15 at 08:55
Yest i'm sure... i have imported db from my localhost exactly. it is in the db. — GHH197, Oct 26 '15 at 08:55
thanx daniel B. it says "Function name must be a string in test.php on line 14". Line 14 is "echo "mysqli query error " . $mysqli_error($con);" — GHH197, Oct 26 '15 at 09:01
Use it like this `$query = mysqli_query($con,$sql) or die(mysqli_error($con));` — Thamilhan, Oct 26 '15 at 09:05
and it should be `mysqli_error($con);` not `$mysqli_error($con);` — Thamilhan, Oct 26 '15 at 09:05
Try to echo the query and run that query on database and see if It is working . — Prafulla Kumar Sahu, Oct 26 '15 at 09:21

score 3 · Answer 1 · answered Oct 26 '15 at 08:55

3

Replace

echo "result problem";

with

printf("Errormessage: %s\n", mysqli_error($link));

This will get you an exact idea of why query is not executing.

answered Oct 26 '15 at 08:55

Arpita

1,386
1
15
35

Thanx Arpita;It printed only "Errormessage:" wot's the meaning of "Function name must be a string in test.php on line 14" line 14 is "echo "mysqli query error " . $mysqli_error($con);" – GHH197 Oct 26 '15 at 09:20
Remove $ from $mysqli_error from line 14 – Rumi Oct 26 '15 at 09:38
Thanx Rumi.. it does not show any error... $ part should be there.. – GHH197 Oct 26 '15 at 10:08

score 0 · Answer 2 · edited Sep 27 '16 at 06:17

0

Use MySQL's mysqli_error to find the MySQL error:

if(!$query){
    echo("Error description: " . mysqli_error($con));
}

edited Sep 27 '16 at 06:17

Pang

9,564
146
81
122

answered Oct 26 '15 at 08:55

Abhishek Sharma

6,689
1
14
20

thanx Rahautos. nothing had happen – GHH197 Oct 26 '15 at 14:02

PHP mysqli_query not working on actual hosting server

2 Answers2