simple registration form with MySql Connection

create reg.php

<?php session_start(); $errmsg_arr = array(); $errflag = false; // configuration $dbhost = "localhost"; $dbname = "test"; $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; session_write_close(); header("location: index.php"); exit(); } // query $sql = "INSERT INTO members (fname,lname,age) VALUES (:sas,:asas,:asafs)"; $q = $conn->prepare($sql); $q->execute(array(':sas'=>$fname,':asas'=>$lname,':asafs'=>$age)); header("location: index.php"); ?>

create index.php

<?php session_start(); ?> <?php if( isset($_SESSION['ERRMSG_ARR']) && is_array($_SESSION['ERRMSG_ARR']) && count($_SESSION['ERRMSG_ARR']) >0 ) { echo '<ul style="padding:0; color:red;">'; foreach($_SESSION['ERRMSG_ARR'] as $msg) { echo '<li>',$msg,'</li>'; } echo '</ul>'; unset($_SESSION['ERRMSG_ARR']); } ?> <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>

create connect.php

<?php /* Database config */ $db_host = 'localhost'; $db_user = 'root'; $db_pass = ''; $db_database = 'test'; /* End config */ $db = new PDO('mysql:host='.$db_host.';dbname='.$db_database, $db_user, $db_pass); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); ?>