001.$brand=null;
002.
003.###################Insert Section###############
004.if(isset($_POST['b']['insert'])){
005. $b = $_POST['b'];
006. $sqli = "INSERT INTO brand(brand)
007. VALUE('".$b['brand']."')";
008. $rsi = $conn->query($sqli);
009. if($rsi){
010. $_SESSION['flash']['type']='success';
011. $_SESSION['flash']['msg']='เพิ่มข้อมูลเรียบร้อย';
012. }else{
013. $_SESSION['flash']['type']='danger';
014. $_SESSION['flash']['msg']='ไม่สามารถเพิ่มข้อมูลได้';
015. }
016.
017.}
018.
019.###################Edit Section#################
020.if(isset($_GET['eid'])){
021. $bid = $_GET['eid'];
022.
023. $sqle = "SELECT * FROM brand WHERE id='".$bid."'";
024. $resulte = $conn->query($sqle);
025. $rse = mysqli_fetch_array($resulte);
026.
027. $brand = $rse['brand'];
028.
029.}
030.
031.if(isset($_POST['b']['edit'])){
032. $b = $_POST['b'];
033. $sqlu = "UPDATE brand SET
034. brand='".$b['brand']."'
035.
036. WHERE id='".$b['id']."'";
037. $rsu = $conn->query($sqlu);
038. if($rsu){
039. $_SESSION['flash']['type']='success';
040. $_SESSION['flash']['msg']='แก้ไขข้อมูลเรียบร้อย';
041. }else{
042. $_SESSION['flash']['type']='danger';
043. $_SESSION['flash']['msg']='ไม่สามารถแก้ไขข้อมูลได้';
044. }
045.}
046.
047.###################Delete Section###############
048.if(isset($_GET['did'])){
049. $sqld = "DELETE FROM brand WHERE id='".$_GET['did']."'";
050. $rsd = $conn->query($sqld);
051. if($rsd){
052. $_SESSION['flash']['type']='success';
053. $_SESSION['flash']['msg']='ลบข้อมูลเรียบร้อยแล้ว';
054. }else{
055. $_SESSION['flash']['type']='danger';
056. $_SESSION['flash']['msg']='ไม่สามารถลบข้อมูลได้';
057. }
058.}
059.
060.###################Select Data Section###############
061.$sql = "SELECT * FROM brand ORDER BY id DESC";
062.$result = $conn->query($sql);
063.?>
064.
065.<!-- ###############Flash Message############# -->
066.<?php if(isset($_SESSION['flash'])){ ?>
067.<div class="alert alert-<?php echo $_SESSION['flash']['type'];?>">
068. <?php echo ucfirst($_SESSION['flash']['type']).' '.$_SESSION['flash']['msg'];?>
069.</div>
070.<?php }?>
071.<!--################Insert form############## -->
072.<div class="row">
073.<div class="col-md-12">
074.<h3>ยี่ห้อสินค้า</h3>
075.<form method="post" action="<?php echo $_SERVER['PHP_SELF'];?>" class="form-horizontal">
076.<?php if(isset($_GET['eid'])){?>
077. <input type="hidden" name="b[edit]" value="1">
078. <input type="hidden" name="b[id]" value="<?php echo $bid;?>">
079.<?php }else{?>
080. <input type="hidden" name="b[insert]" value="1">
081.<?php }?>
082. <div class="form-group">
083. <label class="control-label col-md-2" for="b-brand">ยี่ห้อ</label>
084. <div class="col-md-10">
085. <input id="b-brand" class="form-control" type="text" name="b[brand]" value="<?php echo $brand;?>" required="required">
086. </div>
087.
088. </div>
089. <input type="submit" value="บันทึกข้อมูล ยี่ห้อสินค้า" class="btn btn-primary">
090. <?php if(isset($_GET['eid'])){
091. <a href="admin_brand.php" class="btn btn-warning">ยกเลิก</a>
092. <?php }?>
093.
094.</form>
095.</div>
096.
097.<hr />
098.<div class="col-md-12">
099.<!-- ###############List of Data############# -->
100.<h3>รายการยี่ห้อสินค้า</h3>
101.<table class="table table-bordered table-hover">
102. <tr>
103. <th>ยี่ห้อ</th>
104.
105. <th></th>
106. </tr>
107. <?php while($rs=mysqli_fetch_array($result)){?>
108. <tr>
109. <td><?php echo $rs['brand'];?></td>
110.
111. <td>
112. <a href="<?php echo $_SERVER['PHP_SELF'];?>?eid=<?php echo $rs['id'];?>" class="btn btn-sm btn-warning">แก้ไข</a>
113. <a href="<?php echo $_SERVER['PHP_SELF'];?>?did=<?php echo $rs['id'];?>" class="btn btn-sm btn-danger" onclick="return confirm('แน่ใจนะว่าต้องการลบ?');">ลบ</a>
114. </td>
115. </tr>
116. <?php }?>
117.</table>
118.</div>
119.</div><!--row-->
Load balance : Server 01
