-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsert_pro.php
142 lines (135 loc) · 4.49 KB
/
insert_pro.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
<html>
<h2 style="align:centre"> Product Details</h2>
<body style="margin-top:100px; margin-left:500px;">
<link rel="stylesheet" href="input.css">
<form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>" enctype=multipart/form-data>
Product Id:<input type=text name=pro_id class="input" placeholder="Product id" style="margin-left:30px"><br>
Product Name:<input type=text name=pro_name class="input" placeholder="Product name"><br>
Company ID:<input type=text name=comp_id class="input" placeholder="Company Id" style="margin-left:14px"><br>
Product Price:<input type=text name=pro_price class="input" placeholder="Product Price" style="margin-left:5px"><br>
Product Type:<input type=text name=pro_type class="input" placeholder="Product type" style="margin-left:9px"><br>
Available size:<input type=checkbox name="a_size[]" value="S" style="margin-left:9px">S
<input type=checkbox name="a_size[]" value="M">M
<input type=checkbox name="a_size[]" value="L">L
<input type=checkbox name="a_size[]" value="XL">XL
<input type=checkbox name="a_size[]" value="XXL">XXL<br>
Available color:<input type=text name=a_color class="input" placeholder="Available color"><br>
Select image:<input type=file name="img1" style="margin-left:10px"><br>
<input type=submit value=Submit name=click class="submitbtn" style='width40%; margin-left:50px; margin-top:10px'>
</form>
</html>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST")
{
if(isset($_POST['pro_id']))
{
$pro_id=$_POST['pro_id'];
if(isset($_POST['pro_name']))
{
$pro_name=$_POST['pro_name'];
if(isset($_POST['comp_id']))
{
$comp_id=$_POST['comp_id'];
if(isset($_POST['pro_price']))
{
$pro_price=$_POST['pro_price'];
if(isset($_POST['pro_type']))
{
$pro_type=$_POST['pro_type'];
if(isset($_POST['a_color']))
{
$a_color=$_POST['a_color'];
if(!empty($_POST['a_size']))
{
$a_size=implode(',',$_POST['a_size']);
if(!empty($_FILES['img1']['name']))
{
$con=mysql_connect("localhost","root","");
mysql_select_db("poshakh",$con);
$table_name=$_SESSION['table_name'];
$name = $_FILES['img1']['name'];
$target_dir = "upload/";
$target_file = $target_dir.basename($_FILES['img1']['name']);
// Select file type
$imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));
// Valid file extensions
$extensions_arr = array("jpg","jpeg","png","jfif");
// Check extension
if( in_array($imageFileType,$extensions_arr) )
{
if(isset($_POST['click']))
{
$result = mysql_query("insert into $table_name values($pro_id,'$pro_name',$comp_id,$pro_price,'$pro_type','$a_size','$name','$a_color',default,15)",$con);
// Upload file
move_uploaded_file($_FILES['img1']['tmp_name'],$target_dir.$name);
if($result)
{
header("location:show_table.php");
mysql_close($con);
}
else
{
echo "<script type='text/javascript'>";
echo "alert('qury does not work properly.')";
echo "</script>";
}
}
}
else
{
echo "<script type='text/javascript'>";
echo "alert('Select image with .jpg or .jpeg or .png extension')";
echo "</script>";
}
}
else
{
echo "<script type='text/javascript'>";
echo "alert('Upload image')";
echo "</script>";
}
}
else
{
echo "<script type='text/javascript'>";
echo "alert('Enter size of cloth')";
echo "</script>";
}
}
else
{
echo "<script type='text/javascript'>";
echo "alert('Select Color')";
echo "</script>";
}
}
else
{
echo "<script type='text/javascript'>";
echo "alert('Enter Cloth type')";
echo "</script>";
}
}
else
{
echo "<script type='text/javascript'>";
echo "alert('Enter Cloth price')";
echo "</script>";
}
}
else
{
echo "<script type='text/javascript'>";
echo "alert('Enter compact id')";
echo "</script>";
}
}
else
{
echo "<script type='text/javascript'>";
echo "alert('Enter cloth name')";
echo "</script>";
}
}
}
?>