<li><a href="secure.php"><center>Secure Section</center></a></li> <li><a href="user.php"><center>User</center></a><li> </ul> </nav> <div id="content_area"> <?php //DB Credentials $username = "******"; $host = "localhost"; $database = "dextrousdb"; $password = ""; //Connect to Database $conn = connectDB($host, $database, $username, $password); //Build insert Query $queryI = buildInsertQuery(); //print($queryI); runInsertQuery($queryI, $conn); print "<span style =\"color:black;\"><center>\n User inserted! Here is the data which was saved:</center><br/></span>\n "; //Print inserted record printLastIns(); function buildInsertQuery() { extract($_POST); $part1 = "INSERT INTO dextrousdb.users (fname,lname,email,haddr,hphone,cphone) VALUES("; $part2 = "'" . $i_fname . "'," . "'" . $i_lname . "'," . "'" . $i_email . "'," . "'" . $i_haddr . "'," . "'" . $i_hphone . "'," . "'" . $i_cphone . "')"; $query = $part1 . $part2; return $query; } function connectDB($host, $database, $username, $password) {
<?php session_start(); $productid = $_GET['product']; $userid = $_SESSION['username']; //DB Credentials $username = "******"; $host = "localhost"; $database = "vishwasm_marketplace"; $password = "******"; //Connect to Database $conn = connectDB($host, $database, $username, $password); //Build insert Query $queryI = buildInsertQuery($userid, $productid); runInsertQuery($queryI, $conn); function buildInsertQuery($userid, $productid) { $part1 = "INSERT INTO vishwasm_marketplace.userlog(user_id,product_id) VALUES("; $part2 = "'" . $userid . "'," . $productid . ")"; $query = $part1 . $part2; return $query; } function connectDB($host, $database, $username, $password) { if (!($conn = @mysql_connect($host, $username, $password))) { die("Could not connect to database" . mysql_error()); } if (!mysql_select_db($database, $conn)) { die("Could not open database" . mysql_error()); } return $conn;