Guest User

function

a guest
Nov 16th, 2018
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.98 KB | None | 0 0
  1. <?php
  2.  
  3. $dbhost = 'localhost';
  4. $dbuser = 'root';
  5. $dbpass = '';
  6. $dbname = 'uclass';
  7.  
  8. // Create database connection
  9. $con =  mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
  10.  
  11.  
  12.  
  13. function query($query) {
  14.  
  15. global $con;
  16.  
  17. $result = mysqli_query($con, $query);
  18.  
  19. $rows = [];
  20.  
  21. while($row = mysqli_fetch_assoc($result)) {
  22.  
  23.  
  24. $rows [] = $row;
  25.  
  26. }
  27.  
  28. return $rows;
  29.  
  30. }
  31.  
  32.  
  33. function update($update) {
  34.  
  35.     global $con;
  36.  
  37.     $kelasId = $update['kelasId'];
  38.     $npm_siswa = $update['npm_siswa'];
  39.     $nama_siswa = $update['nama_siswa'];
  40.     $bidangst_siswa = $update['bidangst_siswa'];
  41.     $ipk_siswa = $update['ipk_siswa'];
  42.    
  43.  
  44.     $query = "UPDATE class SET
  45.                
  46.                npm_siswa = '$npm_siswa',
  47.                nama_siswa = '$nama_siswa',
  48.                bidangst_siswa = '$bidangst_siswa',
  49.                ipk_siswa = '$ipk_siswa'
  50.                WHERE kelasId = $kelasId ";
  51.  
  52.                  $result = mysqli_query($con, $query);
  53.  
  54.  
  55.  
  56. }
  57.  
  58.  
  59. ?>
Add Comment
Please, Sign In to add comment