Kode saya adalah:
1. <?php
2. session_start(); //
built in php function to start
the session array
3.
4. require_once('../includes/admin/db.php'); //
database connection
5. $conn = dbConnect('admin');
6.
7. if(isset($_POST['login'])) {
8. $sql='SELECT * FROM admin WHERE
username=? AND passwd=?';
9. $pds=$conn->prepare($sql);
10. $pds->execute(array($_POST['username'],(sha1($_POST['passwd']))));
11. if($pds->fetchColumn(0)) { // Success
12. $_SESSION['admin']=$_POST['username'];
13.
14. }
15. else { //
Failure
16. $error='<p>Unsuccessful Login</p>';
17.
18. }
19. }
20. elseif(isset($_POST['logout'])) {
21. unset($_SESSION['admin']); // closes
the admin session
22. setcookie(session_name(),'',time()-86400);
23. session_destroy();
24. }
25.--------
26.Line
27 $username = $_POST['username'];
27.$sql
= 'SELECT team FROM users WHERE username = "$username"';
28.if
(!$sql) {
29. echo 'Could not run query: ' . mysql_error();
30. exit;
31.}
32.$teamName
= mysql_fetch_row($sql);
ini yang saya ketahui dan saya coba dan masih ada kendala, silahkan dicoba bila ada kesalahan mohon dibenarkan
terima kasih
Post a Comment