Coding Help!

[jushiro]

Im making an E-learning system that when Student registers the Teacher will approve..

So i've got here a code that outputs all those who registered via Checkbox.

 

<form name="formapprove" method="POST" action="valval3.php" >
<div id="apDiv12"><input type="image" src="images/Approve.png" name="approve" value="approve" width="170" height="35" border="0" >
</div>
  <div id="apDiv11">
  <input type="image" src="images/reject.png" name="reject" width="170" height="35" border="0" value="reject">
</div>
  <div id="apDiv14">';
$host="localhost"; 
$username="root"; 
$password="";
$db_name="dbreg";
$tbl_name="account"; 

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
echo "<table border=\"5\" width=\"400\" >";
echo "<tr><th>List of Student to be approve</th>";
    if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
echo "<tr><td>";
    echo "<input type='checkbox' name='list[]' value='".$row['Username']."'>".$row['famname'].",".$row['gname']. ",".$row['mname']. ".<br/></td>"; 
    echo "</tr></input>";
   } 

}
    else {		
    echo "<tr><td align=\"center\"> No Student to be Approve / Reject </td></tr>";  
    } 	

echo'

</form>

 

Then the file "valval3.php" will be the one that will save the variables in my database..

 

<?php
session_start();  
if(isset($_SESSION['uname2']) || ($_SESSION['section'])){
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  

if(isset($_POST['approve_x'], $_POST['approve_y'])) {

mysql_select_db("dbreg", $con);
$uname = $_SESSION['uname2'];
$sec = $_SESSION['section'];

$sql="SELECT * FROM account where sec='$sec'";
$result=mysql_query($sql);
if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
$fullname = "" .$row['famname']. ", " .$row['gname']. " " .$row['mname']. ".";
}



foreach ($_POST['list'] as $checkbox)
{	
		$sql="SELECT * FROM account WHERE sec='$sec'";
}

$result=mysql_query($sql);
if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
    $username = $row['Username'];
$password = $row['Password'];
$gname = $row['gname'];
$mname = $row['mname'];
$famname = $row['famname'];
$sec = $row['sec'];
$studnum = $row['studnum'];
$fullname = "" .$row['famname']. ", " .$row['gname']. " " .$row['mname']. ".";

$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

$gname = stripslashes($gname);
$famname = stripslashes($famname);
$gname = mysql_real_escape_string($gname);
$famname = mysql_real_escape_string($famname);

$mname = stripslashes($mname);
$mname = mysql_real_escape_string($mname);


foreach ($_POST['list'] as $checkbox)
{	
		mysql_query("INSERT INTO dbaccount (Username, Password, gname, famname, mname, sec, studnum, fullname)
VALUES ('$username', '$password', '$gname', '$famname', '$mname', '$sec',  '$studnum', '$checkbox')") or die(mysql_error);

		mysql_query("DELETE FROM account WHERE sec='$sec'") or die(mysql_error);
}

echo '<script type="text/javascript">
{alert("Approved!");}
</script>'; 
echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">';
mysql_close($con);
}	
}
else {
echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">';
}
}elseif(isset($_POST['reject_x'], $_POST['reject'])) {


mysql_select_db("dbreg", $con);


foreach ($_POST['list'] as $checkbox)
{	
		$sql="SELECT * FROM account WHERE sec='$sec'";
}

$result=mysql_query($sql);

if(mysql_num_rows($result)) 
    { 

foreach ($_POST['list'] as $checkbox)
{	
		mysql_query("DELETE FROM account WHERE sec='$sec'") or die(mysql_error);
}


echo '<script type="text/javascript">
{alert("Rejected!");}
</script>'; 
echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">';
}	

else {   	echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">';
}

}	 else {   	echo '<meta http-equiv="REFRESH" content="0;url=approvereject2.php">';
}
}
}
else {
header("location:failunautho.php");;
}
?>

 

I tested my codes. Its only working if theres only 1 user registered ( which means one checkbox would appear in page)

But when i tested to have 3 users registered and not yet approve, There would be an error saying..

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 49

 

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 49

$username = mysql_real_escape_string($username); <-- line #49

 

 

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 50

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 50

$password = mysql_real_escape_string($password); <-line #50

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 54

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 54

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 55

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 55

 

$gname = mysql_real_escape_string($gname); <-line #54

$famname = mysql_real_escape_string($famname); <-line# 55

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 58

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 58

mname = mysql_real_escape_string($mname); <-line #58

 

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 64

 

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 64

mysql_error

VALUES ('$username', '$password', '$gname', '$famname', '$mname', '$sec',  '$studnum', '$checkbox')") or die(mysql_error) <-line #64

 

Then still it saves 3 variables.. but all the same.

Hope Someone could help me ..

[voip03]

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Documents and Settings\Ken\Desktop\xampplite\htdocs\Pages\valval3.php on line 49

Have you connected to your MySQL database ?

 

 

[jushiro]

Yes i Did.. it was at line 4 at file "vaval3.php".

 

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

 

It works well if one variables would be inserted in the database..

But since i registered 3 variables.. There would be 3 checkbox that would output in the pages.

When i checked all the boxes then click the approve button.. That error would appear.

[voip03]

Missing <php ?> code in form .

<?php
$host="localhost";
$username="root"; 
$password="";
$db_name="dbreg";
$tbl_name="account"; mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
echo "<table border=\"5\" width=\"400\" >";echo "<tr><th>List of Student to be approve</th>";    
if(mysql_num_rows($result))     {     while($row = mysql_fetch_assoc($result))     { 	echo "<tr><td>";    
echo "<input type='checkbox' name='list[]' value='".$row['Username']."'>".$row['famname'].",".$row['gname']. ",".$row['mname']. ".<br/></td>";     
echo "</tr></input>";   } 	

}    else {		    echo "<tr><td align=\"center\"> No Student to be Approve / Reject </td></tr>";      } 	
echo'</form>';
?>

[jushiro]

Oops.. sorry for that' but i already included that on top of my codes..

I just forgot to put it in here.

[voip03]

can you post me new code

[jushiro]

<?php
<form name="formapprove" method="POST" action="valval3.php" >
<div id="apDiv12"><input type="image" src="images/Approve.png" name="approve" value="approve" width="170" height="35" border="0" >
</div>
  <div id="apDiv11">
  <input type="image" src="images/reject.png" name="reject" width="170" height="35" border="0" value="reject">
</div>
  <div id="apDiv14">
$host="localhost"; 
$username="root"; 
$password="";
$db_name="dbreg";
$tbl_name="account"; 

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
echo "<table border=\"5\" width=\"400\" >";
echo "<tr><th>List of Student to be approve</th>";
    if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
echo "<tr><td>";
    echo "<input type='checkbox' name='list[]' value='".$row['Username']."'>".$row['famname'].",".$row['gname']. ",".$row['mname']. ".<br/></td>"; 
    echo "</tr></input>";
   } 

}
    else {		
    echo "<tr><td align=\"center\"> No Student to be Approve / Reject </td></tr>";  
    } 	

</form> ?>

its just the same..

ony with the "<?php "..

Help me with this one pls..

[ZulfadlyAshBurn]

try this

 

<form name="formapprove" method="POST" action="valval3.php" >
<div id="apDiv12"><input type="image" src="images/Approve.png" name="approve" value="approve" width="170" height="35" border="0" >
</div>
<div id="apDiv11">
<input type="image" src="images/reject.png" name="reject" width="170" height="35" border="0" value="reject">
</div>
<div id="apDiv14">
<?php
$host="localhost"; 
$username="root"; 
$password="";
$db_name="dbreg";
$tbl_name="account"; 

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
echo "<table border=\"5\" width=\"400\" >";
echo "<tr><th>List of Student to be approve</th>";
if(mysql_num_rows($result)) 
{ 
while($row = mysql_fetch_assoc($result)) 
{ 
echo "<tr><td>";
echo "<input type='checkbox' name='list[]' value='".$row['Username']."'>".$row['famname'].",".$row['gname']. ",".$row['mname']. ".<br/></td>"; 
echo "</tr></input>";
} 

}
else {		
echo "<tr><td align=\"center\"> No Student to be Approve / Reject </td></tr>";  
} 	
echo "</form>";
?>

[jushiro]

Hi.. thx for helping..

But, It still has the same error..

I think i have my problem with the array

"foreach ($_POST['list'] as $checkbox)" <- i think this code has the

problem.. but i dont know how to make it work.