Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- include('connect-db.php');
- $vlekach_number = $_POST['vnumber'];
- $start_date = $_POST['start_date'];
- $end_date = $_POST['end_date'];
- $mysqli = new mysqli($server, $user, $pass ,$db);
- $result = $mysqli->query("SELECT * FROM table_name WHERE 16 LIKE '%$vnumber%' and 5 >= '$start_date' and 5 <='$end_date' ");
- $row = $result->fetch_assoc();
- echo "<table id='table_id' class='display' border='1' style='text-align:center;'>
- <thead>
- <tr>
- <th>Date</th>
- <th>vnumber</th>
- <th>Produkt</th>
- <th>Money</th>
- </tr>
- </thead>
- ";
- while($row = mysql_fetch_array($rs))
- {
- echo "<tr>";
- echo "<td>" . $row['5'] . "</td>";
- echo "<td>" . $row['16'] . "</td>";
- echo "<td>" . $row['53'] . "</td>";
- echo "<td>" . $row['44'] . "</td>";
- echo "</tr>";
- }
- echo "</table>";
- // Close the database connection
- mysql_close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement