phpMySQL/index.php at master · jesus-s-sanzo/phpMySQL · 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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
	<head>
		<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
		<title>testphp</title>
	</head>
	<body id="dt_example">
		<div id="container">
			<h1>Tabla 2</h1>
			<table cellpadding="0" cellspacing="0" border="0" class="display" id="verbos">
				<thead>
					<tr>
						<th>direccion</th>
						<th>nombre</th>
					</tr>
				</thead>
				<tbody>
					 <?php
						include 'db_connect.php';  //include the db_connect.php file
						$get = new Connection("db1");
						$query = $get->query("SELECT * FROM travelmanager.start_point");
						$rowarray = $get->fetch($query);
						foreach ($rowarray as $row) {
							print "<tr>";
							$i=0;
							foreach ($row as $col) {
								if($i==1 || $i==2){
									print '<td>'.$col.'</td>';
								}
								$i++;
							}
							print "</tr>";
						}
					?>
				</tbody>
				<tfoot>
					<tr>
						<th>c1</th>
						<th>c2</th>
						<th></th>
					</tr>
				</tfoot>
			</table>
		</div>
		<footer>
		</footer>
	</body>
</html>