[help]DJ timetable

Status
Not open for further replies.
mark1234

mark1234

Member
Aug 7, 2015
52
1
Heyy guys,
is there someone that can make an easy timetable with mySQL? just a timetable from 00:00 til - 23:00 and than very hour. and if its posseble a page where you can edit and one where you can vieuw the timetable?

(sorry for bad english)
 
Sort by date Sort by votes
Central

Central

Imagination is more important than knowledge.
Feb 22, 2015
709
107
Have you tried researching DJ Panels on the internet?

As I believe I saw one on
You must be registered for see links
sorry if I'm wrong.
 
Upvote 0 Downvote
mark1234

mark1234

Member
Aug 7, 2015
52
1
Central said:
Have you tried researching DJ Panels on the internet?

As I believe I saw one on
You must be registered for see links
sorry if I'm wrong.
Click to expand...
yea got one but need a bit help i want to add this so it fits with the rest of the page
Code: 
<link rel="stylesheet" type="text/css" href="../style.css">
<div id="box">
    <div id="titel">Solliciteren<br></div>
    <div id="streep"></div>
    <img src="../images/vacature.png" style="float: right;">
    <center>
    <h1>Stuur hier je sollicitatie in!</h1>
into this
PHP: 
<?php
include("../functions.php");
include("../connector.php");
if(isset($_GET["day"]))
{
    $date = clean($_GET["day"]); 
}
else
{
    $date = gmdate("l");
}
$sql = mysql_fetch_array(mysql_query("SELECT * FROM `timetable` WHERE `day` = '$date'"));
$variable = array("", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen", "twenty", "twentyone", "twentytwo", "twentythree", "twentyfour"); // Holds a list of all the words thou shalt need, and OH YES, a new, highly efficient timetable.
$printtimes = array("", "00:01 - 01:00", "01:01 - 02:00", "02:01 - 03:00", "03:01 - 04:00", "04:01 - 05:00", "05:01 - 06:00", "06:01 - 07:00", "07:01 - 08:00", "08:01 - 09:00", "09:01 - 10:00", "10:01 - 11:00", "11:01 - 12:00", "12:01 - 13:00", "13:01 - 14:00", "14:01 - 15:00", "15:01 - 16:00",  "16:01 - 17:00", "17:01 - 18:00", "18:01 - 19:00", "19:01 - 20:00", "20:01 - 21:00", "21:01 - 22:00", "22:01 - 23:00", "23:01 - 00:00");
for($num = 1; $num < 25; $num++)
{
    $slot = $variable[$num];
    $$slot = $sql[$num];
}
echo("<span class=\"title\">Timetable</span><br />Welcome to the timetable for $date, if you'd prefer to view another day, please click one of the links below.<hr size=\"1\"><center><a href=\"?day=Monday\">Mon</a> | <a href=\"?day=Tuesday\">Tue</a> | <a href=\"?day=Wednesday\">Wed</a> | <a href=\"?day=Thursday\">Thu</a> | <a href=\"?day=Friday\">Fri</a> | <a href=\"?day=Saturday\">Sat</a> | <a href=\"?day=Sunday\">Sun</a></center><hr size=\"1\"><table cellpadding=\"1\" cellspacing=\"0\" width=\"60%\" align=\"center\">
    <tr>
        <td align=\"center\" width=\"50%\" height=\"11\">
        <b>Time</b></td>
        <td align=\"center\" width=\"50%\" height=\"11\">
        <b>DJ Booked</b></td>
    </tr>");
for($num = 1; $num < 25; $num++)
{
     $lol = $variable[$num];
     echo("<tr>
        <td align=\"center\" width=\"50%\" height=\"11\">
        $printtimes[$num]</td>
        <td align=\"center\" width=\"50%\" height=\"11\">");
    echo $$lol;
    echo("</td></tr>");
}
echo("</table>");
?>
</html>
 
Upvote 0 Downvote
Central

Central

Imagination is more important than knowledge.
Feb 22, 2015
709
107
What I don't understand on your code part you close </html> but there isn't even an opening?
Code: 
<html>
<head>
<link rel="stylesheet" type="text/css" href="../style.css">
</head>
<body>
<?php
include("../functions.php");
include("../connector.php");
if(isset($_GET["day"]))
{
    $date = clean($_GET["day"]);
}
else
{
    $date = gmdate("l");
}
$sql = mysql_fetch_array(mysql_query("SELECT * FROM `timetable` WHERE `day` = '$date'"));
$variable = array("", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen", "twenty", "twentyone", "twentytwo", "twentythree", "twentyfour"); // Holds a list of all the words thou shalt need, and OH YES, a new, highly efficient timetable.
$printtimes = array("", "00:01 - 01:00", "01:01 - 02:00", "02:01 - 03:00", "03:01 - 04:00", "04:01 - 05:00", "05:01 - 06:00", "06:01 - 07:00", "07:01 - 08:00", "08:01 - 09:00", "09:01 - 10:00", "10:01 - 11:00", "11:01 - 12:00", "12:01 - 13:00", "13:01 - 14:00", "14:01 - 15:00", "15:01 - 16:00",  "16:01 - 17:00", "17:01 - 18:00", "18:01 - 19:00", "19:01 - 20:00", "20:01 - 21:00", "21:01 - 22:00", "22:01 - 23:00", "23:01 - 00:00");
for($num = 1; $num < 25; $num++)
{
    $slot = $variable[$num];
    $$slot = $sql[$num];
}
echo("<span class=\"title\">Timetable</span><br />Welcome to the timetable for $date, if you'd prefer to view another day, please click one of the links below.<hr size=\"1\"><center><a href=\"?day=Monday\">Mon</a> | <a href=\"?day=Tuesday\">Tue</a> | <a href=\"?day=Wednesday\">Wed</a> | <a href=\"?day=Thursday\">Thu</a> | <a href=\"?day=Friday\">Fri</a> | <a href=\"?day=Saturday\">Sat</a> | <a href=\"?day=Sunday\">Sun</a></center><hr size=\"1\"><table cellpadding=\"1\" cellspacing=\"0\" width=\"60%\" align=\"center\">
    <tr>
        <td align=\"center\" width=\"50%\" height=\"11\">
        <b>Time</b></td>
        <td align=\"center\" width=\"50%\" height=\"11\">
        <b>DJ Booked</b></td>
    </tr>");
for($num = 1; $num < 25; $num++)
{
     $lol = $variable[$num];
     echo("<tr>
        <td align=\"center\" width=\"50%\" height=\"11\">
        $printtimes[$num]</td>
        <td align=\"center\" width=\"50%\" height=\"11\">");
    echo $$lol;
    echo("</td></tr>");
}
echo("</table>");
?>
<div id="box">
   <div id="titel">Solliciteren<br></div>
   <div id="streep"></div>
   <img src="../images/vacature.png" style="float: right;">
   <center>
   <h1>Stuur hier je sollicitatie in!</h1>
</body>
</html>

I added just a few tags which is normal on a HTML document or where HTML is used. I'm not sure if that is what you wanted entirely, but there you go.

If you want on your tab on your browser to say something like DJ Timetable just add the following code in the <head> section:

Code: 
<title>DJ Timetable</title>
 
Upvote 0 Downvote
mark1234

mark1234

Member
Aug 7, 2015
52
1
Central said:
What I don't understand on your code part you close </html> but there isn't even an opening?
Code: 
<html>
<head>
<link rel="stylesheet" type="text/css" href="../style.css">
</head>
<body>
<?php
include("../functions.php");
include("../connector.php");
if(isset($_GET["day"]))
{
    $date = clean($_GET["day"]);
}
else
{
    $date = gmdate("l");
}
$sql = mysql_fetch_array(mysql_query("SELECT * FROM `timetable` WHERE `day` = '$date'"));
$variable = array("", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen", "twenty", "twentyone", "twentytwo", "twentythree", "twentyfour"); // Holds a list of all the words thou shalt need, and OH YES, a new, highly efficient timetable.
$printtimes = array("", "00:01 - 01:00", "01:01 - 02:00", "02:01 - 03:00", "03:01 - 04:00", "04:01 - 05:00", "05:01 - 06:00", "06:01 - 07:00", "07:01 - 08:00", "08:01 - 09:00", "09:01 - 10:00", "10:01 - 11:00", "11:01 - 12:00", "12:01 - 13:00", "13:01 - 14:00", "14:01 - 15:00", "15:01 - 16:00",  "16:01 - 17:00", "17:01 - 18:00", "18:01 - 19:00", "19:01 - 20:00", "20:01 - 21:00", "21:01 - 22:00", "22:01 - 23:00", "23:01 - 00:00");
for($num = 1; $num < 25; $num++)
{
    $slot = $variable[$num];
    $$slot = $sql[$num];
}
echo("<span class=\"title\">Timetable</span><br />Welcome to the timetable for $date, if you'd prefer to view another day, please click one of the links below.<hr size=\"1\"><center><a href=\"?day=Monday\">Mon</a> | <a href=\"?day=Tuesday\">Tue</a> | <a href=\"?day=Wednesday\">Wed</a> | <a href=\"?day=Thursday\">Thu</a> | <a href=\"?day=Friday\">Fri</a> | <a href=\"?day=Saturday\">Sat</a> | <a href=\"?day=Sunday\">Sun</a></center><hr size=\"1\"><table cellpadding=\"1\" cellspacing=\"0\" width=\"60%\" align=\"center\">
    <tr>
        <td align=\"center\" width=\"50%\" height=\"11\">
        <b>Time</b></td>
        <td align=\"center\" width=\"50%\" height=\"11\">
        <b>DJ Booked</b></td>
    </tr>");
for($num = 1; $num < 25; $num++)
{
     $lol = $variable[$num];
     echo("<tr>
        <td align=\"center\" width=\"50%\" height=\"11\">
        $printtimes[$num]</td>
        <td align=\"center\" width=\"50%\" height=\"11\">");
    echo $$lol;
    echo("</td></tr>");
}
echo("</table>");
?>
<div id="box">
   <div id="titel">Solliciteren<br></div>
   <div id="streep"></div>
   <img src="../images/vacature.png" style="float: right;">
   <center>
   <h1>Stuur hier je sollicitatie in!</h1>
</body>
</html>

I added just a few tags which is normal on a HTML document or where HTML is used. I'm not sure if that is what you wanted entirely, but there you go.

If you want on your tab on your browser to say something like DJ Timetable just add the following code in the <head> section:

Code: 
<title>DJ Timetable</title>
Click to expand...
i wanted it like this
PHP: 
<html>
<head>
<link rel="stylesheet" type="text/css" href="../style.css">
</head>
<body>
<div id="box">
   <div id="titel">timetable<br></div>
   <div id="streep"></div>
   <center>
   <h1>dj timetable</h1>
<?php
include("../functions.php");
include("../connector.php");
if(isset($_GET["day"]))
{
    $date = clean($_GET["day"]);
}
else
{
    $date = gmdate("l");
}
$sql = mysql_fetch_array(mysql_query("SELECT * FROM `timetable` WHERE `day` = '$date'"));
$variable = array("", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen", "twenty", "twentyone", "twentytwo", "twentythree", "twentyfour"); // Holds a list of all the words thou shalt need, and OH YES, a new, highly efficient timetable.
$printtimes = array("", "00:01 - 01:00", "01:01 - 02:00", "02:01 - 03:00", "03:01 - 04:00", "04:01 - 05:00", "05:01 - 06:00", "06:01 - 07:00", "07:01 - 08:00", "08:01 - 09:00", "09:01 - 10:00", "10:01 - 11:00", "11:01 - 12:00", "12:01 - 13:00", "13:01 - 14:00", "14:01 - 15:00", "15:01 - 16:00",  "16:01 - 17:00", "17:01 - 18:00", "18:01 - 19:00", "19:01 - 20:00", "20:01 - 21:00", "21:01 - 22:00", "22:01 - 23:00", "23:01 - 00:00");
for($num = 1; $num < 25; $num++)
{
    $slot = $variable[$num];
    $$slot = $sql[$num];
}
echo("<span class=\"title\">Timetable</span><br />Welcome to the timetable for $date, if you'd prefer to view another day, please click one of the links below.<hr size=\"1\"><center><a href=\"?day=Monday\">Mon</a> | <a href=\"?day=Tuesday\">Tue</a> | <a href=\"?day=Wednesday\">Wed</a> | <a href=\"?day=Thursday\">Thu</a> | <a href=\"?day=Friday\">Fri</a> | <a href=\"?day=Saturday\">Sat</a> | <a href=\"?day=Sunday\">Sun</a></center><hr size=\"1\"><table cellpadding=\"1\" cellspacing=\"0\" width=\"60%\" align=\"center\">
    <tr>
        <td align=\"center\" width=\"50%\" height=\"11\">
        <b>Time</b></td>
        <td align=\"center\" width=\"50%\" height=\"11\">
        <b>DJ Booked</b></td>
    </tr>");
for($num = 1; $num < 25; $num++)
{
     $lol = $variable[$num];
     echo("<tr>
        <td align=\"center\" width=\"50%\" height=\"11\">
        $printtimes[$num]</td>
        <td align=\"center\" width=\"50%\" height=\"11\">");
    echo $$lol;
    echo("</td></tr>");
}
echo("</table>");
?>
</body>
</html>

I tried this but i keep getting this:
You must be registered for see links
instead of:
You must be registered for see links
that bar with back.
 
Upvote 0 Downvote
Zaka

Zaka

Programmer
Feb 9, 2012
471
121
I think this file is included in another file, bad code... really, but you should be able to just break the php code and put it in where you need it and then continue the php code again.
 
Upvote 0 Downvote
Status
Not open for further replies.

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top