8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a list of 10 million page urls. I want those pages scraped and saved in the mysql database as raw html.
I own a Linux VPS server with 1GB RAM and WHM/cPanel.
I would like to scrape at least 100,000 urls in 24 hours.
So can anyone give me some sample shell scripting code? (4 Replies)
Discussion started by: Viruthagiri
4 Replies
2. Shell Programming and Scripting
I am using an html form and a php upload script to upload files.
HTML form
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form action="upload_ac.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
<td>
<table... (1 Reply)
Discussion started by: anil510
1 Replies
3. Solaris
Hi
I would like to convert standard online man pages from my solaris10 system into html form to publish it on my webpage.
How this can be done in Sol10 ?
thx for help. (2 Replies)
Discussion started by: presul
2 Replies
4. Shell Programming and Scripting
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
I am sure this is easy but I can't figure it out...
Here is the form.
<?php
$searchString = $_POST;
if (!isset($_POST))
?>
<html>
<head>
<title>Personal INFO</title>
</head>
<body>
<form method="post" action="search.php">
<input type="text" size="20" maxlength="20" name="search">... (1 Reply)
Discussion started by: mrlayance
1 Replies
6. Shell Programming and Scripting
I have an HTML form that sends email to a large list of users one at a time by matching an email address in peoplesoft to their username. It works great, except that special characters are converted to %## format. Is there a library of these I can use to sed them back (yes this is a crappy UNIX... (1 Reply)
Discussion started by: 98_1LE
1 Replies
7. Shell Programming and Scripting
I wrote a script to automate user account verification against peoplesoft. Now I want to make it available to my peers via the web. It is running on Solaris.
I have the form written, but am not sure how to make it work. I think the form should call a perl cgi when submitted. The cgi should call... (7 Replies)
Discussion started by: 98_1LE
7 Replies
8. Shell Programming and Scripting
I am currently able to use the $QUERY_STRING variable and simply cut out what I need to be assigned as variables within the shell script. However, I've been able to use the "name" value assigned within the FORM(HTML) as a variable when I use perl. Why is it that ksh doesn't read the "name" in as... (1 Reply)
Discussion started by: douknownam
1 Replies
MYSQL_DB_QUERY(3) 1 MYSQL_DB_QUERY(3)
mysql_db_query - Selects a database and executes a query on it
SYNOPSIS
Warning
This function was deprecated in PHP 5.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more
information. Alternatives to this function include:
omysqli_select_db(3) then the query
o PDO::__construct
resource mysql_db_query (string $database, string $query, [resource $link_identifier = NULL])
DESCRIPTION
mysql_db_query(3) selects a database, and executes a query on it.
o $database
- The name of the database that will be selected.
o $query
- The MySQL query. Data inside the query should be properly escaped.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns a positive MySQL result resource to the query result, or FALSE on error. The function also returns TRUE/ FALSE for INSERT/ UPDATE/
DELETE queries to indicate success/failure.
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.3.0 | |
| | |
| | This function now throws an E_DEPRECATED notice. |
| | |
+--------+---------------------------------------------------+
Example #1
mysql_db_query(3) alternative example
<?php
if (!$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) {
echo 'Could not connect to mysql';
exit;
}
if (!mysql_select_db('mysql_dbname', $link)) {
echo 'Could not select database';
exit;
}
$sql = 'SELECT foo FROM bar WHERE id = 42';
$result = mysql_query($sql, $link);
if (!$result) {
echo "DB Error, could not query the database
";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_assoc($result)) {
echo $row['foo'];
}
mysql_free_result($result);
?>
Note
Be aware that this function does NOT switch back to the database you were connected before. In other words, you can't use this
function to temporarily run a sql query on another database, you would have to manually switch back. Users are strongly encouraged
to use the database.table syntax in their sql queries or mysql_select_db(3) instead of this function.
mysql_query(3), mysql_select_db(3).
PHP Documentation Group MYSQL_DB_QUERY(3)