Build a Website

Completed Posted Mar 8, 2014 Paid on delivery
Completed Paid on delivery

I have a date combo box which chooses from today and next 6 days. The PHP output is currently set to show only CURRENTDATE data from MySQL My goal is to show data not from CURRENT DATE but from date selected fro ComboBox with Current Date set as the default.

demo page is at: [url removed, login to view]

The PHP code I used is below.

I'd like the output to look similar to:

[url removed, login to view]

Please submit the code I need.

Thanks

<html>

<head>

<title>Connecting MySQL Server</title>

<style>

table,td,th

{

border:1px solid orange;

}

table

{

width:100%;

}

th

{

height:50px;

}

</style>

</head>

<body>

<select name="select" id="select">

<?php

$date = time();

$num_days = 7;

for($i=0; $i<=$num_days; ++$i)

{

$date = mktime(0, 0, 0, date("m") , date("d")+$i, date("Y"));

$date = date('D j M', $date);

echo " <option value='{$date}'>{$date}</option>\n";

}

?>

</select>

<?php

$con=mysqli_connect("localhost","XXXXXXX","XXXXXXX","XXXXXXX");

// Check connection

if (mysqli_connect_errno())

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$result = mysqli_query($con,"

SELECT *

FROM movies2

WHERE date = CURDATE()

");

echo "<table border='2'>

<tr>

<th>Movie</th>

<th>Rating</th>

<th>Time</th>

<th>Date</th>

<th>Code</th>

</tr>";

while($row = mysqli_fetch_array($result))

{

echo "<tr>";

echo "<td nowrap>" . $row['movie'] . "</td>";

echo "<td nowrap>" . $row['rating'] . "</td>";

echo "<td nowrap>" . $row['time'] . "</td>";

echo "<td nowrap>" . $row['date'] . "</td>";

echo "<td nowrap>" . $row['code'] . "</td>";

echo "</tr>";

}

echo "</table>";

mysqli_close($con);

?>

</body>

</html>

Graphic Design HTML MySQL PHP Website Design

Project ID: #5532321

About the project

4 proposals Remote project Active Mar 9, 2014

Awarded to:

DevProjeX

I would suggest using an li to get the job done, otherwise you'll end up needing javascript. Also your php would need some changing here and there.

$15 USD in 1 day
(6 Reviews)
2.4

4 freelancers are bidding on average $41 for this job

nguyenhuulocla

- I have 7 years work experience in WordPress, Joomla, Drupal, Oscommerce, Woocommerce, Zend, converting PSD to HTML5/CSS3, pure PHP, CSS3, HTML5 & MySQL. I will provide the website with the best quality and on time. More

$80 USD in 1 day
(10 Reviews)
3.9
himalpoudel1

<style> table,td,th { border:1px solid orange; } table { width:100%; } th { height:50px; } </style> </head> <body> <select name="select" id="select"> <?php $date = time(); $num_days = 7; for($i= More

$25 USD in 1 day
(0 Reviews)
0.0