Nathan Rixham wrote:
Miller, Terion wrote:
Well I tried it and still it stopped at the "C's"
1:
your script is timing out, you need to set the time limit higher
set_time_limit(0);
2:
foreach($html->find('table') as $table) {
$rows = explode('</tr>' , $table );
$headerCells = explode('</th>', array_shift($rows));
$struct = array();
foreach( $headerCells as $c => $cell ) {
$struct[] = str_replace(' ', '_', trim(strtolower(strip_tags( $cell ))));
}
$data = array();
foreach( $rows as $r => $row ) {
$cells = explode( '</td>' , $row );
$item = array();
foreach( $cells as $c => $cell ) {
$item[$struct[$c]] = trim(strip_tags( $cell ));
}
$data[] = $item;
$query = "INSERT into `warrants` ";
$query .= "(name, age, warrant, bond, wnumber, crime)";
$query .= " VALUES (";
$query .= " '{$item['name']}',";
$query .= " '{$item['age']}',";
$query .= " '{$item['warrant_type']}',";
$query .= " '{$item['bond']}',";
$query .= " '{$item['warrant_number']}',";
$query .= " '{$item['offence_description']}'";
$query .= " )";
echo $query . "\n";
// run query here
}
}
3:
If this is your own site then don't read on, but if it's not your own
site and this is a paid job for a client then..
do you not think there is something a bit wrong about taking on work
which you obviously can't do, telling the client you can, then
continually asking hard working people to take time out from their own
working days to both teach you and complete your work for you?
There is such an increase in people just saying "I know PHP" taking on
work then getting the helpful people on this list and others to do it
for them, and it really really sucks. If you can't do the work don't
take it on, if you get genuinely stuck then ask - but don't just copy
and paste a clients job description here with some random code and
expect others to do it for you.
In the time you've spent asking and waiting, you could have learnt how
to do it yourself.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
