Asking for something that Iīm not sure if itīs possible to implement. I hope be clear enough.
Well, my issue is that Iīm looking how to copy or extract a particular table content of a website. I get the content from a external feed (Iframe format), the content is updated every minute. The Iframe updates new results/scores if there are new ones to show, and for instance, could show from 20 to 100 lines in the table in average at the same time.
Since the information showed by the feed is dynamic, I canīt look for old results(e.g. last week, month, etc) Thus, my goal, (if itīs possible) is to have a unix script (the server runs in unix) that reads the website
periodically (e.g twice a day) and copies in a MySQL database or txt file what table feed shows, within the hosting server. With this would be possible build a history of results and be able to see old results
of desired event in any moment when visitors want.
The IFrame table shows something like this:
Many thanks for any advice or help with this.
Best regards.
---------- Post updated at 07:07 PM ---------- Previous update was at 02:57 AM ----------
Hi again,
I think is no the right section to this thread.
Moderator, may you please move my thread to Web Development section please?
Thanks in advance for any help or suggestion about my question.
Hi friends,
I have to do the following things :
1) there should be a shell script returning the returning the return code of the script. and i have to add some more details like on which machine is has run , at what time and other details and then using plsql i have to add a row to Oracle... (3 Replies)
Hello -
I have a below table and i want to extract the data into excel sheet and send to different location.
Here is the table structure...
SQL> desc t_i1_exportdocs
Name Null? Type
----------------------------------------- --------... (11 Replies)
I have a file that reads File (X.txt)
Contents of record 1:
rdrDESTINATION_ADDRESS (String) "91 971502573813"
rdrDESTINATION_IMSI (String) "000000000000000"
rdrORIGINATING_ADDRESS (String) "d0 movies"
rdrORIGINATING_IMSI (String) "000000000000000"
rdrTRAFFIC_EVENT_TIME... (0 Replies)
Hello Everyone,
I'm trying to write a python script that will go to the following website and grab all the data on the page. The page refreshes regularly and the number of flights is different.
Untitled Document
What I wanted to do was grab all the data (except for top three row containing... (5 Replies)
Hi,
I have few variable say 10
ex:-
l_pc_291334_01_0_01_00.cmp
l_pc_441133_50_0_02_00.cmp
l_pc_441133_55_0_02_00.cmp
Each variable value is coming via loop on a table.
I want to create a script that stores these value to a table or array ( But one by one not all at one time as... (4 Replies)
Hey everyone. Thanks for looking at this.
I'm trying to create a table with the dynamic name of TableName + today's date.
My variables are all happily created but the system chokes when I try to create the new table name example:
Set @BFBW = CONCAT("BFBW", CURDATE());
Select @BFBW;
... (2 Replies)
Hello everyone,
I have a shell script, which connects to the database and runs .sql file.
after executing of .sql file, i need to store the results in error table.
How can i achieve this one? could you please give your suggestions.
here is my code.
#!/bin/sh
#set -vx
SCHEMA_NAME=$1... (1 Reply)
Hello Folks,
I'm working on a requirement to automate the process of generating report(csv file) using metadata info stored in an Oracle table and E-mail it to respective people.
Meta data table:
Report_ID,Report_SUB_ID,Report_DB,Report_SQL,Report_to_email_Id
1,1,DEV,'select * From... (2 Replies)
Discussion started by: venkat_reddy
2 Replies
LEARN ABOUT DEBIAN
apache::session::store::mysql
Apache::Session::Store::MySQL(3pm) User Contributed Perl Documentation Apache::Session::Store::MySQL(3pm)NAME
Apache::Session::Store::MySQL - Store persistent data in a MySQL database
SYNOPSIS
use Apache::Session::Store::MySQL;
my $store = new Apache::Session::Store::MySQL;
$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);
DESCRIPTION
Apache::Session::Store::MySQL fulfills the storage interface of Apache::Session. Session data is stored in a MySQL database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions', or another table name if you provide the TableName
argument:
id char(32) # or however long your session IDs are.
a_session text
To create this schema, you can execute this command using the mysql program:
CREATE TABLE sessions (
id char(32) not null primary key,
a_session text
);
If you use some other command, ensure that there is a unique index on the table's id column.
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are:
DataSource
UserName
Password
TableName
Handle
Example:
tie %hash, 'Apache::Session::MySQL', $id, {
DataSource => 'dbi:mysql:database',
UserName => 'database_user',
Password => 'K00l',
TableName => 'sessions'
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::MySQL', $id, {
Handle => $dbh
};
AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org>
SEE ALSO
Apache::Session
perl v5.10.1 2010-10-18 Apache::Session::Store::MySQL(3pm)