display database mysql

sangasura · #1 (**permalink**) 05-09-2005, 12:54 PM

kenapa lps saya login, nak view data dari database tak kluar?
nak view tu saya just guna aplikasi dalam dreamweaver.

ni coding login saya

PHP Code:


			
<?php

include 'conf.php';



if($_POST)

{ 

    $_SESSION['user'] = send_login($_POST['ICNo'],$_POST['Password']);

    if(!empty($_SESSION['user']['ICNo']))

    {

        $_SESSION['user']['auth'] = True;

        header("Location: Index2.php");//sekiranya ICNo = Password

    }

    else

    {

        header("Location: LoginFail.php");//sekiranya password n ic no sama sama

    }

}



function send_login($ICNo,$Password)

{

    $qid = mysql_query("select ICNo from dbStudent where ICNo='$ICNo' and Password='$Password'");

    $data = mysql_fetch_array($qid);



    if(!empty($data))

    {

        return $data;

    }

    else

    {

        return false;

    }

}

//pres($_SESSION);

?>

dalam index2.php ada menu view my account.
bila click link ni akan paparkan data yg ada bagi user tersebut dalam dbase.
ni antara coding nak paparkan data dalam page myaccount.php

PHP Code:


			
<?php require_once('Connections/Con1.php'); ?>

<?php

$colname_MyAccount = "1";

if (isset($_GET['ICNo'])) {

  $colname_MyAccount = (get_magic_quotes_gpc()) ? $_GET['ICNo'] : addslashes($_GET['ICNo']);

}

mysql_select_db($database_Con1, $Con1);

$query_MyAccount = sprintf("SELECT * FROM dbstudent WHERE ICNo = '%s'", $colname_MyAccount);

$MyAccount = mysql_query($query_MyAccount, $Con1) or die(mysql_error());

$row_MyAccount = mysql_fetch_assoc($MyAccount);

$totalRows_MyAccount = mysql_num_rows($MyAccount);

?>

PHP Code:


			
      <th scope="row"><div align="left" class="style2">Name</div></th>

      <td colspan="6"><?php echo $row_MyAccount['Name']; ?>      </td>

masalah skrg knapa tak papar data?
someone tolong saya..

putera- · #2 (**permalink**) 10-09-2005, 02:35 PM

mysql_fetch_assoc boleh tukar kepada mysql_fetch_row

heterozigot · #3 (**permalink**) 19-09-2005, 03:45 PM

Putera, kegunaan sebenar mysql_fetch

mysql_fetch_assoc = $row['Name'] .... sahaja
mysql_fetch_row = $row[0] atau $row[1] atau $row[2] ....sahaja
mysql_fetch_array = $row[0] atau $row[1] atau $row[2] .... atau $row['Name']....

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
display data,camne???	adib	Website Programming	14	21-08-2004 10:27 AM
display value listbox	nov8998	Website Programming	1	25-06-2004 02:21 PM
nak display xml gune html bleh ke?	bloodymary	Website Design	9	24-11-2003 02:42 PM
Display contents	mysticmind	Website Design	3	04-05-2003 08:55 PM
mail () display all html codes	joyce	Website Programming	8	23-09-2002 04:36 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)