Hey i think u hve posted a form titled
have a problem in arrays that having multiple forms.
i hve posted a reply for it try to execute it 1's...then i hope u wont get any doubts on inserting the data.
anyways here is code for u ....check it out ..
Code:-[HTML]
form.html
<form name="" method="POST" action="insert.php">
<td>Bachelor Degree<input type="text" name="bachelordegree"/>
</td><br>
<td>School Name<input name="sschoolname" type="text" />
</td><br>Year Graduated<input type="text" name="yeargraduated" />
</td><br><input type="submit" name="submit" value="submit">
</form>
[/code]
CODE:-[PHP]
dbConnect.php
if ($connection_type == "local")
{
$db_servername="localhost";
$db_username="root";
$db_password="";
$db_name="form";
$db_link = mysql_connect($db_servername, $db_username, $db_password) or die("could not connect to the local atebase server");
$db= mysql_select_db($db_name,$db_link) or die("Not a valid database");
}
[/code]
change the database name accordingly...here it is "form".
CODE:-[PHP]
function.php
<?php
class execute_query
{
//getting the list of categorys
function get_result_details($select_query)
{
require 'dbConnect.php';
$results=array();
$select_query_result=mysql_query($select_query,$db _link) or die(" Not a valid Select Query Category ".mysql_error());
if(mysql_num_rows($select_query_result) > 0)
{
while($get_details=mysql_fetch_array($select_query _result))
{
$array_count=count($get_details)/2;
for($i=0;$i<$array_count;$i++)
{
$results[]=$get_details[$i];
}
}
}
//To Free the result set
mysql_free_result($select_query_result);
//To Close the connection object
mysql_close($db_link);
return $results;
}
//Insert Query function ....
function insert_query($insert_query)
{
require 'dbConnect.php';
$insert_id="";
$insert_query_result=mysql_query($insert_query,$db _link) or die(" Not a valid Insert Query ".mysql_error());
$insert_id=mysql_insert_id();
mysql_close($db_link);
return $insert_id;
}
}
?>
[/code]
CODE:-[php]
insert.php
<?
session_Start();
require 'function.php';
$obj_query= new execute_query();
$bachelordegree=$_POST['bachelordegree'];
$sschoolname=$_POST['sschoolname'];
$yeargraduated=$_POST['yeargraduated'];
$insert_name="insert into bachelor (bachelordegree,sschoolname,yeargraduated) values ('$bachelordegree','$sschoolname','$yeargraduated' )";
$insert_value= $obj_query->insert_query($insert_name);
header("Location:form.html");
exit;
?>
[/code]
CODE:- text.
database text.
-- phpMyAdmin SQL Dump
-- version 2.6.1
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 22, 2008 at 11:13 AM
-- Server version: 4.1.9
-- PHP Version: 4.3.10
--
-- Database: `form`
--
-- --------------------------------------------------------
--
-- Table structure for table `bachelor`
--
DROP TABLE IF EXISTS `bachelor`;
CREATE TABLE `bachelor` (
`bachelor_id` int(11) NOT NULL auto_increment,
`bachelordegree` varchar(100) NOT NULL default '',
`sschoolname` varchar(100) NOT NULL default '',
`yeargraduated` varchar(100) NOT NULL default '',
PRIMARY KEY (`bachelor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `bachelor`
--
INSERT INTO `bachelor` VALUES (1,'BSC', 'Keys high school', '2000');