<?php include_once 'Actor.php'; // for testing if ($argv[0] == 'getCoActors.php') { $arr = getActors("PRC_A1J5J1E1N1K0Q1O4A4V8L1H4C2Q4C9"); foreach ($arr as $a) { echo $a->toString() . "\n"; } } function getActors($content) { $txt = strip_tags($content); $tokens = preg_split('/\\s+/', $txt); $proposed = 0; $actorArr = []; foreach ($tokens as $value) { echo "[{$value}]\n"; if ($value == "발의의원") { echo "Here!"; $proposed = 1; continue; } if ($value == "찬성의원") { echo "Agrred!"; $proposed = 2; continue; } if ($proposed && strpos($value, ')')) { $namearr = parse_names($value); // Add actors
$result = $db->query("SELECT * from Bill"); if (!$result) { $message = 'Invalid query: ' . $db->error . "\n"; die($message); } if ($result->num_rows <= 0) { die($message = 'no result query: ' . $db->error . "\n"); } // output data of each row while ($row = $result->fetch_assoc()) { $sumHTML = $row['sumHTML']; $coActorHTML = $row['coActorHTML']; $id = $row['id']; echo "Working on {$id}\n"; $bill = getBill($id, $sumHTML); $actors = getActors($coActorHTML); if ($dryrun) { print $bill->toSummaryString(); if ($bill->summary === "") { echo "\nNo summary! check http://likms.assembly.go.kr/bill/jsp/SummaryPopup.jsp?bill_id={$bill->id}\n"; } $line = readline("\n\nOK?[y]/n: "); if ($line === 'n') { exit(-1); } continue; // DO not put something to DB } // insert bill and actors to DB $bill->update($db); foreach ($actors as $a) {
{ $pdo = connect(); $ret = $pdo->query('SELECT DISTINCT Pays FROM Film ORDER BY Pays ASC;'); $pdo = close($pdo); return $ret; } function executeQuery($query) { $pdo = connect(); $ret = $pdo->query($query); $pdo = close($pdo); return $ret; } if (!empty($_GET['init'])) { if (!empty($_GET['getActors'])) { foreach (getActors() as $actor) { echo '<option value="' . $actor['Id'] . '">' . $actor['Nom'] . '</option>'; } } else { if (!empty($_GET['getCountries'])) { foreach (getCountries() as $country) { echo '<option value="' . $country['Pays'] . '">' . $country['Pays'] . '</option>'; } } } } else { $select = 'SELECT Titre'; $from = 'FROM Film F'; $where = 'WHERE 1'; if (!empty($_GET['actors'])) { $actorsIdsList = urldecode($_GET['actors']);