PHP: Create array from MySQL to build HTML calendar -


currently working on small booking system want create overview of booked time slots.

in database booking information saved this:

_______________________________________________________________ |id|user_id|     starttime     |      endtime      |facilityid| --------------------------------------------------------------- |1 |    100|2017-08-21 21:00:00|2017-08-21 22:00:00|        11| ---------------------------------------------------------------

now want build html-table, showing timetable current day, representing free timeslots.

<table>   <thead>     <th>time</th>     <th>facility #11</th>     <th>facility #12</th>  </thead>    <tr>     <td>08:00</td>     <td>09:00</td>     ...     <td>21:00</td>     <td>22:00</td>   </tr>    <tr>     <td></td>     <td></td>     ...     <td>user 100</td>     <td></td>   </tr> </table>  time    facility #11    facility #12 08:00   09:00   21:00   22:00         user 100

to populate table automatically, thought idea create associative array containing possible starttimes key , booking information value, if existing.

array(xy) {["08:00"][1]=>string(0) "" [2]=>string(0) "" ["09:00"][1]=>string(0) "" [2]=>string(0) "" ... ["21:00"] [1]=>string(3) "100" [2]=>string(2) "11" ... }

therefore created 2 arrays want combine one.

array 1 - starttimes

array1 = array();    ($hours = 8; $hours <= 22; $hours++) {       ($m = 0; $m < 60; $m += 60) {           $starttime_html = sprintf('%02u:%02u', $hours, $m);           $array1[$starttime_html]='';        }     }

array 2 - bookings

array2 = array(); $statement = $pdo->prepare("select id, user_id, starttime, facility_id mpbs_bookings starttime >= '2017-08-21 00:00:00'"); $statement->execute(array($id)); while($row = $statement->fetch()) {    $starttime_currentday = explode(" ",$row['starttime']);    $starttime_curr_hm = substr($starttime_currentday[1],0,5);    array_push($array2, array($starttime_curr_hm, $row['facility_id'], $row['user_id']));  }

now not find way combine 2 arrays. besides that, glad suggestions on how achieve goal.

here contents of boths arrays:

print_r(array1);  array ( [08:00] => [09:00] => ... => [21:00] => [22:00]=> )   print_r(array2);  array ( [0] => array ( [0] => 18:00 [1] => 6 [2] => 22 ) [1] => array ( [0] => 19:00 [1] => 4 [2] => 11 ) [2] => array ( [0] => 20:00 [1] => 2 [2] => 5 ) [3] => array ( [0] => 20:00 [1] => 9 [2] => 8 ) [4] => array ( [0] => 21:00 [1] => 11 [2] => 34 ) )

thanks in advance.

lars

i made change structure of array2. did can make use of array_merge. array_merge works matching array keys , replacing old (array 1) our new (array 2).

please see ammended code array2 , solution print out output

$array2 = array(); $statement = $pdo->prepare("select id, user_id, starttime, facility_id  mpbs_bookings starttime >= '2017-08-21 00:00:00'"); $statement->execute(array($id));  while($row = $statement->fetch()) {    $starttime_currentday = explode(" ",$row['starttime']);    $starttime_curr_hm = substr($starttime_currentday[1],0,5);     $array2[$starttime_curr_hm] =          array('facliid'=>$row['facility_id'],'userid'=> $row['user_id']);  }  $mergedarray = array_merge($array1,$array2); foreach($mergedarray $date=>$value){    echo $date;    echo 'holding facility_id of '.$value['facliid'].' , user_id of '.$value['userid'].'</br>'; }

Comments

Post a Comment

Popular posts from this blog

python - Operations inside variables -

this question has answer here: evaluating mathematical expression in string 12 answers i want make python script finds maximum possible output using 2 operations. problem says there syntax error @ 2nd last line, in b in there. how can fix it? x = 0 = int(input("1st number:")) c = int(input("2nd number:" )) e = int(input("3rd number:" )) in range(4): if == 0: b = "+" elif == 1: b = "-" elif == 2: b = "/" else: b = "*" j in range(4): if j == 0: d = "+" elif j == 1: d = "-" elif j == 2: d = "/" else: d = "*" k = b c d e print(k) if you're after variables e on single line, couldn...
Read more

Generic Map Parameter java -

i having lot of methods of type: public static list<eduusers> getdetails(class c, map<string, integer> params) { list<eduusers> details = null; session session = hibernateutil.getsessionfactory().opensession(); transaction tx = null; try { tx = session.begintransaction(); criteria cr = session.createcriteria(c); (map.entry<string, integer> entry : params.entryset()) { cr.add(restrictions.eq(entry.getkey(), entry.getvalue())); } details = cr.list(); tx.commit(); } catch (exception asd) { log.debug(asd.getmessage()); if (tx != null) { tx.commit(); } } { session.close(); } return details; } i trying have generic method them , have written far: public static <t> list<t> getdetails(class<t> c, class<t> b) { l...
Read more

arrays - What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it? -

what arrayindexoutofboundsexception mean , how rid of it? here code sample triggers exception: string[] name = {"tom", "dick", "harry"}; for(int = 0; i<=name.length; i++) { system.out.print(name[i] +'\n'); } your first port of call should documentation explains reasonably clearly: thrown indicate array has been accessed illegal index. index either negative or greater or equal size of array. so example: int[] array = new int[5]; int boom = array[10]; // throws exception as how avoid it... um, don't that. careful array indexes. one problem people run thinking arrays 1-indexed, e.g. int[] array = new int[5]; // ... populate array here ... (int index = 1; index <= array.length; index++) { system.out.println(array[index]); } that miss out first element (index 0) , throw exception when index 5. valid indexes here 0-4 inclusive. correct, idiomatic for statement here be: for (int index = 0; index <...
Read more