comparison: www/includes/db_profile_styles.php
www/includes/db_profile_styles.php
- changeset 48
- bdd1ec9b9c06
- parent 45
- 95251bedfab4
- child 77
- a9f8de2d7b2b
equal
deleted
inserted
replaced
| 47:94cd5ac04b6a | 48:bdd1ec9b9c06 |
|---|---|
| 8 if (! $connect) { | 8 if (! $connect) { |
| 9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | 9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
| 10 } | 10 } |
| 11 | 11 |
| 12 // get data and store in a json array | 12 // get data and store in a json array |
| 13 $query = "SELECT * FROM profile_styles ORDER BY name"; | 13 $query = "SELECT * FROM profile_styles ORDER BY style_guide,style_letter,name"; |
| 14 if (isset($_GET['insert'])) { | 14 if (isset($_GET['insert'])) { |
| 15 // INSERT COMMAND | 15 // INSERT COMMAND |
| 16 $sql = "INSERT INTO `profile_styles` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | 16 $sql = "INSERT INTO `profile_styles` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
| 17 $sql .= "', category='" . mysqli_real_escape_string($connect, $_GET['category']); | 17 $sql .= "', category='" . mysqli_real_escape_string($connect, $_GET['category']); |
| 18 $sql .= "', category_number='" . $_GET['category_number']; | 18 $sql .= "', category_number='" . $_GET['category_number']; |
