-----Mensagem Original-----
De: Marc Bragg <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviada em: sábado, 10 de março de 2001 14:46
Assunto: [PHP-DB] help on modifications / subscribe / unsubscribe script
> Am using the following subscribe/unsubscribe script with great success,
> but it does not have all the functionality I would like. Any one have
> any ideas on how to:
>
> 1. open in a java window, and once info is put, and person is
> subscribed, java window closes and a selected http page comes up?
If the selected http page can be opened in a new window you can do as
follow:
open window :
nWnd = window.open("URL","handle_var","window_configuration"); // Omitted
parameters are treated in default mode.
show passoword as "*" :
<input type="password" name="pwd">
Form configuration:
<form action="your_script.php" target="_blank" method="post">
Do not use submit button, use a standard button istead (<input type="button"
OnClick="subAction(this.form);">), write a submit function to use associated
with button OnClick event :
function subAction(aForm){
// process
aForm.submit();
// Close the subscribe window
self.close();
}
>
> 2. compare information submitted in this table, with same variable in
> another table, and if data is not there, then include it?
$query = "select from table where field = $value" ;
// Submit the query , it depends on the database you are using
if( "there is a row at least"){ // Found - condition is database dependant
file://process
}
else{
// process
$query = "insert into table values (,,,,,)";
}
// If you are using MySQL you can search for the "replace" command on the
manual
Wait for time stamp advice, I didn't work much with it.
HTH
Jayme.
>
> 3. make the password show up as ***** characters in the browser rather
> than the lettters typed by user, and add a portion of script to compare
> to what is in database, and if there, is it correct.
>
> 4. how to add minute and seconds to date stamp.
>
> Thanx
>
> Marc
>
>
> <?php
> // connect to db
> $db = mysql_connect("xxxxx","yyy") or die ("Couldn't connect.");
>
> mysql_select_db("law", $db) or die ("Couldn't select db.");
>
> // get a date stamp
> $add_date = date("Y-m-d");
>
> if ($op != "ds") {
> file://they need to subscribe or unsubscribe
> $text_block = "
> <form name=\"form\" method=post action =\"subscribe.phtml\">
> <input type=hidden name=op value =ds>
>
> <p><strong>Enter Your e-Mail Address. This will be your User
> Name:</strong><br>
> <input type=text name=\"email\" size=25></p>
> <p><strong>Enter a Password.</strong><br>
> <input type=text name=\"password\" size=25></p>
>
>
> <p><strong>Click your selection:</strong><br>
> <input type=radio name=\"action\" value=\"sub\" checked> Subscribe
> <input type=radio name=\"action\" value=\"unsub\"> Unsubscribe</p>
>
> <p><input type=submit name=\"submit\" value=\"Subscribe / Unsubscribe
> Now\"></p>
> </form>
>
> ";
>
> }
>
> else if (($op == "ds") && ($action == "sub")) {
>
> // check they're not already subscribed
> // then subscribe them or return message
>
> $check = "select email from subscribe
> where email = \"$email\"";
>
> $check_result = mysql_query($check)
> or die("Can't execute check email address.");
>
> $check_num = mysql_num_rows($check_result);
>
> if ($check_num == 0) {
>
> // if $check_num is 0, then no match was found,
> // and the user should be subscribed
>
> $sql = "insert into subscribe (email, password, add_date,
> sub_id) values(\"$email\", \"$password\", \"$
> add_date\", \"\")";
>
> @mysql_query($sql) or die ("Couldn't insert email.");
>
> $text_block = "
> <p><h1><center><font color=green>Thanks for Joining Bid
> Attorney!</h1></center></font></p>
> ";
>
> } else {
>
> // if $check_num is not 0, then the user is
> // already subscribed, and let them know it.
>
> $text_block = "
> <p><font color=green><b>You are already a member of Bid
> Attorney. Thank you!</b></font></p>
> ";
>
> }
> }
>
> else if (($op == "ds") && ($action == "unsub")) {
>
> // check they're already subscribed,
> // then unsubscribe them or return message.
>
> $check = "select email from subscribe
> where email = \"$email\"";
>
> $check_result = mysql_query($check)
> or die("Can't execute check e-mail address.");
>
> $check_num = mysql_num_rows($check_result);
>
> if ($check_num == 0) {
>
> // if $check_num is 0, then no match is found,
> // and the user cannot be unsubscribed
>
> $text_block = "
> <p><font color=red><b>Couldn't find your e-mail / user name on
> the list.</b></font></p>
> <p><i>You haven't been unsubscribed because the e-Mail you
> entered is not in
> the database.</i>";
>
> } else {
>
> // if $check_num is not 0, then the user is on the list, so can
> be unsubscribed.
>
> $sql = "delete from subscribe
> where email = \"$email\"";
>
> @mysql_query($sql) or die ("Couldn't delete email.");
>
> $text_block = "
> <p><font color=black><b> You are unsubscribed from the Bid
> Attorney Database!<i> Hope to see you back s
> oon!</i></b></font></p>
> ";
> }
> }
>
> ?>
>
> <html>
> <head>
> <title>Form: Join the Bid Attorney Database / username -
> password</title>
> </head>
> <body>
>
> <h1><font color=blue><center>Use this Form to Subscribe /
> Unsubscribe<br> to the <br>Bid Attorney Database.</ce
> nter></font></h1>
>
> <?php echo "$text_block"; ?>
>
> </body>
> </html>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
