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
– Stuart, Commented Sep 11, 2017 at 8: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
– Nipun Tyagi, Commented Sep 11, 2017 at 8:22

Inori Yuzuriha · Accepted Answer · 2017-09-11 08:28:19Z

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, 2017 at 8:28

Inori Yuzuriha

536 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

EvgenyKolyakov · Accepted Answer · 2017-09-11 08:22:46Z

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, 2017 at 8:22

EvgenyKolyakov

3,7012 gold badges24 silver badges35 bronze badges

2 Comments

greenapps Over a year ago

This is not a solution for the problem. So no answer. You should have placed this as a comment.

EvgenyKolyakov Over a year ago

No darling !! this is the solution!! Asking how to solve a 500 error is something like: "What is the meaning of life?"

Collectives™ on Stack Overflow

PHP getting HTTP error 500

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related