Insert Data in Database through pdo in php..

try {
 $db = new PDO('mysql:host=localhost;dbname=idegraphics', 'root', '');
 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

}catch(PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
}

$radio=$_POST["radio1"];
$descr=$_POST["descr"];
$yrreg=$_POST["select"];
$carmodel=$_POST["mot"];
$fuel=$_POST["fuel"];
$variant=$_POST["variant"];

try {
    $stmt = $db->prepare("insert into motorscustomer(cardetails,registartiondetails,yearofregistation,cardetailsname,fueltype,variantype)
values(?,?,?,?,?,?)");
    $stmt->execute(array($radio,$descr,$yrreg,$carmodel,$fuel,$variant));
$last_id = $db->lastInsertId();
  //  echo "New record created successfully. Last inserted ID is: " . $last_id;
}catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();

}

Popular posts from this blog

Item State change of JComboBox and Get values from database and show Data on JTable.

 try     {     Class.forName("com.mysql.jdbc.Driver");     java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/supplimentry","root","root");     String sql="select * from inventory where Brand_Name='"+jComboBox3.getSelectedItem().toString()+"'";     java.sql.PreparedStatement pst=con.prepareStatement(sql);     DefaultTableModel tm33 = (DefaultTableModel)list1.getModel();     tm33.setRowCount(0);  TableColumn col = new TableColumn(tm33.getColumnCount());  JTableHeader header = list1.getTableHeader();   header.setBackground(Color.yellow);        ResultSet rs = pst.executeQuery(sql);     int i=0;     while(rs.next())     {     Vector v2 = new Vector();     v2.addElement(rs.getString(1));     v2.addEle...
Read more

Jtable with database manually in netbeans.

package Demo; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.Vector; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import net.proteanit.sql.DbUtils; /**  *  * @author NAVJYOTI  */ public class Jtablee extends javax.swing.JFrame {     /**      * Creates new form Jtablee      */     public Jtablee() {         initComponents();         set();     }     private int getsize() { int count=0; try {Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root"); Statement stmt=con.createStatement(); String query="select * from group1"; ResultSet rs= ...
Read more