Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // Connecting, selecting database
- $dbconn = pg_connect("host=***** port=*****
- dbname=***** user=***** password=*****")
- or die('Could not connect: ' . pg_last_error());
- //collect
- if(isset($_POST['search'])) {
- $searchq = $_POST['search'];
- // $searchq = preg_replace("#[^0-9a-z]#i"."".$searchq);
- // Performing SQL query
- $query = "SELECT vegan FROM enumbers WHERE code LIKE '%$searchq%'";
- $ret = pg_query($dbconn, $query);
- if(!$ret){
- echo pg_last_error($dbconn);
- exit;
- }
- $output = '';
- while($row = pg_fetch_assoc($ret)){
- $code = $row['code'];
- print_r($row);
- $name = $row['name'];
- $type = $row['type'];
- $vegan = $row['vegan'];
- $output .= '<div> '.vegan.' ';
- }
- }
- echo "Operation done successfullyn";
- pg_close($dbconn);
- ?>
- <div id="tablebox">
- <!-- Search bar -->
- <p>Is It Vegan?</p>
- <form name="form1" method="post" action="searchEnumbers.php">
- <input name="search" type="text" size="30" maxlength="5" />
- <input name="submit" type="submit" value="Search" />
- </form>
- <?php
- print("$output");
- ?>
- </div>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement