Expand|Select|Wrap|Line Numbers
- Hello,
- My problem is when I click on submit button after select the name from the dropdown list, the serial no. of the names get inserted into database, but i want to insert the name. I tried a lots but i could not did it.
- Plz help me.........
- here is code:-
- ..............
- page1.php
- <?php
- require('dbconnect.php');
- $obj_db = new db_connection();
- $obj_db->set_dbconnection();
- ?>
- <form name="frm1" action="process.php" method="post">
- <table border="0">
- <tr>
- <td>Author</td>
- <td><select name="author" id="author">
- <option value="NA">-SELECT-</option>
- <?php
- $s_pref = "SELECT author_id AS value,author_name AS text FROM author_table ORDER BY author_name";
- $res=mysql_query($s_pref);
- while($row=mysql_fetch_object($res)):
- $authorId=$row->value;
- $authorName=$row->text;
- ?>
- <option value="<?php echo $authorId; ?>"><?php echo $authorName; ?> </option>
- <?php
- endwhile;
- ?>
- </select></td>
- <td>Publication</td>
- <td><select name="publication" id="publication">
- <option value="NA">-Select-</option>
- <?php
- $s_pref1 = "SELECT publication_id AS value,publicationname AS text FROM publication ORDER BY publicationname";
- $res1=mysql_query($s_pref1);
- while($row=mysql_fetch_object($res1)):
- $publicationId=$row->value;
- $publicationName=$row->text;
- ?>
- <option value="<?php echo $publicationId; ?>"><?php echo $publicationName; ?> </option>
- <?php
- endwhile;
- ?>
- </select></td>
- </td>
- <tr>
- <td><input type="submit" value="SUBMIT"/></td>
- </tr>
- </table>
- </form>
- </tr>
- ..................................................................
- process.php
- <?php
- session_start();
- //** DB connection **//
- require('dbconnect.php');
- $obj_db = new db_connection();
- $obj_db->set_dbconnection();
- ?>
- <?php
- $Auth=$_POST['author'];
- $pub=$_POST['publication'];
- $query="INSERT INTO master(author,name_of_publication) VALUES('$Auth','$pub')";
- $res=mysql_query($query);
- if($res)
- echo "success";
- else
- echo "Not successfull";
- ?>
- ................................................................
- dbconnect.php
- <?php
- class db_connection{
- function set_dbconnection()
- {
- //Set db connection
- define('DB_USER','root');
- define('DB_PASSWORD','');
- define('DB_HOST','localhost');
- /*define('DB_USER','rgcepuser');
- define('DB_PASSWORD','Rg#m~18febcep');
- define('DB_HOST','localhost');*/
- //make a connection
- $db_connect=@mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("NOT Connected");
- $dblink=@mysql_select_db('library_management',$db_connect);
- if(!$dblink):
- echo 'ERROR!!!',@mysql_error();
- exit;
- endif;
- }
- }
- ?>
- .............................................................
- DATA BASE
- -- phpMyAdmin SQL Dump
- -- version 2.10.0.2
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Sep 21, 2014 at 04:11 AM
- -- Server version: 5.0.37
- -- PHP Version: 5.2.1
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- --
- -- Database: `library_management`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `author_table`
- --
- CREATE TABLE `author_table` (
- `slno` int(5) NOT NULL auto_increment,
- `author_id` int(6) default NULL,
- `author_name` varchar(50) collate latin1_general_ci NOT NULL,
- UNIQUE KEY `slno` (`slno`),
- UNIQUE KEY `author_id` (`author_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ;
- --
- -- Dumping data for table `author_table`
- --
- INSERT INTO `author_table` VALUES (1, 1, 'Shiv Khera');
- INSERT INTO `author_table` VALUES (2, 2, 'Ramananda');
- INSERT INTO `author_table` VALUES (3, 3, 'Rajib Bhatia');
- INSERT INTO `author_table` VALUES (4, 4, 'Krishna Kant Bhatia');
- INSERT INTO `author_table` VALUES (5, 5, 'Minakumary Pandit');
- INSERT INTO `author_table` VALUES (6, 6, 'Mc Gall');
- INSERT INTO `author_table` VALUES (7, 7, 'Kabira Alam Chaudhury');
- INSERT INTO `author_table` VALUES (8, 8, 'Mina Kumary Bala');
- -- --------------------------------------------------------
- --
- -- Table structure for table `master`
- --
- CREATE TABLE `master` (
- `slno` bigint(10) NOT NULL auto_increment,
- `ISBN` varchar(70) collate latin1_general_ci default NULL,
- `book_name` varchar(70) collate latin1_general_ci default NULL,
- `author` varchar(50) collate latin1_general_ci default NULL,
- `name_of_publication` varchar(60) collate latin1_general_ci default NULL,
- `date` text collate latin1_general_ci,
- `price` decimal(7,2) default NULL,
- UNIQUE KEY `slno` (`slno`,`ISBN`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=21 ;
- --
- -- Dumping data for table `master`
- --
- INSERT INTO `master` VALUES (1, NULL, NULL, '7', '', NULL, NULL);
- INSERT INTO `master` VALUES (2, NULL, NULL, '3', '', NULL, NULL);
- INSERT INTO `master` VALUES (3, NULL, NULL, '7', '', NULL, NULL);
- INSERT INTO `master` VALUES (4, NULL, NULL, '1', '', NULL, NULL);
- INSERT INTO `master` VALUES (5, NULL, NULL, '1', '', NULL, NULL);
- INSERT INTO `master` VALUES (6, NULL, NULL, '1', '', NULL, NULL);
- INSERT INTO `master` VALUES (7, NULL, NULL, '7', '', NULL, NULL);
- INSERT INTO `master` VALUES (8, NULL, NULL, '', '', NULL, NULL);
- INSERT INTO `master` VALUES (9, NULL, NULL, '', '', NULL, NULL);
- INSERT INTO `master` VALUES (10, NULL, NULL, '', '', NULL, NULL);
- INSERT INTO `master` VALUES (11, NULL, NULL, '6', '', NULL, NULL);
- INSERT INTO `master` VALUES (12, NULL, NULL, '6', '', NULL, NULL);
- INSERT INTO `master` VALUES (13, NULL, NULL, '', '', NULL, NULL);
- INSERT INTO `master` VALUES (14, NULL, NULL, '', '', NULL, NULL);
- INSERT INTO `master` VALUES (15, NULL, NULL, '4', '', NULL, NULL);
- INSERT INTO `master` VALUES (16, NULL, NULL, '4', '1', NULL, NULL);
- INSERT INTO `master` VALUES (17, NULL, NULL, '', '', NULL, NULL);
- INSERT INTO `master` VALUES (18, NULL, NULL, '', '', NULL, NULL);
- INSERT INTO `master` VALUES (19, NULL, NULL, '4', '2', NULL, NULL);
- INSERT INTO `master` VALUES (20, NULL, NULL, '4', '2', NULL, NULL);
- -- --------------------------------------------------------
- --
- -- Table structure for table `publication`
- --
- CREATE TABLE `publication` (
- `slno` int(8) NOT NULL auto_increment,
- `publication_id` int(6) default NULL,
- `publicationName` varchar(60) collate latin1_general_ci NOT NULL,
- UNIQUE KEY `slno` (`slno`),
- UNIQUE KEY `publication_id` (`publication_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
- --
- -- Dumping data for table `publication`
- --
- INSERT INTO `publication` VALUES (1, 1, 'BPB PUBLICATION');
- INSERT INTO `publication` VALUES (2, 2, 'ASSAM TRIVAL PUBLICATION');