ManageDatabase PHP Code Examples

Example #1

0

Show file

File: deleteData.php Project: betoreyes/CRUD-Management-System---Tutorial---

<?php

if (isset($_GET['delete'])) {
    include_once 'core/class.ManageDatabase.php';
    $init = new ManageDatabase();
    $id = $_GET['id'];
    $delete = $init->deleteData($session_table_name, $id);
    if ($delete == 1) {
        $success = 'Data deleted successfully';
    } else {
        $error = 'There was a slight problem';
    }
}

Example #2

0

Show file

File: delete.php Project: habibzadeh/php-mailadmin

$cfgProgDir = '../security/';
include $cfgProgDir . "secure.php";
include 'ManageDatabase.php';
require 'EntryCheck.php';
$TITLE = 'Delete Email Account.';
include_once INC_PATH . 'header.php';
if (isset($_SERVER['REQUEST_METHOD'])) {
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $email = $_POST['email'];
        $checks = new EntryCheck();
        if (!$checks->CheckEmail($email)) {
            ?>
            <script>ShowAlert('#FormAlert');</script>
        <?php 
        } else {
            if ($conn = new ManageDatabase()) {
                if (($record_id = $conn->CheckForEmailRecord($email)) > 0) {
                    ?>
                    <script>
                        if(confirm("Are you sure ?")){
                            <?php 
                    if ($conn->DeleteEmail($record_id)) {
                        ?>
                                    ShowAlert('#FormInfo');
                                <?php 
                    } else {
                        ?>
                                    ShowAlert('#DatabaseError');
                                <?php 
                    }
                    ?>

Example #3

0

Show file

File: listTables.php Project: betoreyes/CRUD-Management-System---Tutorial---

<?php

include_once 'core/class.ManageDatabase.php';
include_once 'session.php';
$tables_init = new ManageDatabase();
$listed_tables = $tables_init->listTables();
foreach ($listed_tables as $key => $value) {
    $given_tables[] = $value['Tables_in_' . DB_NAME];
}
$selected_table = array($session_table_name);
$tables_left = array_diff($given_tables, $selected_table);

Example #4

0

Show file

File: insertData.php Project: quinnd6/php

<?php

if (isset($_POST['insert_values'])) {
    $param = $_POST;
    include_once 'core/class.ManageDatabase.php';
    $init = new ManageDatabase();
    foreach ($param as $key => $value) {
        if ($key !== 'insert_values') {
            $fields_name[] = $key;
            $field_value[] = $value;
            echo $key;
        }
    }
    $field_count = count($fields_name);
    $fields_name = implode(',', $fields_name);
    for ($x = 1; $x <= $field_count; $x++) {
        $total_counts[] = '?';
    }
    $bind_params = implode(',', $total_counts);
    $insert = $init->insertData($session_table_name, $fields_name, $bind_params, $field_value);
    if ($insert == 1) {
        $success = 'New value added';
    } else {
        $error = 'There was a slight problem';
    }
}

Example #5

0

Show file

File: games.php Project: quinnd6/php

<?php

include_once 'core/class.ManageDatabase.php';
$init = new ManageDatabase();
$data = $init->getGames("games");
?>

<div id="content">
    <div id ="searchbar">
        <form action="searchresults.php" method="get">
        <input type="text" name="gameSearchName">
        <input type="submit" value="search">
        </form> 
    </div>
<div id="page_title"><h2> Games </h2></div>


 
					<?php 
/* if($data !==0) 
   {
       foreach($fields_name as $f)
       {
          
           //echo '<th>'.$f.'</th>';
           
       }
       
   }
   * 
   */

Example #6

0

Show file

File: new.php Project: habibzadeh/php-mailadmin

include 'ManageDatabase.php';
require 'EntryCheck.php';
$TITLE = 'New Email Account';
include_once INC_PATH . 'header.php';
if (isset($_SERVER['REQUEST_METHOD'])) {
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $email = $_POST['email'];
        $password = $_POST['password'];
        $re_password = $_POST['re_password'];
        $checks = new EntryCheck();
        if (!$checks->CheckEmail($email) || !$checks->CheckForSamePassword($password, $re_password)) {
            ?>
            <script>ShowAlert('#FormAlert');</script>
            <?php 
        } else {
            if ($conn = new ManageDatabase()) {
                if ($conn->InsertToDatabase($email, $password)) {
                    ?>
                    <script>ShowAlert('#FormInfo');</script>
                <?php 
                } else {
                    ?>
                    <script>ShowAlert('#DatabaseError');</script>
                <?php 
                }
                $conn->Close();
                unset($conn);
            }
        }
    }
}

Example #7

0

Show file

File: searchresults.php Project: quinnd6/php

<?php

//Script Error Reporting
error_reporting(E_ALL);
ini_set('display_errors', 1);
include_once 'core/class.ManageDatabase.php';
$init = new ManageDatabase();
$gameName = $_GET['gameSearchName'];
$table_name = 'products';
$data = $init->searchItems($table_name, $gameName);
?>

<?php 
include_once 'views/header.php';
?>
 <div id="horizontalnav">
                <div class="navlinks">
                    <ul>
                        <li><a href="games">Games</a></li>
                        <li><a href="consoles">Consoles</a></li>
                        <li><a href="accessories">Accessories</a></li>
                        <li><a href="other">Other</a></li>
                        <li><a href="contactus">Contact Us</a></li>
                    </ul>
                </div>
 </div>

<div id="content">
    <div id ="searchbar">
<form action="searchresults.php" method="get">
<input type="text" name="gameSearchName">

Example #8

0

Show file

File: editdata.php Project: quinnd6/php

<?php

if (isset($_POST['edit_values'])) {
    include_once 'session.php';
    $param = $_POST;
    include_once 'class.ManageDatabase.php';
    $init = new ManageDatabase();
    $id = $_GET['id'];
    $edit_values = $init->editData($session_table_name, $param, $id);
    header("location: edit.php?id=" . $id . "");
}

Example #9

0

Show file

File: getGame.php Project: quinnd6/php

<?php

include_once 'core/class.ManageDatabase.php';
$init = new ManageDatabase();
if (isset($_GET['id'])) {
    $id = $_GET['id'];
    $table_fields = $init->listFields($session_table_name);
    $data = $init->getData($session_table_name, $id);
} else {
    $data = $init->getData($session_table_name);
    if ($data !== 0) {
        foreach ($data[0] as $key => $value) {
            $fields_name[] = $key;
        }
    }
}

Example #10

0

Show file

File: listFields.php Project: betoreyes/CRUD-Management-System---Tutorial---

<?php

include_once 'core/class.ManageDatabase.php';
$init = new ManageDatabase();
$table_fields = $init->listFields($session_table_name);

Example #11

0

Show file

File: consoles.php Project: quinnd6/php

<?php

include_once 'views/header.php';
include_once 'core/class.ManageDatabase.php';
$init = new ManageDatabase();
$data = $init->getConsoles("consoles");
?>
<div id="content">
     <div id ="searchbar">
        <form action="searchresults.php" method="get">
        <input type="text" name="gameSearchName">
        <input type="submit" value="search">
        </form> 
    </div>
<div id="page_title"><h2>Consoles</h2></div>
 <?php 
if ($data !== 0) {
    echo '<div id ="boxed_item">';
    $init->printData($data, 'consoles');
    echo '</div>';
} else {
    echo '<div id ="boxed_item">There are no consoles available</div>';
}
?>
</div>

Example #12

0

Show file

File: accessories.php Project: quinnd6/php

<?php 
include_once 'views/header.php';
include_once 'core/class.ManageDatabase.php';
$init = new ManageDatabase();
//  $table_name = "games";
$data = $init->getAccessories("accessories");
?>
 
<div id="content">
     <div id ="searchbar">
        <form action="searchresults.php" method="get">
        <input type="text" name="gameSearchName">
        <input type="submit" value="search">
        </form> 
    </div>
    <div id="page_title"><h2>Accessories</h2></div>
   
    <?php 
if ($data !== 0) {
    echo '<div id ="boxed_item">';
    $init->printData($data, 'accessories');
    echo '</div>';
} else {
    echo '<div id ="boxed_item">';
    echo 'There are no accessories available';
    echo '</div>';
}
?>

Example #13

0

Show file

File: password.php Project: habibzadeh/php-mailadmin

include 'ManageDatabase.php';
require 'EntryCheck.php';
$TITLE = 'Change Password';
include_once INC_PATH . 'header.php';
if (isset($_SERVER['REQUEST_METHOD'])) {
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $email = $_POST['email'];
        $password = $_POST['password'];
        $re_password = $_POST['re_password'];
        $checks = new EntryCheck();
        if (!$checks->CheckEmail($email) || !$checks->CheckForSamePassword($password, $re_password)) {
            ?>
            <script>ShowAlert('#FormAlert');</script>
        <?php 
        } else {
            if ($conn = new ManageDatabase()) {
                $record_id = $conn->CheckForEmailRecord($email);
                if ($record_id > 0) {
                    if ($conn->UpdateEmail($record_id, $password)) {
                        ?>
                        <script>ShowAlert('#FormInfo');</script>
                    <?php 
                    } else {
                        ?>
                        <script>ShowAlert('#UnSuccess');</script>
                    <?php 
                    }
                } else {
                    ?>
                    <script>ShowAlert('#NotFound');</script>
                <?php

Example #14

0

Show file

File: list.php Project: habibzadeh/php-mailadmin

include_once INC_PATH . 'header.php';
?>
<div class="container">
    <div class="row">
        <div class="col-md-12">
            <div id="AccountList">
                <table class="EmailList">
                    <thead>
                        <tr>
                            <td>Id</td>
                            <td>Email</td>
                        </tr>
                    </thead>
                    <tbody>
                        <?php 
if ($conn = new ManageDatabase()) {
    $query_result = $conn->MySql->query($conn->GetQueryString('emails'));
    if ($query_result) {
        while ($row = $query_result->fetch_row()) {
            echo '<tr>';
            echo '<td>' . $row[0] . '</td>';
            echo '<td>' . $row[1] . '</td>';
            echo '</tr>';
        }
        $query_result->close();
    }
    $conn->Close();
    unset($conn);
} else {
    echo '<tr>';
    echo '<td>' . 'Database Error!' . '</td>';

Example #15

0

Show file

File: other.php Project: quinnd6/php

<?php 
include_once 'views/header.php';
include_once 'core/class.ManageDatabase.php';
$init = new ManageDatabase();
//  $table_name = "games";
$data = $init->getOtherItems("other");
?>

<div id = "content">
     <div id ="searchbar">
        <form action="searchresults.php" method="get">
        <input type="text" name="gameSearchName">
        <input type="submit" value="search">
        </form> 
    </div>
    <div id="page_title"><h2>Other</h2></div>


<?php 
if ($data !== 0) {
    $init->printData($data);
} else {
    echo '<div id ="boxed_item">There are no non gaming items available</div>';
}
?>
				
                                     
</div>

Example #16

0

Show file

File: description.php Project: quinnd6/php

<?php

//include_once( 'views/header.php' );
include_once 'core/class.ManageDatabase.php';
$init = new ManageDatabase();
$id = $_GET['id'];
$data = $init->getDescription($id);
?>
<div id="content">
    <div id ="boxed_item">
    
<?php 
if ($data !== 0) {
    while ($row = $data->fetch()) {
        echo '<img src="' . htmlspecialchars($row['picurl1'], ENT_HTML5, 'UTF-8', false) . '" alt=""  />' . '<br>';
        echo htmlspecialchars($row['product_name'], ENT_HTML5, 'UTF-8', false) . '<br/>';
        echo '<pre>' . htmlspecialchars($row['details'], ENT_HTML5, 'UTF-8', false) . '<br/>' . '</pre>';
        echo '&euro;' . htmlspecialchars($row['price'], ENT_HTML5, 'UTF-8', false) . '<br/>';
        echo '<form id="form1" name="form1" method="post" action="cart.php">
                                <input type="hidden" name="type" id="type" value="game"/>
                                <input type="hidden" name="pid" id="pid" value="' . $id . '"/>
                                <input type="submit" name="button" id="button" value="Add to Shopping Cart"/>
                            </form>';
        echo '<a href="' . htmlspecialchars(strtolower($row['category']), ENT_HTML5, 'UTF-8', false) . '"' . '>Back to ' . htmlspecialchars($row['category'], ENT_HTML5, 'UTF-8', false) . ' page</a>';
    }
}
?>
         
        <br>
      
    </div>

PHP ManageDatabase Examples