[SOLVED] dynamic php

[girlzz]

if there any easiest way to make dynamic form just using php coding??? i had a problem which is if i insert matric_no then if the matric_no that i had insert exist in the database,the name of the student that hold the matric_no automatically appear... i want to do with php and ajax but i not familiar with ajax.. can some one help me with this problem...?? i prefer php coding... thanks...

[trq]

You need to describe your actual problem sorry. Your post doesn't make allot of sense from here.

[girlzz]

sorry... i had 2 textfield which contain id and name... my problem is.. when i insert id, i want textfield name automatic detect the id that i had inserted...

[papaface]

http://uk2.php.net/manual/en/function.mysql-insert-id.php

[girlzz]

sorry..what i means is for example..

 

id :______

(this id will be key in by user)

name:________

(when user key in id, then automatic appear the name)...

 

i found lot of ajax script but i'm not familiar with ajax eventhough i had read it several time, so i prefer if my problem can be solve by php languange....

[samshel]

getname.php

<?php
//replce DB credentials and name here
$db = mysql_connect("db_server", "db_user_name", "db_password");
mysql_select_db("db_name");

if($_POST['submit']) {
  $sql = "select `name` from student where id = '".mysql_escape_string($_POST['id'])."'";
  $res = mysql_query($sql);
  if(mysql_num_rows($res)>0) {
    $row = mysql_fetch_array($res); 
    $strName = $row['name'];
  } else {
    $strName = "No Student with this id..";
  }
}

?>
<form method="POST" action="getname.php">
<input type="text" name="id" value="<?php echo $_POST['id'] ?>" /><br/>
<input type="text" name="student" value="<?php echo $strName; ?>" />
<input type="submit" name="submit" value="Submit" />
</form>

 

something like this ??

[girlzz]

yup but your script look like if you enter the submit button just then the name will appear,right?? correct me if i'm wrong

[samshel]

correct...page will refresh..if you dont want that to happen, you need to use AJAX

[girlzz]

still need to use ajax..?? thanks for your information..