Mercurial > hg > extraction-interface
comparison interface/add_missing_books_to_sections.php @ 2:da5309d54083
add missing books to sections as dummy entries for further modification.
(1) Alter "Auto_increment" to 5190896 for sections table in database.
(2) Finds missing books (using mysql OR _select_distinct() in add_missing_books_to_sections.php
(3) Put the missing_books.csv in intermediate_results.
and execute: add_missing_books_to_sections.php
| author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
|---|---|
| date | Fri, 23 Jan 2015 19:00:57 +0100 |
| parents | |
| children | 883ad980a43b |
comparison
equal
deleted
inserted
replaced
| 1:ef6d0c6a13d7 | 2:da5309d54083 |
|---|---|
| 1 <?php | |
| 2 include_once('Lib_mb_utf8.php'); | |
| 3 include_once('config.php'); | |
| 4 include_once('edit_section_db.php'); | |
| 5 set_time_limit(0); | |
| 6 ini_set('memory_limit', '-1'); | |
| 7 | |
| 8 $link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password); | |
| 9 mysql_query("SET NAMES utf8"); | |
| 10 | |
| 11 if (!$link_mysql) { | |
| 12 die('Could not connect: ' . mysql_error()); | |
| 13 } | |
| 14 | |
| 15 $db_selected = mysql_select_db($mysql_database, $link_mysql); | |
| 16 if (!$db_selected) { | |
| 17 die ('Can\'t use foo : ' . mysql_error()); | |
| 18 } | |
| 19 ?> | |
| 20 | |
| 21 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | |
| 22 <html> | |
| 23 <head | |
| 24 </head> | |
| 25 <body> | |
| 26 <?php | |
| 27 add_missing_books_to_sections(); | |
| 28 | |
| 29 ?> | |
| 30 </body> | |
| 31 | |
| 32 | |
| 33 </html> | |
| 34 |
