saeedjafari
دوشنبه 18 بهمن 1395, 16:28 عصر
با درود و وقت بخیر
تازه دارم پی اچ پی میخونم
این فرم و کدهارو دارم
میخام اطلاعات رودیتابیس ثبت کنم
ممنون میشم راهنمایی کنید
با تشکر
<!DOCTYPE html><html><head><title>پروژه سایت</title><link href="css/main.css" rel="stylesheet" type="text/css"><link href="css/styles.css" rel="stylesheet" type="text/css"><link href="css/verticalmenu.css" rel="stylesheet" type="text/css"><link href="css/mediaqueries.css" rel="stylesheet" type="text/css"><link href='http://fonts.googleapis.com/css?family=Crushed' rel='stylesheet' type='text/css'><!--[if lt IE 9]> <script src="js/html5.js" type="text/javascript"></script> <link href="css/ie.css" rel="stylesheet" type="text/css" /> <![endif]--><script src="js/jquery.js" type="text/javascript"></script><script src="js/main.js" type="text/javascript"></script>
</head><body><div class="pageWidth"> <!-- Start Header--> <header id="header"> <h1 id="logo">درخواست ثبت اطلاعات</h1> </header> <nav id="navigation"> <?php include 'pages/menu.php'; ?> </nav> <div> <?php include 'pages/slider.php'; ?> </div> <!-- END Header--> <!-- Start Middle--> <div id="vertical-nav"><!-- تگ ul سطح بالا --><ul class="vertical-top-level"><!-- منوی سطح بالا --><!-- منوی سطح بالا --><li><a href="newticket.php" title="New Ticket">ارسال تیکت</a></li><!-- منوی سطح بالا --><li><a href="listticket.php" title="Reply Ticket">پیگیری تیکت</a></li></ul></div> <div> <div id="newticket"> <form id="form" method="post"> <table><tr><td>عنوان</td><td><input type="text" name="txt_subject"/></td></tr><tr><td>پیام</td><td><textarea name="txt_message"></textarea></td></tr></table><center><input class="button" name="submit" type="submit" value="ارسال" /><input class="button" type="reset" value="پاک کردن" /></center><br /></form></div>
<div id="divspace"></div> <!-- End Middle--> <!-- Start Footer--> <footer> <?php include 'pages/footer.php'; ?> </footer> <!-- END Footer--> </div></div></body></html>
<?phpif (isset($_POST['submit'])){ $host = "localhost"; $dbname = "learnfiles"; $username = "root"; $password = ""; $dsn ="mysql:host=$host;dbname=$dbname"; $connection = new PDO($dsn,$username,$password); $connection->exec("set character set utf8"); $connection->exec("set names utf8"); $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $subject = $_POST['txt_subject']; $message = $_POST['txt_message']; session_start(); $email = $_SESSION['email']; $sql = "select NumberTicket from ticket where email='".$email."' Order By NumberTicket " ; $q = $connection -> query($sql); $q -> setFetchMode(PDO::FETCH_ASSOC); while($r = $q->Fetch()): $NumberTicket = $r['NumberTicket']; endwhile; $NumberTicket++; $sql = "INSERT INTO ticket(NumberTicket,email,subject,message) VALUES ('$NumberTicket','$email','$subject','$message') " ; $connection -> exec($sql);} ?>
تازه دارم پی اچ پی میخونم
این فرم و کدهارو دارم
میخام اطلاعات رودیتابیس ثبت کنم
ممنون میشم راهنمایی کنید
با تشکر
<!DOCTYPE html><html><head><title>پروژه سایت</title><link href="css/main.css" rel="stylesheet" type="text/css"><link href="css/styles.css" rel="stylesheet" type="text/css"><link href="css/verticalmenu.css" rel="stylesheet" type="text/css"><link href="css/mediaqueries.css" rel="stylesheet" type="text/css"><link href='http://fonts.googleapis.com/css?family=Crushed' rel='stylesheet' type='text/css'><!--[if lt IE 9]> <script src="js/html5.js" type="text/javascript"></script> <link href="css/ie.css" rel="stylesheet" type="text/css" /> <![endif]--><script src="js/jquery.js" type="text/javascript"></script><script src="js/main.js" type="text/javascript"></script>
</head><body><div class="pageWidth"> <!-- Start Header--> <header id="header"> <h1 id="logo">درخواست ثبت اطلاعات</h1> </header> <nav id="navigation"> <?php include 'pages/menu.php'; ?> </nav> <div> <?php include 'pages/slider.php'; ?> </div> <!-- END Header--> <!-- Start Middle--> <div id="vertical-nav"><!-- تگ ul سطح بالا --><ul class="vertical-top-level"><!-- منوی سطح بالا --><!-- منوی سطح بالا --><li><a href="newticket.php" title="New Ticket">ارسال تیکت</a></li><!-- منوی سطح بالا --><li><a href="listticket.php" title="Reply Ticket">پیگیری تیکت</a></li></ul></div> <div> <div id="newticket"> <form id="form" method="post"> <table><tr><td>عنوان</td><td><input type="text" name="txt_subject"/></td></tr><tr><td>پیام</td><td><textarea name="txt_message"></textarea></td></tr></table><center><input class="button" name="submit" type="submit" value="ارسال" /><input class="button" type="reset" value="پاک کردن" /></center><br /></form></div>
<div id="divspace"></div> <!-- End Middle--> <!-- Start Footer--> <footer> <?php include 'pages/footer.php'; ?> </footer> <!-- END Footer--> </div></div></body></html>
<?phpif (isset($_POST['submit'])){ $host = "localhost"; $dbname = "learnfiles"; $username = "root"; $password = ""; $dsn ="mysql:host=$host;dbname=$dbname"; $connection = new PDO($dsn,$username,$password); $connection->exec("set character set utf8"); $connection->exec("set names utf8"); $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $subject = $_POST['txt_subject']; $message = $_POST['txt_message']; session_start(); $email = $_SESSION['email']; $sql = "select NumberTicket from ticket where email='".$email."' Order By NumberTicket " ; $q = $connection -> query($sql); $q -> setFetchMode(PDO::FETCH_ASSOC); while($r = $q->Fetch()): $NumberTicket = $r['NumberTicket']; endwhile; $NumberTicket++; $sql = "INSERT INTO ticket(NumberTicket,email,subject,message) VALUES ('$NumberTicket','$email','$subject','$message') " ; $connection -> exec($sql);} ?>