mysql - PHP shows nothing, no error -


i trying fetch data users table php shows blank page , no error. wrong? newbie in php.

<?php   $host ="localhost"; $database="xyz"; //i sure here true $username="xyz"; //i sure here true $password="xyz"; //i sure here true  $sql = "select * users;";  $con = mysqli_connect($host,$username,$password,$database);  $result = mysqli_query($con,$sql);  $response = array();    while($row=mysqli_fetch_array($result)){    array_push($response,array("name" => $row[0],"email" => $row[1],"contact" => $row[2],"password" => $row[3]));  }  echo json_encode(array("server_response" =>$response)); mysqli_close($con);  ?>

edİt

i added var_dump($row); in while loop

<?php   error_reporting(-1); ini_set('display_errors', 'on');   $host ="localhost"; $database="gurkanc1_sample"; $username="gurkanc1_sample"; $password="sample123";  $sql = "select * users;";  $con = mysqli_connect($host,$username,$password,$database);  $result = mysqli_query($con,$sql);  $response = array();    while($row=mysqli_fetch_array($result)){    array_push($response,array("name" => $row[0],"email" => $row[1],"contact" => $row[2],"password" => $row[3]));   var_dump($row);   }   echo json_encode(array("server_response" =>$response)); mysqli_close($con);  ?>

now shows, 

> array(8) { [0]=> string(3) "asd" ["name"]=> string(3) "asd" [1]=> > string(3) "asd" ["email"]=> string(3) "asd" [2]=> string(2) "aa" > ["contact"]=> string(2) "aa" [3]=> string(2) "aa" ["password"]=> > string(2) "aa" } array(8) { [0]=> string(13) "merhaba d�nya" > ["name"]=> string(13) "merhaba d�nya" [1]=> string(7) "merhaba" > ["email"]=> string(7) "merhaba" [2]=> string(7) "merhaba" > ["contact"]=> string(7) "merhaba" [3]=> string(7) "merhaba" > ["password"]=> string(7) "merhaba" } array(8) { [0]=> string(0) "" > ["name"]=> string(0) "" [1]=> string(0) "" ["email"]=> string(0) "" > [2]=> string(0) "" ["contact"]=> string(0) "" [3]=> string(0) "" > ["password"]=> string(0) "" } array(8) { [0]=> string(2) "ss" > ["name"]=> string(2) "ss" [1]=> string(2) "ss" ["email"]=> string(2) > "ss" [2]=> string(2) "ss" ["contact"]=> string(2) "ss" [3]=> string(1) > "s" ["password"]=> string(1) "s" } array(8) { [0]=> string(4) "axac" > ["name"]=> string(4) "axac" [1]=> string(3) "qdq" ["email"]=> > string(3) "qdq" [2]=> string(4) "egeg" ["contact"]=> string(4) "egeg" > [3]=> string(3) "wff" ["password"]=> string(3) "wff" } array(8) { > [0]=> string(7) "merhaba" ["name"]=> string(7) "merhaba" [1]=> > string(7) "nerbaba" ["email"]=> string(7) "nerbaba" [2]=> string(3) > "cii" ["contact"]=> string(3) "cii" [3]=> string(4) "asdf" > ["password"]=> string(4) "asdf" } array(8) { [0]=> string(1) "g" > ["name"]=> string(1) "g" [1]=> string(1) "e" ["email"]=> string(1) "e" > [2]=> string(2) "er" ["contact"]=> string(2) "er" [3]=> string(1) "r" > ["password"]=> string(1) "r" } array(8) { [0]=> string(2) "sd" > ["name"]=> string(2) "sd" [1]=> string(2) "sd" ["email"]=> string(2) > "sd" [2]=> string(3) "dsd" ["contact"]=> string(3) "dsd" [3]=> > string(0) "" ["password"]=> string(0) "" }

here how json looks when formatted json viewer plugin, appears wrongly formed

>array(8){     [0]=>string(3)"asd"["name"]=>string(3)"asd"[1]=>>string(3)"asd"["email"]=>string(3)"asd"[2]=>string(2)"aa">["contact"]=>string(2)"aa"[3]=>string(2)"aa"["password"]=>>string(2)"aa" }array(8){     [0]=>string(13)"merhaba d�nya">["name"]=>string(13)"merhaba d�nya"[1]=>string(7)"merhaba">["email"]=>string(7)"merhaba"[2]=>string(7)"merhaba">["contact"]=>string(7)"merhaba"[3]=>string(7)"merhaba">["password"]=>string(7)"merhaba" }array(8){     [0]=>string(0)"">["name"]=>string(0)""[1]=>string(0)""["email"]=>string(0)"">[2]=>string(0)""["contact"]=>string(0)""[3]=>string(0)"">["password"]=>string(0)"" }array(8){     [0]=>string(2)"ss">["name"]=>string(2)"ss"[1]=>string(2)"ss"["email"]=>string(2)>"ss"[2]=>string(2)"ss"["contact"]=>string(2)"ss"[3]=>string(1)>"s"["password"]=>string(1)"s" }array(8){     [0]=>string(4)"axac">["name"]=>string(4)"axac"[1]=>string(3)"qdq"["email"]=>>string(3)"qdq"[2]=>string(4)"egeg"["contact"]=>string(4)"egeg">[3]=>string(3)"wff"["password"]=>string(3)"wff" }array(8){     >[0]=>string(7)"merhaba"["name"]=>string(7)"merhaba"[1]=>>string(7)"nerbaba"["email"]=>string(7)"nerbaba"[2]=>string(3)>"cii"["contact"]=>string(3)"cii"[3]=>string(4)"asdf">["password"]=>string(4)"asdf" }array(8){     [0]=>string(1)"g">["name"]=>string(1)"g"[1]=>string(1)"e"["email"]=>string(1)"e">[2]=>string(2)"er"["contact"]=>string(2)"er"[3]=>string(1)"r">["password"]=>string(1)"r" }array(8){     [0]=>string(2)"sd">["name"]=>string(2)"sd"[1]=>string(2)"sd"["email"]=>string(2)>"sd"[2]=>string(3)"dsd"["contact"]=>string(3)"dsd"[3]=>>string(0)""["password"]=>string(0)"" }

can please post var_dump($result) or print_r($result). others have suggested table might empty.


Comments

Post a Comment

Popular posts from this blog

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more