Information Technology
I really want to know about your work....
CREATE TABLE IF NOT EXISTS `members` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fname` varchar(100) NOT NULL, `lname` varchar(100) NOT NULL, `age` int(5) NOT NULL, ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
<?php ?> <?php echo '<ul style="padding:0; color:red;">'; foreach($_SESSION['ERRMSG_ARR'] as $msg) { echo '<li>',$msg,'</li>'; } echo '</ul>'; } ?> <form action="reg.php" method="POST"> First Name<br> <input type="text" name="fname" /><br> Last Name<br> <input type="text" name="lname" /><br> Age<br> <input type="text" name="age" /><br> <input type="submit" value="Save" /> </form>
<?php $errflag = false; // configuration $dbhost = "localhost"; $dbname = "pdo_ret"; $dbuser = "root"; $dbpass = ""; // database connection $conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass); // new data $fname = $_POST['fname']; $lname = $_POST['lname']; $age = $_POST['age']; if($fname == '') { $errmsg_arr[] = 'You must enter your First Name'; $errflag = true; } if($lname == '') { $errmsg_arr[] = 'You must enter your Last Name'; $errflag = true; } if($age == '') { $errmsg_arr[] = 'You must enter your Age'; $errflag = true; } if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; } // query $sql = "INSERT INTO members (fname,lname,age) VALUES (:sas,:asas,:asafs)"; $q = $conn->prepare($sql); ?>