php - Sortering og håndtering af data :) - Udvikleren.dk

Tags: php

Bruger #13723 @ 12.03.10 19:44

Hej,

Jeg er pt igang med at lave et script der ripper mit skole skema fordi deres side er så elendig.

Jeg har et fungerende program men det er utroligt ressource krævende og det er simpelthen ikke godt nok for det tager reeet lang tid at hente indholdet og sortere det.

Jeg har brugt et script der hedder: simple_html_dom hvor jeg meget nemt kan specificere hvor og hvad den skal scrape og vise.

Men som sagt så er dette meget ressoucre krævende så ville høre om det kan lade sig gøre på andre måder f.eks. regular expressions? Et eksempel ville være guld værd!

Mit nuværende script med simple_html_dom:

Kode

$html = str_get_html($skema);

$man = $html->find('td[class=WeekDay]',0);
	$mandag = array();
	$mandag[] = $man->find('table[class=Apppointment_Skema]',0);
	$mandag[] = $man->find('table[class=Apppointment_Skema]',1);
	$mandag[] = $man->find('table[class=Apppointment_Skema]',2);
	$mandag[] = $man->find('table[class=Apppointment_Skema]',3);
	$mandag[] = $man->find('table[class=Apppointment_Skema]',4);
	$mandag[] = $man->find('table[class=Apppointment_Skema]',5);
	$mandag[] = $man->find('table[class=Apppointment_Skema]',6);
	$mandag[] = $man->find('table[class=Apppointment_Skema]',7);
$tir = $html->find('td[class=WeekDay]',1);
	$tirsdag = array();
	$tirsdag[] = $tir->find('table[class=Apppointment_Skema]',0);
	$tirsdag[] = $tir->find('table[class=Apppointment_Skema]',1);
	$tirsdag[] = $tir->find('table[class=Apppointment_Skema]',2);
	$tirsdag[] = $tir->find('table[class=Apppointment_Skema]',3);
	$tirsdag[] = $tir->find('table[class=Apppointment_Skema]',4);
	$tirsdag[] = $tir->find('table[class=Apppointment_Skema]',5);
	$tirsdag[] = $tir->find('table[class=Apppointment_Skema]',6);
	$tirsdag[] = $tir->find('table[class=Apppointment_Skema]',7);
$ons = $html->find('td[class=WeekDay]',2);
	$onsdag = array();
	$onsdag[] = $ons->find('table[class=Apppointment_Skema]',0);
	$onsdag[] = $ons->find('table[class=Apppointment_Skema]',1);
	$onsdag[] = $ons->find('table[class=Apppointment_Skema]',2);
	$onsdag[] = $ons->find('table[class=Apppointment_Skema]',3);
	$onsdag[] = $ons->find('table[class=Apppointment_Skema]',4);
	$onsdag[] = $ons->find('table[class=Apppointment_Skema]',5);
	$onsdag[] = $ons->find('table[class=Apppointment_Skema]',6);
	$onsdag[] = $ons->find('table[class=Apppointment_Skema]',7);
$tor = $html->find('td[class=WeekDay]',3);
	$torsdag = array();
	$torsdag[] = $tor->find('table[class=Apppointment_Skema]',0);
	$torsdag[] = $tor->find('table[class=Apppointment_Skema]',1);
	$torsdag[] = $tor->find('table[class=Apppointment_Skema]',2);
	$torsdag[] = $tor->find('table[class=Apppointment_Skema]',3);
	$torsdag[] = $tor->find('table[class=Apppointment_Skema]',4);
	$torsdag[] = $tor->find('table[class=Apppointment_Skema]',5);
	$torsdag[] = $tor->find('table[class=Apppointment_Skema]',6);
	$torsdag[] = $tor->find('table[class=Apppointment_Skema]',7);
$fre = $html->find('td[class=WeekDay]',4);
	$fredag = array();
	$fredag[] = $fre->find('table[class=Apppointment_Skema]',0);
	$fredag[] = $fre->find('table[class=Apppointment_Skema]',1);
	$fredag[] = $fre->find('table[class=Apppointment_Skema]',2);
	$fredag[] = $fre->find('table[class=Apppointment_Skema]',3);
	$fredag[] = $fre->find('table[class=Apppointment_Skema]',4);
	$fredag[] = $fre->find('table[class=Apppointment_Skema]',5);
	$fredag[] = $fre->find('table[class=Apppointment_Skema]',6);
	$fredag[] = $fre->find('table[class=Apppointment_Skema]',7);
	
	$dage = array();
	$dage[] = strip_tags(trim($html->find('td[class=DateBar]',0)));
	$dage[] = strip_tags(trim($html->find('td[class=DateBar]',1)));
	$dage[] = strip_tags(trim($html->find('td[class=DateBar]',2)));
	$dage[] = strip_tags(trim($html->find('td[class=DateBar]',3)));
	$dage[] = strip_tags(trim($html->find('td[class=DateBar]',4)));
	$bif = 0;
	foreach($dage as $dag){
		$dage[$bif] = ucwords(substr($dage[$bif],0,-6));
		$bif++;
	}
	





$showSkema = '<table width="800" height="252" border="0" cellspacing="0" cellpadding="0"><tr><td class="head" width="80">Uge '.date("W",strtotime($date)).' </td><td class="head" width="130">'.$dage[0].'</td><td class="head" width="130">'.$dage[1].'</td><td class="head" width="130">'.$dage[2].'</td><td class="head" width="130">'.$dage[3].'</td><td class="head" width="130">'.$dage[4].'</td></tr>';
	
	$b=0;
	$tider = array("08:15-09:00","09:05-09:50","09:55-10:40","11:00-11:45","11:50-12:35","13:00-13:45","13:50-14:35","14:40-15:25");
	for($b=0;$b<8;$b++){
		$iMan = 0;
		while(times(strip($mandag[$iMan],"tid"))!=$b && ($iMan < 8)){
			$iMan++;
		}
		$iTir = 0;
		while(times(strip($tirsdag[$iTir],"tid"))!=$b && ($iTir < 8)){
			$iTir++;
		}
		$iOns = 0;
		while(times(strip($onsdag[$iOns],"tid"))!=$b && ($iOns < 8)){
			$iOns++;
		}
		$iTor = 0;
		while(times(strip($torsdag[$iTor],"tid"))!=$b && ($iTor < 8)){
			$iTor++;
		}
		$iFre = 0;
		while(times(strip($fredag[$iFre],"tid"))!=$b && ($iFre < 8)){
			$iFre++;
		}
		$showSkema .= "<tr>";
		$showSkema .= "<td class=\"".($b%2 ? "odd" : "even")."\">$tider[$b]				 </td>";
		$showSkema .= "<td class=\"".($b%2 ? "odd" : "even")."\">".strip($mandag[$iMan],"fag").		" </td>";
		$showSkema .= "<td class=\"".($b%2 ? "odd" : "even")."\">".strip($tirsdag[$iTir]	,"fag").	" </td>";
		$showSkema .= "<td class=\"".($b%2 ? "odd" : "even")."\">".strip($onsdag[$iOns]	,"fag").	" </td>";
		$showSkema .= "<td class=\"".($b%2 ? "odd" : "even")."\">".strip($torsdag[$iTor]	,"fag").	" </td>";
		$showSkema .= "<td class=\"".($b%2 ? "odd" : "even")."\">".strip($fredag[$iFre]	,"fag").	" </td>";
		$showSkema .= "</tr>";
	}  
$showSkema .= "</table>";

Den html data der bliver sorteret i er:

HTML kode

 <html>
 <head>
 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
 <LINK REL=stylesheet HREF=\'include/skema.css\' TYPE=\'text/css\'>
 <title>EasyIQ Webskema - &copy;2006 Systemtech ApS</title>
 </head>
 
 <!-- ************************************************* -->
 <STYLE TYPE=\"text/css\">body { overflow: auto;margin-left: 0px;margin-top: 0px;margin-right: 0px;margin-bottom: 0px; }filter: progid:DXImageTransform.Microsoft.Gradient(GradientType=1, StartColorStr=\'#FFFFFF\', EndColorStr=\'#CCCCCC\');</STYLE>
 <!-- ************************************************* -->
 <body>
 <table valign=\"center\" align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" height=\"100%\" width=\"100%\">
 <tr><td>
 <table class=\'WeekTable\' width=\'100%\'>
 
 <tr>
 <td class=\'WeekDay\' width=\'20%\' height=\'100%\' valign=\'top\' bgcolor=\'white\'>
 <table width=\'100%\' cellpadding=\'1\' cellspacing=\'0\' height=\'4%\'>
 <tr>
 <a href=\'default.asp?startDate=08-03-2010&view=day&id=26456\' target=\'_top\'><td class=\'DateBar\' onmouseover=\"this.style.cursor=\'hand\'\" title=\'Klik for gå til denne dag...\'>
 mandag 8. marts 2010
 </td></a>
 </tr>
 </table>
 <div class=\'Weekappointments_teachertyle_Skema\'>
 </div>
 </td>
 <td class=\'WeekDay\' width=\'20%\' height=\'100%\' valign=\'top\' bgcolor=\'white\'>
 <table width=\'100%\' cellpadding=\'1\' cellspacing=\'0\' height=\'4%\'>
 <tr>
 <a href=\'default.asp?startDate=09-03-2010&view=day&id=26456\' target=\'_top\'><td class=\'DateBar\' onmouseover=\"this.style.cursor=\'hand\'\" title=\'Klik for gå til denne dag...\'>
 tirsdag 9. marts 2010
 
 </td></a>
 </tr>
 </table>
 <div class=\'Weekappointments_teachertyle_Skema\'>
 </div>
 </td>
 <td class=\'WeekDay\' width=\'20%\' height=\'100%\' valign=\'top\' bgcolor=\'white\'>
 <table width=\'100%\' cellpadding=\'1\' cellspacing=\'0\' height=\'4%\'>
 <tr>
 <a href=\'default.asp?startDate=10-03-2010&view=day&id=26456\' target=\'_top\'><td class=\'DateBar\' onmouseover=\"this.style.cursor=\'hand\'\" title=\'Klik for gå til denne dag...\'>
 onsdag 10. marts 2010
 </td></a>
 </tr>
 </table>
 <div class=\'Weekappointments_teachertyle_Skema\'>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'75px\'>
 <tr>
 
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">08:15</div>-<br><div style=\"vertical-align:bottom;\">09:00</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Tek.fag des A</b><br>(Teori HTX sk470)<br>Underviser: Michael Schacke</td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'5px\'>
 
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">09:05</div>-<br><div style=\"vertical-align:bottom;\">09:50</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Tek.fag des A</b><br>(Teori HTX sk470)<br>Underviser: Michael Schacke</td>
 </td>
 </tr>
 
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'5px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">09:55</div>-<br><div style=\"vertical-align:bottom;\">10:40</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Tek.fag des A</b><br>(Teori HTX sk470)<br>Underviser: Michael Schacke</td>
 
 </td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'20px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">11:00</div>-<br><div style=\"vertical-align:bottom;\">11:45</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Tek.fag des A</b><br>(Teori HTX sk470)<br>Underviser: Michael Schacke</td>
 
 </td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'5px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">11:50</div>-<br><div style=\"vertical-align:bottom;\">12:35</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Tek.fag des A</b><br>(Teori HTX sk470)<br>Underviser: Michael Schacke</td>
 
 </td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'25px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">13:00</div>-<br><div style=\"vertical-align:bottom;\">13:45</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Tek.fag des A</b><br>(Teori HTX sk470)<br>Underviser: Michael Schacke</td>
 
 </td>
 </tr>
 </table>
 </div>
 </td>
 <td class=\'WeekDay\' width=\'20%\' height=\'100%\' valign=\'top\' bgcolor=\'white\'>
 <table width=\'100%\' cellpadding=\'1\' cellspacing=\'0\' height=\'4%\'>
 <tr>
 <a href=\'default.asp?startDate=11-03-2010&view=day&id=26456\' target=\'_top\'><td class=\'DateBar\' onmouseover=\"this.style.cursor=\'hand\'\" title=\'Klik for gå til denne dag...\'>
 torsdag 11. marts 2010
 </td></a>
 </tr>
 </table>
 <div class=\'Weekappointments_teachertyle_Skema\'>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'75px\'>
 <tr>
 <td></td>
 
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">08:15</div>-<br><div style=\"vertical-align:bottom;\">09:00</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Kom. /it A</b><br>(IT-redigeringsr sk469)<br>Underviser: Carsten Schmidt</td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'5px\'>
 <tr>
 
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">09:05</div>-<br><div style=\"vertical-align:bottom;\">09:50</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Kom. /it A</b><br>(IT-redigeringsr sk469)<br>Underviser: Carsten Schmidt</td>
 </td>
 </tr>
 </table>
 
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'5px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">09:55</div>-<br><div style=\"vertical-align:bottom;\">10:40</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Kom. /it A</b><br>(IT-redigeringsr sk469)<br>Underviser: Carsten Schmidt</td>
 </td>
 
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'20px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">11:00</div>-<br><div style=\"vertical-align:bottom;\">11:45</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Kom. /it A</b><br>(IT-redigeringsr sk469)<br>Underviser: Carsten Schmidt</td>
 
 </td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'5px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">11:50</div>-<br><div style=\"vertical-align:bottom;\">12:35</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Studomr del 2 -</b><br>(IT-redigeringsr sk469)<br>Underviser: Karl Aage Rasmussen</td>
 
 </td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'25px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">13:00</div>-<br><div style=\"vertical-align:bottom;\">13:45</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Studomr del 2 -</b><br>(IT-redigeringsr sk469)<br>Underviser: Karl Aage Rasmussen</td>
 
 </td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'5px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">13:50</div>-<br><div style=\"vertical-align:bottom;\">14:35</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Programmering C</b><br>(Teori HTX sk461)<br>Underviser: Lene Richter Hovad</td>
 
 </td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'5px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">14:40</div>-<br><div style=\"vertical-align:bottom;\">15:25</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Programmering C</b><br>(Teori HTX sk461)<br>Underviser: Lene Richter Hovad</td>
 
 </td>
 </tr>
 </table>
 </div>
 </td>
 <td class=\'WeekDay\' width=\'20%\' height=\'100%\' valign=\'top\' bgcolor=\'white\'>
 <table width=\'100%\' cellpadding=\'1\' cellspacing=\'0\' height=\'4%\'>
 <tr>
 <a href=\'default.asp?startDate=12-03-2010&view=day&id=26456\' target=\'_top\'><td class=\'DateBar\' onmouseover=\"this.style.cursor=\'hand\'\" title=\'Klik for gå til denne dag...\'>
 fredag 12. marts 2010
 </td></a>
 </tr>
 </table>
 <div class=\'Weekappointments_teachertyle_Skema\'>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'75px\'>
 <tr>
 <td></td>
 
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">08:15</div>-<br><div style=\"vertical-align:bottom;\">09:00</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Tek. hist. C</b><br>(IT-redigeringsr sk469)<br>Underviser: Tina Svane Jakobsen</td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'5px\'>
 <tr>
 
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">09:05</div>-<br><div style=\"vertical-align:bottom;\">09:50</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Tek. hist. C</b><br>(IT-redigeringsr sk469)<br>Underviser: Tina Svane Jakobsen</td>
 </td>
 </tr>
 </table>
 
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'5px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">09:55</div>-<br><div style=\"vertical-align:bottom;\">10:40</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Dansk A</b><br>(IT-redigeringsr sk469)<br>Underviser: Jens Rasmussen</td>
 
 </td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Space\' height=\'20px\'>
 <tr>
 <td></td>
 </tr>
 </table>
 <table cellpadding=\'0\' cellspacing=\'0\' class=\'Apppointment_Skema\' height=\'45px\'>
 <tr>
 <td class=\'Apppointment_Skema_Color\'></td>
 <td align=\'center\' class=\'Apppointment_Skema_Time\'><div style=\"vertical-align:top;\">11:00</div>-<br><div style=\"vertical-align:bottom;\">11:45</div></td>
 <td class=\'Apppointment_Skema_Text\'><b>Dansk A</b><br>(IT-redigeringsr sk469)<br>Underviser: Jens Rasmussen</td>
 
 </td>
 </tr>
 </table>
 </div>
 </td>
 </tr>
 </table>
 
 </td></tr>
 </table>
 </body>
 </html>

Jeg skal så have sorteret det sådan at det også bliver vist korrekt der hvor det er blevet sorteret. Dataene der bliver hentet Er fra alle tds hvor classes er følgende, Apppointment_Skema_Text, Apppointment_Skema_Time

Bruger #10216 @ 12.03.10 22:49

4.283

Prøv at kigge på http://php.net/DOMDocument og http://php.net/DOMXpath

Bruger #5620 @ 13.03.10 08:53

1.500

Nu kender ikke simple_html_dom, men det er formentlig operation til at gå til næste node i DOM (nextSibling) og til under noder (children,firstChild). Du bør bruge dem i stedet for find som formentlig leder hele dokumentet igennem hver gang.

brug find til at finde selve skema tabellen og de andre operationer til at gå rundt i DOM for denne tabel.

Bruger #5097 @ 13.03.10 10:28

818

Du kunne implementerer sin egen sorteringsalgoritme hvis du stener lidt

Quicksort er blandt de hurtigste:
http://en.wikipedia.org/wiki/Quicksort

Bruger #1151 @ 14.03.10 20:05

421

Du skal ikke bruge reg exp til det.

Bruger #13723 @ 15.03.10 08:24

Okay super tak for de mange forslag, jeg ser lidt på det

Edit:
Har kigget på det og det virker faktisk ret godt

Men nu er jeg stødt på endnu et problem, den data jeg får kan jeg ikke rigtig sortere med xpath.

Min xpath kode til sortering.

Kode

$html = new DOMDocument(); 
@$html->loadHTML($skema); 
//echo $html->saveHTML();

$xpath = new DOMXPath( $html ); 
$elements = $xpath->query( "//*[@class='Apppointment_Skema']" ); 
echo $elements->nodeValue;
foreach ( $elements as $item ) {
	echo $item->nodeValue.'<br />';; 

}

Det data jeg får ser så følgende ud:
08:15-09:00 Tek. hist. C(IT-redigeringsr sk469)Underviser: Tina Svane Jakobsen
09:05-09:50 Tek. hist. C(IT-redigeringsr sk469)Underviser: Tina Svane Jakobsen
09:55-10:40 Engelsk A(IT-redigeringsr sk469)Underviser: Søren Hedegaard
11:00-11:45 Engelsk A(IT-redigeringsr sk469)Underviser: Søren Hedegaard
11:50-12:35 Tek.fag des A(Teori HTX sk470)Underviser: Martin Popp Fredslund
13:00-13:45 Tek.fag des A(Teori HTX sk470)Underviser: Martin Popp Fredslund
13:50-14:35 Tek.fag des A(Teori HTX sk470)Underviser: Martin Popp Fredslund
14:40-15:25 Tek.fag des A(Teori HTX sk470)Underviser: Martin Popp Fredslund
09:55-10:40 Engelsk A(IT-redigeringsr sk469)Underviser: Søren Hedegaard
11:00-11:45 Engelsk A(IT-redigeringsr sk469)Underviser: Søren Hedegaard
11:50-12:35 Dansk A(IT-redigeringsr sk469)Underviser: Jens Rasmussen
13:00-13:45 Dansk A(IT-redigeringsr sk469)Underviser: Jens Rasmussen
08:15-09:00 Tek.fag des A(Teori HTX sk470)Underviser: Michael Schacke
09:05-09:50 Tek.fag des A(Teori HTX sk470)Underviser: Michael Schacke
09:55-10:40 Tek.fag des A(Teori HTX sk470)Underviser: Michael Schacke
11:00-11:45 Tek.fag des A(Teori HTX sk470)Underviser: Michael Schacke
11:50-12:35 Tek.fag des A(Teori HTX sk470)Underviser: Michael Schacke
13:00-13:45 Tek.fag des A(Teori HTX sk470)Underviser: Michael Schacke

Dette skal sorteres så den kan udregne fra 08:15 til 15:25 hver dag så den får flere forskellige dage, derudover skal jeg have lavet således at den putter tid og fak og lære og lokale i variabler så de kan vises.

Og er godt nok lidt på bar bund, ved ikke lige hvordan mine regular expressions bør ser ud og ved ikke lige hvordan jeg skal lave så de første 8 linjer bliver til $mandag array og de næste 4 til $tirsdag array.

Mvh
Buch

Indlæg senest redigeret d. 16.03.2010 11:57 af Bruger #13723

Sortering og håndtering af data :)

Karma barometer (30 dage)

Modtaget

Givet

Favorit hos
Forum tråde
Artikler