spanner206 Posted November 5, 2013 Share Posted November 5, 2013 Hi ive been trying to do this all day, what i want to do is make a form validatation where it checks if all fields are filled but i cant seem to hack it ive checked w3 schools but i just cant seem to hack it at one point today i got it but it waent putting data into a database. heres the main document <?php $con=mysqli_connect("","","",""); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql="INSERT INTO tbl_club_contacts (CompanyName) VALUES ('$_POST[CompanyName]')"; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } echo "record added"; mysqli_close($con); ?> <html> <body> <form action="copyofaddleads2.php" method="post"> <input type="submit", value = "go back"> </form> </body> </html> heres the insert <?php $con=mysqli_connect("","","",""); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql="INSERT INTO tbl_club_contacts (CompanyName, FirstName, Address1, Address2, Area, City) VALUES ('$_POST[companyname]','$_POST[firstname]','$_POST[address1]','$_POST[address2]','$_POST[area]','$_POST[city]')"; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } echo "record added"; mysqli_close($con); ?> <html> <body> <form action="addleads2.php" method="post"> <input type="submit", value = "go back"> </form> </body> </html> Link to comment https://forums.phpfreaks.com/topic/283620-validation/ Share on other sites More sharing options...
cyberRobot Posted November 5, 2013 Share Posted November 5, 2013 If all the form fields are required, you could loop through the POST array. <?php foreach($_POST as $fieldName=>$fieldValue) { if($fieldValue == '') { print "<div>$fieldName is blank</div>"; } } ?> Side note: you'll also want to look into protecting your queries from SQL injections. One way is to use mysqli_real_escape_string(): http://php.net/manual/en/mysqli.real-escape-string.php Link to comment https://forums.phpfreaks.com/topic/283620-validation/#findComment-1457057 Share on other sites More sharing options...
spanner206 Posted November 5, 2013 Author Share Posted November 5, 2013 what i was thinking was to put a prompt in if one wasent filled in Link to comment https://forums.phpfreaks.com/topic/283620-validation/#findComment-1457061 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.