· 5 years ago · Jul 17, 2020, 06:24 AM
1<!DOCTYPE html>
2<html>
3<head>
4 <title>
5
6 </title>
7</head>
8<body>
9 <?php
10
11 function isNumber($value)
12 {
13 for ($i=0; $i <strlen($value) ; $i++) {
14 if($value[$i]>='0' && $value[$i]<='9')
15 continue;
16 else
17 return FALSE;
18 }
19 return TRUE;
20 }
21
22 $server = "localhost";
23 $user = "root";
24 $pass = "";
25 $connect = new mysqli($server,$user,$pass);
26 if($connect->connect_error)
27 {
28 die("Connection Error\n");
29 }
30 else
31 {
32 $name = $_POST["name"];
33 $amount = $_POST["amount"];
34 $Cost = $_POST["cost"];
35 if(!isNumber($amount) || !isNumber($cost) || empty($name))
36 {
37 echo "isNumber($amount)";
38 echo "isNumber($cost)";
39 echo "$cost";
40 echo nl2br("Enter valid data\n");
41 }
42 else
43 {
44 $sqlCommand = 'CREATE DATABASE IF NOT EXISTS Product';
45 $connect->query($sqlCommand);
46 $checkTable = "SELECT 1 FROM PRODUCT LIMIT 1";
47 if($checkTable!=False)
48 {
49 $sql = 'INSERT INTO Product VALUES($name,$Cost,$amount)";
50 $connect->query($sql)';
51 }
52 else
53 {
54 $sql = 'CREATE TABLE Product(Product_Name varchar(30),cost DECIMAL(12),amount DECIMAL(12))';
55 $connect->query($sql);
56 $sql = 'INSERT INTO Product VALUES($name,$cost,$amount)';
57 $connect->query($sql);
58 //$sql =
59 }
60 echo nl2br("Data added Successfull\n");
61 }
62 }
63 ?>
64 <a href="product.html">BaCK TO PREVIOUS PAGE </a>
65</body>
66</html>