how to insert many data in the database..?? i had the coding but it will return value to 0.. so how i'm gonna to make it appear my value..<?php require_once('Connections/mas.php'); ?><?php$host="localhost"; // Host name$username="root"; // Mysql username$password="123"; // Mysql password$db_name="mas"; // Database name$tbl_name="medic_registered_course"; // Table name// Connect to server and select database.mysql_connect("$host", "$username", "$password")or die("cannot connect");mysql_select_db("$db_name")or die("cannot select DB");// Get values from form$matric_no=$_POST['matric_no'];$block=$_POST['block'];$s_code=$_POST['s_code'];$sessi=$_POST['sessi'];$year=$_POST['year'];$group=$_POST['group'];// Insert data into mysql$sql="INSERT INTO $tbl_name(`matric_no`, `block`, `s_code`, `sessi`, `year`, `group`)VALUES('$matric_no', '$block', '$s_code', '$sessi', '$year', '$group')";$result=mysql_query($sql);// if successfully insert data into database, displays message "Successful".if($result){echo "Successful";echo "<BR>";}else {echo "ERROR";}// close connectionmysql_close();?><?phpmysql_select_db($database_mas, $mas);$query_terd = "SELECT medic_block_reg.matric_no, medic_block_reg.block, medic_block_reg.name,medic_subject_offered.s_code, medic_block_reg.sessi, medic_block_reg.`year`, medic_block_reg.`group`, medic_block_reg.status, medic_subject_offered.s_title FROM medic_block_reg, medic_subject_offered ORDER BY `matric_no` ASC";$terd = mysql_query($query_terd, $mas) or die(mysql_error());$row_terd = mysql_fetch_assoc($terd);$totalRows_terd = mysql_num_rows($terd);?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title><style type="text/css"><!--.style1 { font-size: 18px; font-weight: bold;}--></style></head><body><form id="form1" name="form1" method="post" action=""> <p align="center" class="style1">LIST REGISTERED SUBJECTS</p> <p align="center"> </p> <p>Matric No: <input name="textfield" type="text" id="textfield" value="<?php echo $row_terd['matric_no']; ?>" /> Year : <input name="textfield3" type="text" id="textfield3" value="<?php echo $row_terd['year']; ?>" size="5" /> </p> <p>Name : <input name="textfield2" type="text" id="textfield2" value="<?php echo $row_terd['name']; ?>" size="50" /></p> <p> </p></form><form id="form2" name="form2" method="post" action=""> <table width="598" height="69" border="1" align="center"> <tr> <th width="138" scope="col">S_Code</th> <th width="124" scope="col">S_Title</th> <th width="79" scope="col">Sessi</th> <th width="72" scope="col">Block</th> <th width="73" scope="col">Group</th> <th width="72" scope="col">Status</th> </tr> <tr> <td><div align="center"><?php echo $row_terd['s_code']; ?></div></td> <td><?php echo $row_terd['s_title']; ?></td> <td><div align="center"><?php echo $row_terd['sessi']; ?></div></td> <td><div align="center"><?php echo $row_terd['block']; ?></div></td> <td><div align="center"><?php echo $row_terd['group']; ?></div></td> <td><div align="center"><?php echo $row_terd['status']; ?></div></td> </tr> </table> <p> </p> <p align="center"> <input type="submit" name="button" id="button" value="ADD" /> <input type="submit" name="button2" id="button2" value="DROP" onclick="return confirmLink(this, 'ALTER TABLE `medic_registered_course` DROP `matric_no`')"/> </p> <div align="center"> <p> </p> <p class="style10"><a href="reg_main.php">Back</a> | <a href="main.php">Module Menu</a> | <a href="<?php echo $logoutAction ?>" onclick="MM_popupMsg('You\'re successfully logout from this system...')">Logout</a></p> </div></form></body></html><?phpmysql_free_result($terd);?>
help me plezz
Posted - 2008-06-23 : 00:07:13
