•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 401,669 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,559 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 12958 | Replies: 5
![]() |
•
•
Join Date: Oct 2004
Location: France / Paris
Posts: 14
Reputation:
Rep Power: 4
Solved Threads: 1
Hello nikez,
Look at this example,
and try it in http://www.fpepito.org/php/test7.php
I hope that help,
fpepito
[PHP]
<?
if (!isset ($autor)) {
$autor = "pepito";
}
echo "<FORM ACTION=$PHP_SELF>\n";
echo "Autor : <INPUT TYPE=TEXT NAME=autor VALUE=$autor><BR>\n";
echo "<INPUT TYPE=submit value=\"Send the variable\">\n";
echo "</FORM>\n";
?>
[/PHP]
Look at this example,
and try it in http://www.fpepito.org/php/test7.php
I hope that help,
fpepito
[PHP]
<?
if (!isset ($autor)) {
$autor = "pepito";
}
echo "<FORM ACTION=$PHP_SELF>\n";
echo "Autor : <INPUT TYPE=TEXT NAME=autor VALUE=$autor><BR>\n";
echo "<INPUT TYPE=submit value=\"Send the variable\">\n";
echo "</FORM>\n";
?>
[/PHP]
•
•
Join Date: Dec 2003
Location: Nashville, TN
Posts: 2,333
Reputation:
Rep Power: 11
Solved Threads: 101
Have a question for you:
[php]
<?
if (!isset ($autor)) {
echo "<FORM ACTION=$PHP_SELF>\n";
echo "Autor : <INPUT TYPE=TEXT NAME=autor VALUE=Pepito><BR>\n";
echo "Text : <INPUT TYPE=TEXT NAME=text VALUE=port><BR>\n";
echo "After date : <INPUT TYPE=TEXT NAME=aft VALUE=2002-01-01><BR>\n";
echo "Before date : <INPUT TYPE=TEXT NAME=bef VALUE=2004-01-1><BR>\n";
echo "<INPUT TYPE=submit value=\"Identify\">\n";
echo "<BR><HR><BR>\n";
echo "</FORM>\n";
} else {
include "/home/httpd/html/PHP/connect.php";
connect_mysql();
$criteria = "";
if (isset ($autor) && !($autor == "")) {
$criteria .= " autor = '$autor'";
}
if (isset ($text) && !($text == "")) {
if (! ($criteria == "")) {$criteria .= " AND "; }
$criteria .= " desc_pt LIKE '%$text%'";
}
if (isset ($aft) && !($aft == "")) {
if (! ($criteria == "")) {$criteria .= " AND "; }
$criteria .= " data > '$aft'";
}
if (isset ($bef) && !($bef == "")) {
if (! ($criteria == "")) {$criteria .= " AND "; }
$criteria .= " data < '$bef'";
}
if (!($criteria == "")) {
$criteria = "WHERE ". $criteria;
}
$q = "SELECT * FROM fotos_file $criteria";
echo "$q<BR>\n";
$query = mysql_query ($q);
$res = mysql_num_rows($query);
echo "<BR>I found $res element corresponding of your demand";
}
echo "<BR><BR>\n";
echo "<BR><BR><HR><BR><BR><CENTER><A HREF=test6.txt>Load the source</A></CENTER>\n";
?>[/php]
What's all the mysql stuff for, just out of curiosity?
[php]
<?
if (!isset ($autor)) {
echo "<FORM ACTION=$PHP_SELF>\n";
echo "Autor : <INPUT TYPE=TEXT NAME=autor VALUE=Pepito><BR>\n";
echo "Text : <INPUT TYPE=TEXT NAME=text VALUE=port><BR>\n";
echo "After date : <INPUT TYPE=TEXT NAME=aft VALUE=2002-01-01><BR>\n";
echo "Before date : <INPUT TYPE=TEXT NAME=bef VALUE=2004-01-1><BR>\n";
echo "<INPUT TYPE=submit value=\"Identify\">\n";
echo "<BR><HR><BR>\n";
echo "</FORM>\n";
} else {
include "/home/httpd/html/PHP/connect.php";
connect_mysql();
$criteria = "";
if (isset ($autor) && !($autor == "")) {
$criteria .= " autor = '$autor'";
}
if (isset ($text) && !($text == "")) {
if (! ($criteria == "")) {$criteria .= " AND "; }
$criteria .= " desc_pt LIKE '%$text%'";
}
if (isset ($aft) && !($aft == "")) {
if (! ($criteria == "")) {$criteria .= " AND "; }
$criteria .= " data > '$aft'";
}
if (isset ($bef) && !($bef == "")) {
if (! ($criteria == "")) {$criteria .= " AND "; }
$criteria .= " data < '$bef'";
}
if (!($criteria == "")) {
$criteria = "WHERE ". $criteria;
}
$q = "SELECT * FROM fotos_file $criteria";
echo "$q<BR>\n";
$query = mysql_query ($q);
$res = mysql_num_rows($query);
echo "<BR>I found $res element corresponding of your demand";
}
echo "<BR><BR>\n";
echo "<BR><BR><HR><BR><BR><CENTER><A HREF=test6.txt>Load the source</A></CENTER>\n";
?>[/php]
What's all the mysql stuff for, just out of curiosity?
Alex Cavnar, aka alc6379
•
•
Join Date: Sep 2004
Location: in the j00-kay
Posts: 114
Reputation:
Rep Power: 4
Solved Threads: 5
alc: the mysql 'stuff' collects variables from the form when submitted and performs a mysql database search for records that match the submitted information. In that case, autor, text, aft and bef.
Records matching those criteria will be counted and it will display the number of records found.
Records matching those criteria will be counted and it will display the number of records found.
I'm pink, therefore, im spam.
http://www.vivaci.net - Quality Webhosting
http://gaming.vivaci.net - FAST UK Gaming servers
http://www.getsigned.org - Free Image Uploads
http://www.vivaci.net - Quality Webhosting
http://gaming.vivaci.net - FAST UK Gaming servers
http://www.getsigned.org - Free Image Uploads
•
•
Join Date: Oct 2004
Location: France / Paris
Posts: 14
Reputation:
Rep Power: 4
Solved Threads: 1
hello alc6379,
test6.php is one example about another thread 'Advanced mySQL Querys'.
Look at reference:
http://www.daniweb.com/techtalkforums/post67325.html
For this thread (Passing variables into form fields) I have write test7.php that is more simple
fpepito
sorry for my bad language, I hope that my examples is more easy to understand
test6.php is one example about another thread 'Advanced mySQL Querys'.
Look at reference:
http://www.daniweb.com/techtalkforums/post67325.html
For this thread (Passing variables into form fields) I have write test7.php that is more simple

fpepito
sorry for my bad language, I hope that my examples is more easy to understand
![]() |
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Similar Threads
- Problem passing variables to thread (Perl)
- Accessing objects that are not in the form fields (JavaScript / DHTML / AJAX)
- Passing variables from delphi to html forms (Pascal and Delphi)
- function passing variables (C)
- passing variables threw query (MySQL)
- passing values from a form to a dialog form (VB.NET)
- Passing Variables/Parameters - By Ref/Value? (Computer Science and Software Design)
Other Threads in the PHP Forum
- Previous Thread: $_POST - What does it mean?
- Next Thread: Display URL



Linear Mode