ডেটাবেস সিলেক্ট

SELECT Statement টি ব্যাবহার করে ডেটাবেস থেকে ডেটা সিলেক্ট করা যায়।যেমন নিচের উদাহরনটি persons table এর সমস্ত ডেটা সিলেক্ট করবে

01.<?php

02.$con = mysql_connect("localhost","rej","abc123");

03.if (!$con)

04.{

05.die('Could not connect: ' . mysql_error());

06.}

07. 

08.mysql_select_db("my_db", $con);

09. 

10.$result = mysql_query("SELECT * FROM Persons");

11. 

12.while($row = mysql_fetch_array($result))

13.{

14.echo $row['FirstName'] . " " . $row['LastName'];

15.echo "<br />";

16.}

17. 

18.mysql_close($con);

19.?>

উপরের উদাহরনে mysql_query() function যে ডেটা ফেরৎ পাঠালো তা $result variable সংরক্সিত হয়ে থাকে।

 

আউটপুট

Rejoan Alam
Riad Ahmed
Umme Salma

আউটপুট HTML table এ দেখানো

নিচের কোডটি উপরের মতই একই ডেটা সিলেক্ট করবে কিন্তু আউটপুট টেবিলে দেখাবে

01.<?php

02.$con = mysql_connect("localhost","rej","abc123");

03.if (!$con)

04.{

05.die('Could not connect: ' . mysql_error());

06.}

07. 

08.mysql_select_db("my_db", $con);

09. 

10.$result = mysql_query("SELECT * FROM Persons");

11. 

12.echo "<table border='1'>

13.<tr>

14.<th>Firstname</th>

15.<th>Lastname</th>

16.</tr>";

17. 

18.while($row = mysql_fetch_array($result))

19.{

20.echo "<tr>";

21.echo "<td>" . $row['FirstName'] . "</td>";

22.echo "<td>" . $row['LastName'] . "</td>";

23.echo "</tr>";

24.}

25.echo "</table>";

26. 

27.mysql_close($con);

28.?>

আউটপুট

Firstname	Lastname
Huzaifa	Alam
Ahmed	karim
Umme	Salma

mysqli ব্যবহার করে ডেটা সিলেক্ট করা

01.<?php

02.$con =new mysqli("localhost","root","","book_sc");

03.if (!$con)

04.{

05.die('Could not connect: ' . mysqli_connect_error());

06.}

07. 

08.$result = $con->query("SELECT * FROM books");

09.echo "<table  border='1'><tr>

10.<th>ISBN</th>

11.<th>Author</th>

12.<th>Title</th>

13.<th>Category ID</th>

14.<th>Price</th>

15.<th>Description</th>

16.</tr>";

17.while($row = $result->fetch_array())

18.{

19.echo"<tr>";

20.echo "<td>" .$row['isbn']."</td>";

21.echo "<td>" .$row['author']."</td>";

22.echo "<td>" .$row['title']."</td>";

23.echo "<td>" .$row['catid']. "</td>";

24.echo "<td>" .$row['price']. "</td>";

25.echo "<td>" .$row['description']. "</td>";

26.echo"</tr>";

27.}

28.echo"</table>";

29.?>

আউটপুট:

ISBN	Author	Title	Category ID	Price	Description
0672329166	Luke Welling and Laura Thomson	PHP and MySQL Web Development	1	49.99	PHP & MySQL Web Development teaches the reader to develop dynamic, ....
067232976X	Julie Meloni	Sams Teach Yourself PHP, MySQL and Apache All-in-One	1	34.99	Using a straightforward, step-by-step approach, each ...