web-project2/selectbr.php at main · wojodd/web-project2 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
<?php
$hote = '127.0.0.1'; //server
$login = 'root';
$pass = '';
$namedb='app';
// disple all from table br عرض الوصفة وطريقتها
$pdo  = new PDO("mysql:host=$hote;dbname=$namedb", $login, $pass);

$stmt = $pdo->query("SELECT id , name_r, recipe FROM br");
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

echo '<table border="1" >'."\n";
foreach ( $rows as $row ) {
echo "<tr><td>";
echo($row['id']);
echo("</td><td>");
echo($row['name_r']);
echo("</td><td>");
echo($row['recipe']);
//echo("</td><td>");

}
echo "</table>\n";
?>
<!DOCTYPE html>

<html>
<head>
    <title></title>
    <style>
    table , th,td{

     border: 1px double #033738;
     border-collapse: collapse;
     font-size: 20px;
     margin: 30px 50px;
     padding: 40px 10px 10px;
background: rgba(255, 255, 255, 0.2);
color: #033638;
    }
  th,td {padding: 60px 100px;}

  body{
background-color: #748890;

          }
   </style>
</head>
<body>


</body>
</html>