BootstrapModifySystem/add_version.php at master · s1042992/BootstrapModifySystem · GitHub

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
<?php
	session_start();
	include("mysql_connect.inc.php");//連接資料庫

	$user=$_SESSION["user_name"];
	$get_name=htmlspecialchars($_POST["version_name"]);
	$p=$_SESSION["project_name"];
	$var_carousel=file_get_contents('lesscode/carousel.less');
	$var_carousel=htmlspecialchars($var_carousel,ENT_QUOTES);
	$var_carousel=html_entity_decode($var_carousel);

	$var_alert=file_get_contents('lesscode/alert.less');
	$var_alert=htmlspecialchars($var_alert,ENT_QUOTES);
	$var_alert=html_entity_decode($var_alert);

	$var_navbar=file_get_contents('lesscode/navbar.less');
	$var_navbar=htmlspecialchars($var_navbar,ENT_QUOTES);
	$var_navbar=html_entity_decode($var_navbar);

	$var_dropdowns=file_get_contents('lesscode/dropdowns.less');
	$var_dropdowns=htmlspecialchars($var_dropdowns,ENT_QUOTES);
	$var_dropdowns=html_entity_decode($var_dropdowns);

	$var_tables=file_get_contents('lesscode/tables.less');
	$var_tables=htmlspecialchars($var_tables,ENT_QUOTES);
	$var_tables=html_entity_decode($var_tables);


	$sql = "INSERT INTO `less_list`(`person_name`,`project_name`,`version_name`,`less_carousel`,`less_alerts`,`less_navbar`,`less_dropdowns`,`less_tables`) VALUES ('$user','$p','$get_name','$var_carousel','$var_alert','$var_navbar','$var_dropdowns','$var_tables')";
	if (mysqli_query($db, $sql))
	{
		echo "<br> New record created successfully";
	}
	else
	{
		echo "Error: " . $sql . "<br>" . mysqli_error($db);
	}

	$sql3="SELECT * FROM less_list ORDER BY less_id DESC LIMIT 1";

	$result=mysqli_query($db,$sql3);

	$row = mysqli_fetch_assoc($result);
	$id=$row['less_id'];
	echo $id;
	$sql2 = "INSERT INTO css_list (css_id,person_name,project_name,version_name) VALUES('$id','$row[person_name]','$row[project_name]','$row[version_name]')";

	if (mysqli_query($db, $sql2))
	{
		echo "<br> New record created successfully";
	}
	else
	{
		echo "Error: " . $sql2 . "<br>" . mysqli_error($db);
	}
	mysqli_close($db);


	//mysqli_query($db,$sql)or die ("無法更新".mysql_error()); //執行sql語法
	header("location:modify.php");
?>