Sponsored Content
Top Forums Shell Programming and Scripting Scrape 10 million pages and save the raw html data in mysql database Post 302802107 by alister on Friday 3rd of May 2013 01:51:57 AM
Old 05-03-2013
Why do you need to scrape 10 million urls?

Regards,
Alister
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to insert data into MYSql database from a text file

Hi, Need to get help from you guys about this issue. I need to insert data into MySql database from a text file which is located in other server. The text file is something look like below: Date | SubscriberNo | Call Duration 20/7/07 | 123456788 | 20 20/7/07 | 123412344 | 30 The... (4 Replies)
Discussion started by: shirleyeow
4 Replies

2. Shell Programming and Scripting

shell script to insert data from gps.txt to mysql database

Hi, I have gps receiver, by using gpsd data i can read gps log data to my database(my sql). Steps: 1. telenet localhost 2947 > gps.txt (press enter) 2. r (press enter) //then i will get the data like below in gps.txt file Trying 127.0.0.1... Connected to localhost.... (1 Reply)
Discussion started by: gudivada213
1 Replies

3. Web Development

Mysql question: Best way to update a column containing 8 million rows

Hi all, I was wondering if anyone knew a good/safe way to update a single column in a table that could contain upto 8 million rows... simple command like: UPDATE set blah=foo where bar=XXX; I will be running this on tables being written to and tables that have already been created. ... (3 Replies)
Discussion started by: muay_tb
3 Replies

4. Shell Programming and Scripting

download an html file via wget and pass it to mysql and update a database

CAN I download an html file via wget and pass it to mysql and update a database field? (8 Replies)
Discussion started by: mapasainfo
8 Replies

5. Shell Programming and Scripting

MySQL bulk retrieval of database through html form

Have to delete this long post. Seems nobody would spent time on it. (0 Replies)
Discussion started by: yifangt
0 Replies

6. Shell Programming and Scripting

Script to scrape page for and save data

Hi All I would like to get cars DB from this web site link removed , and I am trying to right script to go and parse the web page and save the data for each cars into a file, type of cars, mark, model, but when I look to the source page I found out that the first car type is preselected and the... (3 Replies)
Discussion started by: molwiko
3 Replies

7. Shell Programming and Scripting

Need help on Insert data to phpMyAdmin mySQL database from Shell Script

Sorry to disturb you, I would like to seek help on inserting data whenever the switch is on or off to my phpMyAdmin mySQL database from my Shell Script. I'm using Raspberry PI as my hardware and I have follow this LINK: instructables.com/id/Web-Control-of-Raspberry-Pi-GPIO/?ALLSTEPS to create my... (4 Replies)
Discussion started by: aoiregion
4 Replies

8. Programming

Need help on Insert data to mySQL database

Hi guys, I would like to seek help on inserting data whenever the switch is on or off to my sensor mySQL database in phpMyAdmin from my control.php. I'm using Raspberry PI as my hardware and follow a few tutorials to create my own Web Control Interface, it works perfectly without insert method.... (1 Reply)
Discussion started by: aoiregion
1 Replies
CURL_MULTI_INFO_READ(3) 						 1						   CURL_MULTI_INFO_READ(3)

curl_multi_info_read - Get information about the current transfers

SYNOPSIS
array curl_multi_info_read NULL (resource $mh, [int &$msgs_in_queue]) DESCRIPTION
Ask the multi handle if there are any messages or information from the individual transfers. Messages may include information such as an error code from the transfer or just the fact that a transfer is completed. Repeated calls to this function will return a new result each time, until a FALSE is returned as a signal that there is no more to get at this point. The integer pointed to with $msgs_in_queue will contain the number of remaining messages after this function was called. Warning The data the returned resource points to will not survive calling curl_multi_remove_handle(3). PARAMETERS
o $mh -A cURL multi handle returned by curl_multi_init(3). o $msgs_in_queue - Number of messages that are still in the queue RETURN VALUES
On success, returns an associative array for the message, FALSE on failure. Contents of the returned array +-------+---------------------------------------------------+ | Key: | | | | | | | Value: | | | | +-------+---------------------------------------------------+ | | | | msg | | | | | | | The CURLMSG_DONE constant. Other return values | | | are currently not available. | | | | | | | |result | | | | | | | One of the CURLE_* constants. If everything is | | | OK, the CURLE_OK will be the result. | | | | | | | |handle | | | | | | | Resource of type curl indicates the handle which | | | it concerns. | | | | +-------+---------------------------------------------------+ EXAMPLES
Example #1 A curl_multi_info_read(3) example <?php $urls = array( "http://www.cnn.com/", "http://www.bbc.co.uk/", "http://www.yahoo.com/" ); $mh = curl_multi_init(); foreach ($urls as $i => $url) { $conn[$i] = curl_init($url); curl_setopt($conn[$i], CURLOPT_RETURNTRANSFER, 1); curl_multi_add_handle($mh, $conn[$i]); } do { $status = curl_multi_exec($mh, $active); $info = curl_multi_info_read($mh); if (false !== $info) { var_dump($info); } } while ($status === CURLM_CALL_MULTI_PERFORM || $active); foreach ($urls as $i => $url) { $res[$i] = curl_multi_getcontent($conn[$i]); curl_close($conn[$i]); } var_dump(curl_multi_info_read($mh)); ?> The above example will output something similar to: array(3) { ["msg"]=> int(1) ["result"]=> int(0) ["handle"]=> resource(5) of type (curl) } array(3) { ["msg"]=> int(1) ["result"]=> int(0) ["handle"]=> resource(7) of type (curl) } array(3) { ["msg"]=> int(1) ["result"]=> int(0) ["handle"]=> resource(6) of type (curl) } bool(false) CHANGELOG
+--------+---------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------+ | 5.2.0 | | | | | | | $msgs_in_queue was added. | | | | +--------+---------------------------+ SEE ALSO
curl_multi_init(3). PHP Documentation Group CURL_MULTI_INFO_READ(3)
All times are GMT -4. The time now is 08:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy