| | |
creating dynamic columns and rows with data
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved
![]() |
•
•
Join Date: Oct 2006
Posts: 82
Reputation:
Solved Threads: 0
Hi
The goal is to allow the user the ability to compare daily schedules of
between 1 to 7 users.
The number of columns/user schedule and column headers
are dynamically created base on user selection.
Each user schedule is set up in columns with the user name
at the top of the column and appointments in the columns.
For a static number of columns in a loop I would use the approach
below to display client names for columns.
I am having problems creating dynmic unique column array names for
client_name.
[php]
[php]
The goal is to allow the user the ability to compare daily schedules of
between 1 to 7 users.
The number of columns/user schedule and column headers
are dynamically created base on user selection.
Each user schedule is set up in columns with the user name
at the top of the column and appointments in the columns.
For a static number of columns in a loop I would use the approach
below to display client names for columns.
I am having problems creating dynmic unique column array names for
client_name.
[php]
PHP Syntax (Toggle Plain Text)
//static columns for() { echo"<tr> <td>$client_name1</td> <td>$client_name2</td> <td>$client_name3</td> <td>$client_name4</td> <td>$client_name5</td> <td>$client_name6</td> </tr>"; } [/php]
[php]
PHP Syntax (Toggle Plain Text)
<? function calendar_event_list_play($users, $date, $db_host, $db_user, $db_password) { //database connnection goes here /**-------------selected database contents stored in arrays---------**/ $group_seg[] = $row;//get user availability $events[] = $row;//appointments for users $provider[] = $row;//users names for column header $width = 23;//dymanic column width calculation base on number of user schedules selected /**--------------header with user names--------------**/ echo"<table> <tr>"; //appointmant time header echo"<td width='$time_slot%'>Time</td>"; //user name column header for($num = 0; $num < count($provider); $num++) { $last_name = $provider[$num][last_name];//get provider last name for title echo"<td width='$width%'><a href ='../calendar_form.php>$provider_name</a></td>"; } echo "</tr> </table>"; echo "<table width='100%'>\n"; //Loop over to display appointment time 15 min time slots for($time = $start_time; $time <= $end_time; $time += $add_time) { //format 24 hour time interval for passing via url $interval_24hr = date("H:i:s", $time); /**-----------------------event time listing ------------------------**/ echo "<tr>"; //Output the time interval label echo"<td width='8%' height='15'> <div id='cal-number' style =''> <ul> <li>".date("h:i A", $time)."</li> </ul> </div> </td>"; //number of columns for($i = 0; $i < count($provider); $i++) { //loop to display appointments for column foreach ($events as $event) { //Event falls into this hour if($interval_24hr == $event['event_time']) { $client_name = substr($event['last_name'],0,14); } else { $client_name = ""; } }//end foreach //number of user columns dynamic with appointments displayed echo"<td $width%'><a href ='../calendar_event_manage_form.php>$client_name</a></td>"; } echo "</tr>"; } echo "</table>"; }//end function ?> [/php]
![]() |
Similar Threads
- memory management in wndows 2000 (Windows NT / 2000 / XP)
- How will I Capture this Dynamic Data (ASP.NET)
Other Threads in the PHP Forum
- Previous Thread: Cutting amount of work and loading time?
- Next Thread: Can i load my page before displaying it ??
| Thread Tools | Search this Thread |
apache api array autocomplete beginner binary body broken cakephp class cms code cron curl database dataentry date date/time display duplicates dynamic ebooks echo email emptydisplayvalue error execute explodefunction file files firstoptioninphpdroplist folder form forms function functions google href htaccess html image include ip javasciptvalidation javascript joomla keywords limit link list login matching mediawiki menu mlm msqli_multi_query multiple mycodeisbad mysql number oop paypal pdf php phpincludeissue query random recourse recursive regex script search seo server sessions shot source sp space speed sql static subdomain subscription system table tag tutorial tutorials upload url validator variable vbulletin video web webdesign white xml youtube





