PHP file not returning any values

Question

This is for my Android application. I have two tables in my database. I am able to insert the values into the table using a php file (url.php). I use different php file (table.php) for comparing the two tables. However when I run the file in the browser I am getting response for url.php but a blank page for table.php.

I have no issues while doing this on a localhost but when its on a server its not working.

PS: The connections are all correct. I have not specified the hostname and other details here. Does it have to do anything with the usage of mysql or mysqli. Here is the code for url.php

<?php
$hostname = "";
$username = "";
$password = "";
$dbname = "";
$con = mysqli_connect($hostname,$username,$password,$dbname);
$unique_id = $_POST['unique_id'];
$link = $_POST['link'];
$sent = $_POST['sent'];
$Sql_Query = "insert into downloads (unique_id,link,sent) values ('$unique_id','$link','$sent')";
if(mysqli_query($con,$Sql_Query)){

    echo 'Data Inserted Successfully';

}
else{

    echo 'Try Again';

}
mysqli_close($con);
?>

Here is the code for table.php

<?php
     header('Content-type: application/json');
     $hostname = "";
     $username = "";
     $password = "";
     $dbname = "";
     mysql_connect("$hostname", "$username", "$password") or  die("cannot       connect"); 
     mysql_select_db("$dbname");
     $sent = $_GET['sent'];
     $sql=mysql_query("SELECT d.unique_id, u.name FROM downloads d LEFT JOIN users u ON u.name = d.unique_id WHERE d.link = '{$sent}'");
     while($row=mysql_fetch_assoc($sql))
     $output[]=$row;
     json_encode($output);
     print(json_encode($output));
     mysql_close();
   ?>

so why are you using mysqli_ in one code then mysql_ in the other? *"Does it have to do anything with the usage of mysql or mysqli."* - It just might! — Funk Forty Niner, Feb 07 '17 at 14:52
I am new to PHP. When i used mysqli for table.php, its not working. Could you please help me? — fazfactor, Feb 07 '17 at 14:54
*"but a blank page for table.php"* - Use PHP's error reporting and check for errors on all the queries. — Funk Forty Niner, Feb 07 '17 at 14:54
Every time you use [the `mysql_`](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) database extension in new code **[a Kitten is strangled somewhere in the world](http://2.bp.blogspot.com/-zCT6jizimfI/UjJ5UTb_BeI/AAAAAAAACgg/AS6XCd6aNdg/s1600/luna_getting_strangled.jpg)** it is deprecated and has been for years and is gone for ever in PHP7. If you are just learning PHP, spend your energies learning the `PDO` or `mysqli` database extensions and prepared statements. [Start here](http://php.net/manual/en/book.pdo.php) — RiggsFolly, Feb 07 '17 at 15:03
`json_encode($output);` does nothing. Did you mean `echo json_encode($output);` — RiggsFolly, Feb 07 '17 at 15:06
WELL THEN, read my previous comment. The `mysql_` database extension does not exist in PHP7 — RiggsFolly, Feb 07 '17 at 15:07
@RiggsFolly I am passing the value to my android application. I have used print(json_encode($output)); — fazfactor, Feb 07 '17 at 15:10
@RiggsFolly I also think thats the reason but while its on a localhost there are no issues — fazfactor, Feb 07 '17 at 15:13
So your localhost must not be running PHP7. Not a very sensible development environment if it does not mimic your live environment — RiggsFolly, Feb 07 '17 at 15:14
*"Current PHP version: 7.0.15"* - as stated; `mysql_` will not run on PHP 7. — Funk Forty Niner, Feb 07 '17 at 15:15
@RiggsFolly yes its true. I have Version 5 :P But then how do I fix those errors? — fazfactor, Feb 07 '17 at 15:16
Convert the file that uses `mysql_` to use `mysqli_` LIKE THE OTHER CODE FILE DOES — RiggsFolly, Feb 07 '17 at 15:17
@RiggsFolly I reopened and reclosed with the proper duplicate. — Funk Forty Niner, Feb 07 '17 at 15:20
@RiggsFolly I tried replacing it but still not working. Have the functions for mysqli_ changed? — fazfactor, Feb 07 '17 at 15:23
No, but they wont work if you didnt change the `mysql_connect()` to a `mysqli_connect()` ETC ETC ETC — RiggsFolly, Feb 07 '17 at 15:33
@RiggsFolly I was having issues with mysql_fetch_assoc(). The others I fixed it. What is that function in mysqli ? — fazfactor, Feb 07 '17 at 15:37

PHP file not returning any values

0 Answers0