PHP getting HTTP error 500

Question

I want to retrieve data from the hosting but it returns me a HTTP error 500 when I tried to test my php.

This is my php code:

 /**
 * Getting all stock
 */
public function getstockdesc() {
    $con = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD,DB_DATABASE);
    $result = mysqli_query($con,"select * FROM stockdesc");
    return $result;
}

This is the for sync into android sqllite:

<?php

include_once 'db_functions.php';
$db = new DB_Functions();
$stockdesc = $db->getstockdesc();
$a = array();
$b = array();
if($stockdesc != false){
    while($row = mysql_fetch_array($stockdesc)){
        $b["stockdescId"] = $row["stockdescId"];
        $b["stockdesc"] = $row["stockdesc"];
        $b["itemCode"] = $row["itemCode"];
        array_push($a,$b);
    }
    echo json_encode($a);
         return $b;
}
    else{
         return false;
    }
  ?>

@greenapps 500 is a internal server error.... OP needs to view their logs. — Stuart, Sep 11 '17 at 08:20
You made connection in db with mysqli and used mysql_fetch_array in your loop, may be this is the issue, sometime when disble error logs in server then php error getting 500 — Nipun Tyagi, Sep 11 '17 at 08:22
Possible duplicate of [Can I mix MySQL APIs in PHP?](https://stackoverflow.com/questions/17498216/can-i-mix-mysql-apis-in-php) — CBroe, Sep 11 '17 at 09:21

score 1 · Answer 1 · answered Sep 11 '17 at 08:28

1

HOLY MOLY, I got the answers right now thx.

Recently using:

mysql_fetch_array()

Need to change to

mysqli_fetch_array()

My bad not paying attention!

Thanks Nipun Tyagi for finding my typo :D!

answered Sep 11 '17 at 08:28

Inori Yuzuriha

53
6

score 0 · Answer 2 · answered Sep 11 '17 at 08:22

0

Use the following to see the actual error:

error_reporting(E_ALL);
ini_set('display_errors', 1);

Place it in the beginning of the code ;)

answered Sep 11 '17 at 08:22

EvgenyKolyakov

3,310
2
21
31

This is not a solution for the problem. So no answer. You should have placed this as a comment. – greenapps Sep 11 '17 at 08:24
No darling !! this is the solution!! Asking how to solve a 500 error is something like: "What is the meaning of life?" – EvgenyKolyakov Sep 11 '17 at 08:26

PHP getting HTTP error 500

2 Answers2