Merhaba arkadaşlar çok basit bir veri girişi post edip mysql de ve aynısının pdo'da kaydını yaptığı bir sayfayı mysqli'ye çevirme konusunda yardımcı olabilecek bir arkadaş varsa bu konu hakkında bilgilendirme yaparsa memnun olurum.

Örnek olarak Mysql hali

add.html
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>

<BODY>
<form name="frm" method="post" action="add.php">
Plate: <input type="text" name="pl" maxlength="6" size="8"><br/>
Make:  <input type="text" name="mk" maxlength="20" size="24"><br/>
Model: <input type="text" name="md" maxlength="10" size="12"><br/>
<input type="submit" value="Save">
</form>
</BODY>
</HTML>
add.php
<?php
extract($_POST);
//$pl=$_POST['pl'];
//$mk=$_POST['mk'];
//$md=$_POST['md'];

if (strlen(trim($pl))==0)
 die("Plate can not be blank");


//1. connect
$cnn=mysql_connect("localhost","caruser","driver") or die('Connection failed');

//2. choose db
mysql_select_db("autos",$cnn) or die('Db Failed');

//3. prepare & run query
$q="insert into cars(plate,make,model) values('$pl','$mk','$md')";

$r=mysql_query($q,$cnn) or die('Query failed. '.mysql_error());

if (mysql_affected_rows($cnn)>0)
 echo "Record Saved";
else
 echo "Something else happened";

//5. close connection
 mysql_close($cnn);
?>
Sql
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 05, 2012 at 02:00 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `autos`
--

CREATE DATABASE `autos` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `autos`;

CREATE USER 'caruser'@'localhost' IDENTIFIED BY 'driver';
GRANT SELECT , INSERT , UPDATE , DELETE ON `autos` . * TO 'caruser'@'localhost';






-- --------------------------------------------------------

--
-- Table structure for table `cars`
--

DROP TABLE IF EXISTS `cars`;
CREATE TABLE IF NOT EXISTS `cars` (
  `plate` char(6) NOT NULL,
  `make` varchar(20) NOT NULL,
  `model` varchar(10) NOT NULL,
  PRIMARY KEY (`plate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cars`
--

INSERT INTO `cars` (`plate`, `make`, `model`) VALUES
('U782', 'TOFAS', 'HACI MURAT'),
('2', 'Toyota', 'Camry'),
('21', 'Q', 'W');