Display mySQL data
ok, first of beginner using dw, php, , mysql.
ok, i've figured out how set connection , i'm using user authentication behaviour. works great.!
but want able display data out of record of person has logged in. example, used username , password login. , want display name (out of database field) on "success" page after login.
how accomplish this? thanks!
ok, i've figured out how set connection , i'm using user authentication behaviour. works great.!
but want able display data out of record of person has logged in. example, used username , password login. , want display name (out of database field) on "success" page after login.
how accomplish this? thanks!
you first need declare session variable in behaviors panel. need declare variable in form , on page. code on login page looks this:
<form id="form1" name="form1" method="post" action="">
<p>
<input name="username" type="text" id="username" />
</p>
<p>
<input name="password" type="text" id="password" />
<input type="submit" name="submit" value="submit" />
</p>
</form>
then declare session variables in behaviors panel, 1 named username , other named password (or name of 2 fields made username , password field.
then on second page put code @ top:
<?php $username=$_get['username'];?>
then in recordset set username column of database session variable "username"
that should work you.
<form id="form1" name="form1" method="post" action="">
<p>
<input name="username" type="text" id="username" />
</p>
<p>
<input name="password" type="text" id="password" />
<input type="submit" name="submit" value="submit" />
</p>
</form>
then declare session variables in behaviors panel, 1 named username , other named password (or name of 2 fields made username , password field.
then on second page put code @ top:
<?php $username=$_get['username'];?>
then in recordset set username column of database session variable "username"
that should work you.
More discussions in Develop server-side applications in Dreamweaver
adobe
Comments
Post a Comment