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 |