php - Extending calendar functionality to accept years -

-

i'm working on event scheduler site , stuck i'm using months table (with id & month headers) group results month. due this, if try schedule event january 2016, puts month choose intended, understandably puts 2015. i'm looking on extending beyond end of current year , adding functionality different years.

i happily use method using current table setup, tips or suggestions appreciated.

current code follows:

<?php include 'includes/connect.php'; include 'includes/header.php'; $curmonth = date("n"); ?>  <b>upcoming trip information:</b><br><br> <?php  $res = mysql_query("select * months order id"); while ($rows = mysql_fetch_array($res)) { if($rows['id'] >= $curmonth ){  $monthname = $rows['month']; ?> <table cellpadding="0" cellspacing="3" width="100%">  <tr>  <td> <?php  $tid = $_get['transporter']; $check = mysql_query("select * trips monthname(start_date) = '" . $rows['month'] . "' , tid = '$tid'"); $check = mysql_num_rows($check); if ($check < 1) { echo ""; } else { ?> <h2><?php echo $monthname; ?><?php } ?></h2></td></tr> <tr> <?php $cmonth = date('f'); $tid = $_get['transporter']; $res1 = mysql_query("select * trips monthname(start_date) = '$monthname' order start_date"); while ($rows = mysql_fetch_array($res1)) { $trid = $rows['trid']; $trip_start = $rows['trip_start']; $trip_end = $rows['trip_end']; $start_date = $rows['start_date']; $end_date = $rows['end_date']; $colour = $rows['colour']; $stime = strtotime($start_date); $startt = date("l js", $stime); $etime = strtotime($end_date); $endt = date("l js", $etime); ?>  <td valign="middle" style="height: 100px; background-color: #4b99ed; text-align: center;">  <div style="font-size: 17px; color: #ffffff;"><?php echo $trip_start; ?> <?php echo $trip_end; ?></div>  <div style="font-size: 15px; color: #ffffff;"><?php echo $startt; ?> - <?php echo $endt; ?></div>   </td>  <?php } } } ?>  </tr>  </table> <?php include 'includes/footer.php'; ?>

if possible maintain results layout..

enter image description here

you try, instead of using months table, using start_date column of trips table.

try changing query:

select trips.*, date_format('%m, %y', start_date) `dt`  trips   tid = '$tid' /* bad, please prepare or escape variables*/  order `dt` asc

you won't have first query months , loop through them. if must have empty containers each month, try using query, loop through php-generated array of months display.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSsh Command Execution -

-
Image
i trying create ssh client using c#. using tamir.sharpssh library. having issues sending command , getting appropriate response server. the way have been testing sending on ls command, followed cd.. command, followed ls command again -- see whether or not cd.. command being executed properly. however, there no difference between first ls command , second ls command. not entirely sure doing wrong. perhaps using wrong ssh type. have provided code , output getting. have added output expect. using tamir.sharpssh; namespace sshnetexample { class program { static void main(string[] args) { sshexec ssh = null; try { console.write("-connecting..."); ssh = new sshexec(host, username, password); ssh.connect(); console.writeline("ok ({0}/{1})", ssh.cipher, ssh.mac); console.writeline("server version={0}, client versio
Read more

python - Specify path of savefig with pylab or matplotlib -

-
i struggling on how find correct way specify save path (or repository) when calling function savefig in matplotlib or pylab. i tried several syntaxes, everytime python console returns : filenotfounderror: [errno 2] no such file or directory: '../mydocs/resource/frames/myimage.png' currently, have written following : pylab.savefig('../mydocs/resource/frames/myimage.png') does know how it? thanks in advance! the tilde operator , variable $home entered strings , therefore not function while saving. have provide either relative path (as did) or provide full path. eg. pylab.savefig("/home/username/desktop/myfig.png") .
Read more

How to run C# code using mono without Xamarin in Android? -

-
i want create program uses mono runtime run c# code (binary not application). i copied libmono.so unity app , i'm write code using documentation: http://www.mono-project.com/docs/advanced/embedding/ and it's working have problems references can access classes mscorlib.dll , have problems system.reflection.assembly class throwing exception, when print console see: system.missingmethodexception: method not found: 'system.reflection.assembly.op_inequality' can fix it? can use mono runtime in c binary on android? ps. i'm using android tests. edit: found solution loading libraries, need set environment variable mono_path libraries path. but have still problems assembly class. the system.missingmethodexception error have seems .net profile mismatch error, 1 explained here . can use mono runtime in c binary on android? yes, using ndk guess. there alternatives can use instead of rolling own, such xmadevlab .
Read more