retrieving data from database

Alfraganus · December 20, 2015

Dear programmers,

I am trying to retrieve all ma data from database, but my php is bringing me just my last data only, how can I bring them all?

and one more problem, when I am trying to uplaod data to database, sometimes it is uplaoding and sometimes it is just igroning, what can it be result of?

here is my tiny source code::

upload.php

<!DOCTYPE html>

<html>

<head>

<title>uploading a file</title>

</head>

<td colspan="8"><h2>upload whatever you want mr Alfraganus</h2></td>

</td>

<tr>

<td colspan="8" align="center"><input type="text" name="title" size="60"><b>Title</b></td>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</body>

</html>

<?php

/*$servername="localhost";

$username="root";

$password="";

$dbname="testdb";*/

$conn=new mysqli ("localhost", "root","","testdb"); //checking connection

if ($conn) {

echo "success";

}

if (isset($_POST['upload'])) {

$title=$_POST['title'];

$body=$_POST['article'];

$insert="INSERT INTO cms

(title, body) VALUES ('$title', '$body')";

$checking=mysqli_query($conn, $insert);

}

if($checking) {

echo "<script>alert('success')</script>";

}

?>

display.php

<!DOCTYPE html>

<html>

<head>

</head>

<body>

<div id="header">ajshcoljwq qwpdjpqwkdqokdwpqodk'pqw </div>

<?php

$con=new mysqli("localhost","root","", "testdb");

$sql="SELECT * FROM cms";

$run=mysqli_query($con, $sql);

while($row=mysqli_fetch_array($run)) {

$title=$row['title'];

$body=$row['body'];

}

echo "

<h1> $title</h1

";

?>

</center>

</body>

</html>

davej · December 20, 2015

Where is your loop?

http://www.w3schools.com/PHP/php_mysql_select.asp

john_jack · December 20, 2015

you need to put the " Echo" part inside the while loop .

<?php

$con=new mysqli("localhost","root","", "testdb");

$sql="SELECT * FROM cms";

$run=mysqli_query($con, $sql);

while($row=mysqli_fetch_array($run)) {

$title=$row['title'];

$body=$row['body'];

}

echo "

<h1> $title</h1

<p>$body</p>

";

?>

replace it with this :

<?php 
$con=new mysqli("localhost","root","", "testdb");
$sql="SELECT * FROM cms";
 
$run=mysqli_query($con, $sql);
while($row=mysqli_fetch_array($run)) {
$title=$row['title'];
$body=$row['body'];
echo "
<h1> $title</h1
<p>$body</p>
 
";

}


?>

Sign In

retrieving data from database

Recommended Posts

Alfraganus

Link to comment

Share on other sites

davej

Link to comment

Share on other sites

john_jack

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Browse

Activity