示例#1
0
<?php

include "utils.php";
?>

<!DOCTYPE html PUBLIC "-//W3C//Dtd html 4.0 Transitional//EN">
<html>
	<head>
		<meta HTTP-EQUIV="CONTENT-TYPE" content="text/html; charset=UTF-8">
		<meta name="AUthOR" content="Parmentier Laurent">
		<meta name="DESCRIPTION" content="script php postgres">
		<meta name="KEYWORDS" content="Parmentier Laurent, informatique, ENSICAEN, 2A INFO">
		<title>script2</title>
	</head>
  <body>
	<h1>Requêtes sur la base clinique</h1>
<!-- modifier l'url de l'action par votre url -->
<form action="http://www.ecole.ensicaen.fr/~parmentier/BDD/script3.php">

<?php 
$query = pg_query($dbconn, "SELECT tablename FROM pg_tables WHERE schemaname='parmentier' AND tablename NOT LIKE 'pg%'");
echo aff_select($query, "tablename", 0);
?>

<input type="submit" name="send" value="execute" />

</form>
 </body>
</html>
示例#2
0
<?php

include_once "utils.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//Dtd html 4.0 Transitional//EN">
<html>
	<head>
		<meta HTTP-EQUIV="CONTENT-TYPE" content="text/html; charset=UTF-8">
		<title>script</title>
	</head>
  <body>
  	<h1> Choisir une table dans la liste </h1>
  	<?php 
echo "<form action='http://www.ecole.ensicaen.fr/~pelay/BDD/script3.php'>";
$req = "SELECT tablename FROM pg_tables WHERE schemaname='pelay' AND tablename NOT LIKE 'pg%'";
$query = pg_query($dbconn, $req);
$nom = 'table';
aff_select($query, $nom, 0);
echo "<input type='submit' value='Puis choisir les colones'>";
?>
  </body>
</html>