1.
$objConnect
= mysql_connect(
"localhost"
,
"root"
,
"root"
)
or
die
(
"Error Connect to Database"
);
2.
$objDB
= mysql_select_db(
"mydatabase"
);
3.
$strSQL
=
"INSERT INTO customer "
;
4.
$strSQL
.=
"(CustomerID,Name,Email,CountryCode,Budget,Used) "
;
5.
$strSQL
.=
"VALUES "
;
6.
$strSQL
.=
"('"
.
$_POST
[
"txtCustomerID"
].
"','"
.
$_POST
[
"txtName"
].
"','"
.
$_POST
[
"txtEmail"
].
"' "
;
7.
$strSQL
.=
",'"
.
$_POST
[
"txtCountryCode"
].
"','"
.
$_POST
[
"txtBudget"
].
"','"
.
$_POST
[
"txtUsed"
].
"') "
;
8.
$objQuery
= mysql_query(
$strSQL
);