· 5 years ago · Jul 17, 2020, 05:52 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 }
58 echo nl2br("Data added Successfull\n");
59 }
60 }
61 ?>
62 <a href="product.html">BaCK TO PREVIOUS PAGE </a>
63</body>
64</html>