cant retrieve data from mysql db with php

Question

Sorry for my bad English,
I cant retrieve record from mysql database, there's no error messages and nothing showing. The things is I want to retrieve data on a page with session using external php file. My table has data on it, I've inserted it with phpmyadmin. Here's the code :

UPDATE

I only work on php file now, and here the konek.php

<?php
error_reporting(E_ALL);
$konek=new mysqli('localhost','root','zxcvbnm','jumat') or die(mysqli_connect_error);

$selek=mysqli_query($konek,'select * from kategori');
    while($baris=mysqli_fetch_array($selek)){
        echo $baris['kodekat'].' '.$baris['namakat'];
        echo '<br>';
    }


if($konek){
    echo 'koneksi ok';
}


$konek->close();
?>

it only shows the 'koneksi ok' word, is the while not processed?

thank you in advance

Try to print a string within konek.php and see if you've included the file ok. — Kyle Emmanuel
– Kyle Emmanuel, Commented Oct 21, 2014 at 6:18
What is your PHP version? mysql_* is depreceted as of PHP 5.5 — Adem Öztaş
– Adem Öztaş, Commented Oct 21, 2014 at 6:20
Add this code at the start of your code so it will show you errors regarding your code. error_reporting(E_ALL); — Indrasinh Bihola
– Indrasinh Bihola, Commented Oct 21, 2014 at 6:22
i think if($i<=mysql_fetch_array($selek)) is wrong statement. remove it and then check, hope it will work. — Ankur Kumar
– Ankur Kumar, Commented Oct 21, 2014 at 6:23
yes, its ok, I've add if statement, then echo something, it shows, after I mark my php as comment, — pras
– pras, Commented Oct 21, 2014 at 6:24

Stark · Accepted Answer · 2014-10-21 06:23:12Z

2

What are you trying to do with this line:

if($i<=mysql_fetch_array($selek)){

If you are trying to compare with the no. of data use:

if($i<=mysql_num_rows($selek)){

answered Oct 21, 2014 at 6:23

Stark

2731 gold badge3 silver badges9 bronze badges

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

Comments

Mario101 · Accepted Answer · 2014-10-21 06:31:17Z

0

From personal experience, I had trouble with this traditional MySQL api.

I'll share this small PDO tutorial that got me over this mess, hope this helps you as much as it helped me.

http://code.tutsplus.com/tutorials/php-database-access-are-you-doing-it-correctly--net-25338

answered Oct 21, 2014 at 6:31

Mario101

11 silver badge3 bronze badges

2 Comments

pras Over a year ago

how to install PDO or mysqli extension for PHP on XAMPP linux?

Mario101 Over a year ago

Hi mate, you don't need to install PDO extensions. I think PHP already supports this feature. The functions are already there sorry for late reply, i am working atm

Stark · Accepted Answer · 2014-10-21 10:34:04Z

0

Try this:

<?php
$konek=mysqli_connect("localhost","root","zxcvbnm","jumat") or die(mysqli_error());
$selek=mysqli_query($konek,"select kodekat,namakat from kategori");
$i=0;
if(mysqli_num_rows($selek) > 0 ){
    while($baris = mysqli_fetch_array($selek)){
        $id = $baris["kodekat"];
        $nmk = $baris["namakat"];   

        echo"kode: ".$id."nama:".$nmk.'<br/>';
    }
}else{
    echo 'No items in database';    
}
mysqli_close($konek);
?>

answered Oct 21, 2014 at 10:34

Stark

2731 gold badge3 silver badges9 bronze badges

Comments

pras · Accepted Answer · 2014-10-22 05:02:43Z

0

I know the problem. Yhe problem is, my database is empty, I'm so forgetfull, :) sorry for the inconvenience, I'm sorry I'm sorry, the code is fine, all of them, :) and all of answers above, I'm sure it works, its my faults, that's my database was empty in the first place,

answered Oct 22, 2014 at 5:02

pras

1151 silver badge16 bronze badges

Collectives™ on Stack Overflow

cant retrieve data from mysql db with php

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related