bxmachines77

Hello, I'm attempting to get this password protect script going with very little knowledge. It has statements in it that should show up on the browser window but nothing is there. Thanks in advance for any ideas. Best regards, Bill [code]<?php?> <p><br /><br />These accounts need to be manually configured. A valid email is required so the Administration can drop you a line to let you know when your profile is ready to use. Thank you for your paitence.<br /><br /></p> <form name="join" method="post" action="<?php echo $domain.$folder.'verify.php';?>"> <input type="hidden" name="new" value="1" /> <div style="position:relative;float:left;clear:left"><p> Username: <br /><input type="text" name="0" /><br /><br /> Your Email: <br /><input type="text" name="3" value="you@isp.com" /><br /></p></div> <div style="position:relative;float:right;clear:right"><p> Password: <br /><input type="password" name="1" /><br /><br /> Confirm It: <br /> <input type="password" name="2" /><br /></p></div> <p>Are you exactly 13 years old or older?</p> <p>Yes: <input type="radio" name="asl" value="yes" /> No: <input type="radio" name="asl" value="no" /><br /><br /> <input type="submit" value="Join Now!" /></form><br /><br /> By submitting this form you are agreeing to be bound by the Terms of Service. You can read the terms of service at the bottom of this very page!</p> <br /><br /> </p> <h1><br /><br />The T.O.S.</h1> <p>I will delete your account for these reasons.<br /> This is what a user is entitled to and what the provider provides.<br /> I am not responsible for any losses, real or percieved, based on your use of this service. </p>[/code]

Thanks to everyone it's now up and running fine. I couldn't have done it without your kind help. It's for a good cause. Best regards, Bill

[!--quoteo(post=382762:date=Jun 12 2006, 01:26 AM:name=Crayon Violent)--][div class=\'quotetop\']QUOTE(Crayon Violent @ Jun 12 2006, 01:26 AM) [snapback]382762[/snapback][/div][div class=\'quotemain\'][!--quotec--] are you sure your columns are the correct data type for what you are trying to insert into them? that is, you cannot insert text into a column that is a number type, like int. [/quote] Hello, Yes, I'm certain that part is right except I didn't know what to use for check marks and have it as bool. I don't know if that's right. It doesn't post any of the info for some reason.

Hello, I figured out the syntax error and it now posts the check boxes to the server but not any of the text. I appreciate your help if anyone has any ideas. The server side looks like it's setup right and it wants to give an error message after posting but it's blank after the word error. Thanks again,

Hello all, Thanks so much for your kind help. It was at least giving me error messages with the added error code but now I get the white screen of death with my code and the one above. The error code was that the values couldn't have '', so I tried nothing and; [''],[],[];['']; and all gave a sytax error but nothing but a white screen now. I'm doing this for a non profit place so any more ideas would be great. Thanks in advance.

[!--quoteo(post=382421:date=Jun 11 2006, 01:56 AM:name=Crayon Violent)--][div class=\'quotetop\']QUOTE(Crayon Violent @ Jun 11 2006, 01:56 AM) [snapback]382421[/snapback][/div][div class=\'quotemain\'][!--quotec--] you pretty much throw away your old code and use that instead. except, use the correct table name in your sql query (servicerecord) [/quote] Could some one teel me what to insert into the new code and were. Please be specific, I'm really new at this. Thanks in advance.

Could someone please explain what to put into and were to put it into the above code so it works? I'm desperate to get this working for a non profit agency. Thanks in advance for your input.

[!--quoteo(post=382261:date=Jun 10 2006, 12:43 PM:name=joquius)--][div class=\'quotetop\']QUOTE(joquius @ Jun 10 2006, 12:43 PM) [snapback]382261[/snapback][/div][div class=\'quotemain\'][!--quotec--] This script is a bit harsh. Too much code I would advise using the following method: $sql = ""; foreach ($_POST as $field => $value) { if ($value != "") { $append = ($sql == "") ? "" : ", "; $sql .= "$append'$value'"; } } $query = "INSERT INTO `db` VALUES ($sql)"; and if that does work out add another $sql for the field names according to the form input names, and match them with the db field names. [/quote] Could you please tell me what I need to insert into this and where? I'm really new at this. The colum didn't work. I appreciate your help. Thanks.

Hello, I'm very new at PHP and SQL with enough knowledge to first build a table and try to fill it with the code below. The problem is even though it says your information was posted to the server, nothing is there. I don't know if I need to query it but it's suppose to post into the table which is in the script. I appreciate any help and thanks in advance. <?php $textbox1name = $_POST['textbox1name']; $textbox2date = $_POST['textbox2date']; $check1male = $_POST['check1male']; $check2female = $_POST['check2female']; $text3phone = $_POST['text3phone']; $textbox4county = $_POST['textbox4county']; $check3personwithimpairment = $_POST['check3personwithimpairment']; $check4family_member_significant_other = $_POST['check4family_member_significant_other']; $textbox5other_specify = $_POST['textbox5other_specify']; $textbox6business_agency = $_POST['textbox6business_agency']; $chech5advocacy_legal_services = $_POST['chech5advocacy_legal_services']; $check9_architectual_barrier_services = $_POST['check9_architectual_barrier_services']; $check7_assistive_devices_equipment_services = $_POST['check7_assistive_devices_equipment_services']; $check8_benefits_advisment = $_POST['check8_benefits_advisment']; $check10_business_industry_agency_services = $_POST['check10_business_industry_agency_services']; $check11_childrens_services = $_POST['check11_childrens_services']; $check12_communication_services = $_POST['check12_communication_services']; $check13_family_services = $_POST['check13_family_services']; $check14_housing_home_modification_other_shelter_services = $_POST['check14_housing_home_modification_other_shelter_services']; $chech15_il_skills_traing_life_skills_training = $_POST['chech15_il_skills_traing_life_skills_training']; $check16_inforamtion_referral = $_POST['check16_inforamtion_referral']; $check17_mobility_training = $_POST['check17_mobility_training']; $check18_peer_counseling_services= $_POST['check18_peer_counseling_services']; $check19_preventative_services = $_POST['check19_preventative_services']; $check20_prostheses_orthics_other_appliances = $_POST['check20_prostheses_orthics_other_appliances']; $check21_recreational_services = $_POST['check21_recreational_services']; $check22_rehabilitation_technology_services = $_POST['check22_rehabilitation_technology_services']; $check24_transportation_services = $_POST['check24_transportation_services']; $check25_youth_services = $_POST['check25_youth_services']; $check26_vocational_services = $_POST['check26_vocational_services']; $check27_voter_reistration = $_POST['check27_voter_reistration']; $textbox7_staff_person_date1 = $_POST['textbox7_staff_person_date1']; $textbox8_staff_person_date2 = $_POST['textbox8_staff_person_date2']; mysql_connect("localhost.org.com", "61606", "password") or die(mysql_error()); mysql_select_db("61606") or die(mysql_error()); mysql_query("INSERT INTO `servicerecord` VALUES ('$textbox1name', '$textbox2date', '$check1male', '$check2female', '$text3phone', '$textbox4county', '$check3personwithimpairment', '$check4family_member_significant_other', '$textbox5other_specify', '$textbox6business_agency', '$chech5advocacy_legal_services', '$check9_architectual_barrier_services', '$check10_business_industry_agency_services', '$check11_childrens_services', '$check12_communication_services', '$check13_family_services', '$check14_housing_home_modification_other_shelter_services', '$chech15_il_skills_traing_life_skills_training', '$check16_inforamtion_referral', '$check17_mobility_training', '$check18_peer_counseling_services', '$check19_preventative_services', '$check20_prostheses_orthics_other_appliances', '$check21_recreational_services', '$check22_rehabilitation_technology_services', '$check24_transportation_services', '$check25_youth_services', '$check26_vocational_services', '$check27_voter_reistration', '$textbox7_staff_person_date1', '$textbox8_staff_person_date2')"); Print "Your information has been successfully added to the database."; ?>