Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
mga boss, undefined index din s akin na error.. supposedly na tapos ko na 2 na page (adding member) pero dinagdagan ko lang ng function na nagvverify if the username is exist, pagkatapos niya nagsimula na siya mg error kaya ang ginawa ko tinanggal ko ulit.. inayos ko, binalik ko sa dati, pero meron nang mga error.. ginamit ko na ang isset() at empty() pero wala pa rin... may idea kaau paano ito ausin, gumana nman 2 nuon walang error.. ngaun lang talaga.. tsk2!
<?php
include_once('include/connection.php');
?>
<html>
<head>
<title>STUDENT INFORMATION</title>
<style>
* {
padding: 0px;
margin: 0px;
}
body {
background-color: rgb(122,146,133);
}
#wrapper {
margin: 0 auto 0;
width: 800px;
background: white;
border: solid #868b77;
}
#header {
width: 800px;
height: 150px;
background: #5090e4;
border-bottom: solid #868b77;
margin-bottom: 20px;
}
#header img {
margin-left: 100px;
}
#content {
width: 800px;
float: left;
margin-bottom: 15px;
}
#content table {
margin: 45px auto 0;
}
h2 {
color: #ee8027;
margin-left:250px;
}
h1 {
color: #ee8027;
font-style: tahoma;
font-size: 50px;
}
#button {
width: 800px;
float: left;
}
#button #right {
margin-left: 650px;
}
#footer {
background: #5090e4;
width: 800px;
height: 60px;
clear: both;
border-top: solid #868b77;
}
#footer p {
color: orange;
padding-top: 20px;
padding-left: 5px;
}
</style>
</head>
<body>
<div id="wrapper">
<div id="header"><img src="images/SISlgo_01.gif"/></div>
<div id="content">
<h2>Successfully Registered!</h2>
<?php
if(!isset($_POST['submit']))
{
header('Location: add_stud.php');
}
else
{
$stud_id = addslashes($_REQUEST['stud_id']);
$username = addslashes($_REQUEST['username']);
$retrieve_pass = addslashes($_REQUEST['password']);
$password = addslashes(md5($_REQUEST['password']));
$firstname = addslashes($_REQUEST['fname']);
$middlename = addslashes($_REQUEST['mname']);
$lastname = addslashes($_REQUEST['lname']);
$b_day = addslashes($_REQUEST['b_day']);
if(isset($_REQUEST['course']))
{
foreach($_REQUEST['course'] as $key => $value)
{
$course = $value;
}
}
if(isset($_REQUEST['year']))
{
foreach($_REQUEST['year'] as $key => $value)
{
$year = $value;
}
}
$c_address = addslashes($_REQUEST['c_address']);
$p_address = addslashes($_REQUEST['p_address']);
$email = addslashes($_REQUEST['email']);
$phone = addslashes($_REQUEST['phone']);
$sqlQuery = "INSERT INTO student(stud_id, username, password, firstname, middlename, lastname, b_day, course, year1, c_address, p_address, email, phone, retrieve_pass) VALUES('$stud_id','$username', '$password', '$firstname','$middlename','$lastname','$b_day','$course','$year','$c_address','$p_address','$email','$phone','$retrieve_pass')";
$result = mysql_query($sqlQuery);
}
?>
<table>
<tr>
<td>Student ID</td><td></td>
</tr>
<tr>
<td>Username</td><td><?php echo $username; ?></td>
</tr>
<tr>
<td>Password</td><td><?php echo "Private"; ?></td>
</tr>
<tr>
<td>Firstname</td><td><?php echo $firstname; ?></td>
</tr>
<tr>
<td>Middlename</td><td><?php echo $middlename; ?></td>
</tr>
<tr>
<td>Lastname</td><td><?php echo $lastname; ?></td>
</tr>
<tr>
<td>Birthdate</td><td><?php echo $b_day; ?></td>
</tr>
<tr>
<td>Course/Year</td><td><?php echo $course."/".$year; ?></td>
</tr>
<tr>
<td>City Address</td><td><?php echo $c_address; ?></td>
</tr>
<tr>
<td>Provincial Address</td><td><?php echo $p_address; ?></td>
</tr>
<tr>
<td>E-mail</td><td><?php echo $email; ?></td>
</tr>
<tr>
<td>Contact #</td><td><?php echo $phone; ?></td>
</tr>
</table>
</div>
<div id="button">
<span><a href="home.php"><img src="images/icon_12.gif"/></a></span>
<span id="right"><a href="home.php"><img src="images/icon_13.gif"/></a></span>
</div>
<div id="footer">
<p></p>
</div>
</div>
</body>
</html>
Salamat!
Godbless!
)
