Exemple #1
0
             $results = DB\select_db("delete from events where volid=:volid", $binding, $conn);
             if ($results) {
                 $msgdelete = "Volunteer deleted ";
             }
         } catch (Exception $e) {
             $msgdelete = 'some Server error encountered..';
         }
     }
 }
 if (strcmp($_REQUEST['opt'], "edit") == 0) {
     //echo "uanme".$_POST['uid'];
     $conn = DB\connect_db($config);
     if ($conn) {
         $binding = array('volid' => $_POST['eid']);
         try {
             $resultedit = DB\query_db("select * from volunteers where volid=:volid", $binding, $conn);
             if ($resultedit) {
                 echo "";
             }
         } catch (Exception $e) {
             $msgedit = 'some Server error encountered..';
         }
     }
 }
 if (strcmp($_REQUEST['opt'], "addu") == 0) {
     $conn = DB\connect_db($config);
     if ($conn) {
         $binding = array('volname' => $_POST['addname'], 'email' => $_POST['addemail'], 'mobile' => $_POST['addmobile'], 'branch' => $_POST['addbranch'], 'year' => $_POST['addyear']);
         try {
             $results = DB\insert_db("insert into volunteers(name,email,year,branch,mobile) \t\t\t\t\tvalues(:volname,:email,:year,:branch,:mobile)", $binding, $conn);
             if ($results) {
Exemple #2
0
             $results = DB\select_db("delete from events where eid=:eid", $binding, $conn);
             if ($results) {
                 $msgdelete = "Event deleted ";
             }
         } catch (Exception $e) {
             $msgdelete = 'some Server error encountered..';
         }
     }
 }
 if (strcmp($_REQUEST['opt'], "edit") == 0) {
     //echo "uanme".$_POST['uid'];
     $conn = DB\connect_db($config);
     if ($conn) {
         $binding = array('eid' => $_POST['eid']);
         try {
             $resultedit = DB\query_db("select * from events where eid=:eid", $binding, $conn);
             if ($resultedit) {
                 echo "";
             }
         } catch (Exception $e) {
             $msgedit = 'some Server error encountered..';
         }
     }
 }
 if (strcmp($_REQUEST['opt'], "addu") == 0) {
     $conn = DB\connect_db($config);
     if ($conn) {
         $binding = array('name' => $_POST['eventname'], 'edate' => $_POST['eventdate'], 'efee' => $_POST['entryfee'], 'expentries' => $_POST['expentry']);
         try {
             $results = DB\insert_db("insert into events(name,edate,efee,expentries) \t\t\t\t\tvalues(:name,:edate,:efee,:expentries)", $binding, $conn);
             if ($results) {
Exemple #3
0
             $results = DB\select_db("delete from system_users where username=:uname", $binding, $conn);
             if ($results) {
                 $msgdel = "user deleted successfully...";
             }
         } catch (Exception $e) {
             $msgdel = 'some Server error encountered..';
         }
     }
 }
 if (strcmp($_REQUEST['opt'], "edit") == 0) {
     //echo "uanme".$_POST['uid'];
     $conn = DB\connect_db($config);
     if ($conn) {
         $binding = array('uname' => $_POST['uid']);
         try {
             $resultedit = DB\query_db("select * from system_users where username=:uname", $binding, $conn);
             if ($resultedit) {
                 echo "";
             }
         } catch (Exception $e) {
             echo 'some Server error encountered..';
         }
     }
 }
 if (strcmp($_REQUEST['opt'], "addu") == 0) {
     if (strcmp($_POST['password'], $_POST['conpassword'] == 0)) {
         $conn = DB\connect_db($config);
         if ($conn) {
             $binding = array('name' => $_POST['name'], 'email' => $_POST['email'], 'uname' => $_POST['uname'], 'password' => $_POST['password'], 'role' => $_POST['role']);
             try {
                 $results = DB\insert_db("insert into system_users(name,email,role,password,username) \t\t\t\t\tvalues(:name,:email,:role,:password,:uname)", $binding, $conn);
?>
<div class="ui-widget-header" id="menubar" >
    <div style="font-size: 32px; left: 25px;top:10px; font-family: 'CHE LIVES!', Starcraft;position:absolute;">COLOSSEUM
    
    <div style="font-size:15px;font-family:'Courier New', Courier, monospace;">Management System</div>
    </div>
    <p style="position:absolute;top:30px;left:49%">
   <a href="../general/home.php"> <span class="ui-icon  ui-icon-home" style="background-image: url(../style/images/ui-icons_222222_256x240.png);-webkit-transform: scale(1.5);" ></a>
   </p>
   
    </div>
    <?php 
$imagepath = "";
$conn = DB\connect_db($config);
if ($conn) {
    $results = DB\query_db("select * from system_users where username=:id", array('id' => $_SESSION['username']), $conn);
    if ($results) {
        if (strcmp($results->pro_pic, "") == 0) {
            $imagepath = "../users/images/defaultuser.jpg";
        } else {
            $imagepath = "../users/" . $_SESSION['username'] . "/" . $results->pro_pic;
        }
    }
}
?>
    <div id="pane" >
     <!--<img id="pane" src="users/<?php 
//echo $_SESSION['username']."/";echo $pic;
?>
" width="10px" height="100%" >
     -->
Exemple #5
0
<?php

session_start();
require_once '../settings/dbfunctions.php';
use Web\DB;
$username = $_POST['uname'];
$password = $_POST['passwd'];
$conn = DB\connect_db($config);
if ($conn) {
    $binding = array('id' => $username);
    $results = DB\query_db("select * from system_users where username=:id", $binding, $conn);
    if ($results) {
        if (strcmp($results->password, $password) == 0) {
            $_SESSION['username'] = $username;
            if (strcmp($results->role, "normal") == 0) {
                header("location:../general/home.php");
            }
            if (strcmp($results->role, "admin") == 0) {
                header("location:../main/home.php");
            }
        } else {
            session_destroy();
            header('location:../index.php?type=inpass');
        }
    } else {
        session_destroy();
        header('location:../index.php?type=inuser');
    }
} else {
    echo "Connection lost";
    die;