PHP Script : Search from mysql numbers

@NogDogJan 15.2014 — #You'd probably be better off using two DB tables. One would hold the basic information about one lottery drawing, and the other would have one row per number drawn, with a foreign key to the first table, something like:

<i>
 </i>drawing
 =======
 drawing_id (INT, PRIMARY KEY, AUTO-INCREMENT)
 drawing_date
 drawing_time
 
 number_drawn
 =============
 drawing_id (INT, FOREIGN KEY TO drawing.drawing_id)
 number (INT)

Then if you want to search for which drawings included 3 numbers (12, 17, and 25 in this example):

<i>
 </i>SELECT drawing.*
 FROM drawing
 INNER JOIN number_drawn AS nd1 USING(drawing_id)
 INNER JOIN number_drawn AS nd2 USING(drawing_id)
 INNER JOIN number_drawn AS nd3 USING(drawing_id)
 WHERE nd1.number = 12
 AND nd2.number = 17
 AND nd3.number = 25

@demonx94authorJan 15.2014 — #

[code=php]<?php 

 $conn = mysql_connect('IP', 'root', 'PASSWORD');
 if (!$conn)
 {
 die('Could not connect: ' . mysql_error());
 }
 mysql_select_db("loto", $conn);
 ?>
 
 
 [/code]

[code=php]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
 <login>Inregistreaza Numere:</login>
 </head>
 
 <body>
 <form method="post">
 <table>
 
  <tr>
   <td>Select  ID:</td>
   <td><input type="text" name="id" /></td>
  </tr>
  <tr>
   <td>Number</td>
   <td><input type="text" name="number" /></td>
  </tr>
  <tr>
   <td>&nbsp;</td>
   <td><input type="submit" name="submit" value="add" /></td>
  </tr>
 </table>
 <?php
 if (isset($_POST['submit']))
 { 

 include 'db.php';
 
   $id=$_POST['id'] ;
   $number= $_POST['number'] ; 
 
   mysql_query("INSERT INTO number_drawn(id,number) 
   VALUES ('$id','$number')"); 
 
 
   }
 ?>
 
   <?php
   include("db.php");
 
 SELECT drawing.*
 FROM drawing
 INNER JOIN number_drawn AS nd1 USING(drawing_id)
 INNER JOIN number_drawn AS nd2 USING(drawing_id)
 INNER JOIN number_drawn AS nd3 USING(drawing_id)
 WHERE nd1.number = 12
 AND nd2.number = 17
 AND nd3.number = 25
 
   echo "</tr>";
   }
   mysql_close($conn);
   ?>
 
 </body>
 </html>
 [/code]

I don't know how i integrate your code ... can anyone help me?

[code=php]Parse error: syntax error, unexpected T_STRING in /home/u433511535/public_html/loto/test/index.php on line 51 [/code]

PHP Script : Search from mysql numbers

2 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

PHP Script : Search from mysql numbers

2 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #PHP _↴