PHP Ad::showJustCategories方法代码示例

function pageController()
{
    session_start();
    if (!isset($_SESSION['Loggedinuser'])) {
        $loginstatus = "Members, Log In!";
    } else {
        $loginstatus = $_SESSION['Loggedinuser'] . " is logged in!";
    }
    // Upon arrival at this page, this will load all the ads from the database.
    $adsArray = Ad::all();
    // Upon choosing a category, $clickcategories is set in $_GET. This variable is used to query the database.
    $clickedcategories = Input::has('clickcategory') ? '%' . Input::get('clickcategory') . '%' : '%';
    $adsArray = Ad::findCategories($clickedcategories);
    arsort($adsArray);
    // This portion of code gets all the ads' categories in one array.
    // The categories, which are strings (sometimes with multiple categories in it),
    // are then put into the array by themselves. The array is imploded into a string and then exploded into an
    // array again. This allows us to split the strings with multiple categories in them.
    // The php array_unique removes duplicate category values and sort orders them by first letter.
    $arrayCategories = Ad::showJustCategories();
    $justCategories = [];
    foreach ($arrayCategories as $key => $value) {
        array_push($justCategories, $value['categories']);
    }
    $justCategoriesString = implode(', ', $justCategories);
    $justCategoriesArray = explode(', ', $justCategoriesString);
    $justCategoriesArrayUnique = array_unique($justCategoriesArray);
    sort($justCategoriesArrayUnique);
    // This randomly selects an ad to show in the spotlight spatula box.
    $spotlight = $adsArray[array_rand($adsArray, 1)];
    return array('adsArray' => $adsArray, 'loginstatus' => $loginstatus, 'clickedcategories' => $clickedcategories, 'spotlight' => $spotlight, 'justCategoriesArrayUnique' => $justCategoriesArrayUnique);
}

function pageController()
{
    $ads = Ad::getNewest();
    // extract(pageController());
    session_start();
    if (!isset($_SESSION['Loggedinuser'])) {
        $loginstatus = "Members, Log In!";
    } else {
        $loginstatus = $_SESSION['Loggedinuser'] . " is logged in!";
    }
    $adId = Input::has('id') ? Input::get('id') : 1;
    $arrayCategories = Ad::showJustCategories();
    $justCategories = [];
    foreach ($arrayCategories as $key => $value) {
        array_push($justCategories, $value['categories']);
    }
    $justCategoriesString = implode(', ', $justCategories);
    $justCategoriesArray = explode(', ', $justCategoriesString);
    $justCategoriesArrayUnique = array_unique($justCategoriesArray);
    sort($justCategoriesArrayUnique);
    return ['ads' => $ads, 'loginstatus' => $loginstatus, 'justCategoriesArrayUnique' => $justCategoriesArrayUnique];
}

function pageController()
{
    require_once '../db/db_connect.php';
    // Gets the current session and session id for logged in users.
    session_start();
    $sessionId = session_id();
    if (!isset($_SESSION['Loggedinuser'])) {
        header('location: auth.login.php');
        die;
    }
    $loginstatus = $_SESSION['Loggedinuser'] . " is logged in!";
    // This portion of code gets all the ads' categories in one array.
    // The categories, which are strings (sometimes with multiple categories in it),
    // are then put into the array by themselves. The array is imploded into a string and then exploded into an
    // array again. This allows us to split the strings with multiple categories in them.
    // The php array_unique removes duplicate category values and sort orders them by first letter.
    $arrayCategories = Ad::showJustCategories();
    $justCategories = [];
    foreach ($arrayCategories as $key => $value) {
        array_push($justCategories, $value['categories']);
    }
    $justCategoriesString = implode(', ', $justCategories);
    $justCategoriesArray = explode(', ', $justCategoriesString);
    $justCategoriesArrayUnique = array_unique($justCategoriesArray);
    sort($justCategoriesArrayUnique);
    // Through $_SESSION, gets the logged in user.
    $username = Auth::user();
    // Returns an object of the user's data.
    $user = User::finduserbyusername($username);
    // Uses the 'Create an Ad' form to insert the new values to the table and database.
    function insertAd($dbc, $user)
    {
        // Now calls on the Input class's getString and getDate methods with try catches.
        // Try catch create an array of errors for passing to the user in the HTML.
        $errorArray = [];
        try {
            $method = Input::getString('method', 1, 50);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errMethod'] = $error;
        }
        try {
            $title = Input::getString('title', 1, 50);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errTitle'] = $error;
        }
        try {
            $price = Input::getNumber('price', 0, 25000);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errPrice'] = $error;
        }
        try {
            $location = Input::getString('location', 1, 50);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errLoc'] = $error;
        }
        try {
            $description = Input::getString('description', 1, 500);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errDes'] = $error;
        }
        try {
            $categoriesArray = Input::get('categories', 1, 50);
            $categories = implode(', ', $categoriesArray);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errCats'] = $error;
        }
        // This portion allows for image uploads.
        if (Input::has('title')) {
            if ($_FILES) {
                $uploads_directory = 'img/uploads/';
                $filename = $uploads_directory . basename($_FILES['image_url']['name']);
                if (move_uploaded_file($_FILES['image_url']['tmp_name'], $filename)) {
                    // echo 'The file ' . basename($_FILES['image_url']['name']) . ' has been uploaded.';
                } else {
                    $errorArray['errImage'] = 'Sorry, there was an error uploading your file.';
                }
            }
        }
        // If the $errorArray is not empty, this will return out of the method before binding values and executing below. The $errorArray returns with an array of strings.
        if (!empty($errorArray)) {
            return $errorArray;
        }
        $stmt = $dbc->prepare('INSERT INTO ads (user_id, method, image_url, title, price, location, description, categories) VALUES (:user_id, :method, :image_url, :title, :price, :location, :description, :categories)');
        $stmt->bindValue(':user_id', $user->id, PDO::PARAM_STR);
        $stmt->bindValue(':method', $method, PDO::PARAM_STR);
        $stmt->bindValue(':image_url', $filename, PDO::PARAM_STR);
        $stmt->bindValue(':title', $title, PDO::PARAM_STR);
        $stmt->bindValue(':price', $price, PDO::PARAM_INT);
        $stmt->bindValue(':location', $location, PDO::PARAM_STR);
        $stmt->bindValue(':description', $description, PDO::PARAM_STR);
        $stmt->bindValue(':categories', $categories, PDO::PARAM_STR);
        $stmt->execute();
    }
    // Sets each variable for future use in the following 'if else' logic tree.
//.........这里部分代码省略.........

function pageController()
{
    require_once '../db/db_connect.php';
    // Gets the current session and session id for logged in users.
    session_start();
    $sessionId = session_id();
    if (!isset($_SESSION['Loggedinuser'])) {
        header('location: auth.login.php');
        die;
    }
    $loginstatus = $_SESSION['Loggedinuser'] . " is logged in!";
    // This portion of code gets all the ads' categories in one array.
    // The categories, which are strings (sometimes with multiple categories in it),
    // are then put into the array by themselves. The array is imploded into a string and then exploded into an
    // array again. This allows us to split the strings with multiple categories in them.
    // The php array_unique removes duplicate category values and sort orders them by first letter.
    $arrayCategories = Ad::showJustCategories();
    $justCategories = [];
    foreach ($arrayCategories as $key => $value) {
        array_push($justCategories, $value['categories']);
    }
    $justCategoriesString = implode(', ', $justCategories);
    $justCategoriesArray = explode(', ', $justCategoriesString);
    $justCategoriesArrayUnique = array_unique($justCategoriesArray);
    sort($justCategoriesArrayUnique);
    // Through $_SESSION, gets the logged in user.
    $username = Auth::user();
    // Returns an object of the user's data.
    $user = User::finduserbyusername($username);
    // Using the user's id (a foreign key in the ads table), finds all ads by that user.
    $userAds = Ad::findAllAdsByUserId($user->id);
    // The first form "Select an Ad" sets 'ad_to_edit' in $_POST, which is the variable $adToEdit.
    $adToEdit = Input::has('ad_to_edit') ? (int) Input::get('ad_to_edit') : NULL;
    // Using $adToEdit, this returns an object of data about that ad.
    $adToEditObj = Ad::find($adToEdit);
    // Uses the second form of an edited ad to insert the new values into the table and database.
    function updateAd($dbc, $user)
    {
        // Now calls on the Input class's getString and getNumber methods with try catches.
        // Try catch create an array of errors for passing to the user in the HTML.
        $errorArray = [];
        try {
            $method = Input::getString('method', 1, 50);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errMethod'] = $error;
        }
        try {
            $title = Input::getString('title', 1, 50);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errTitle'] = $error;
        }
        try {
            $price = Input::getNumber('price', 0, 25000);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errPrice'] = $error;
        }
        try {
            $location = Input::getString('location', 1, 50);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errLoc'] = $error;
        }
        try {
            $description = Input::getString('description', 1, 500);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errDes'] = $error;
        }
        try {
            $adid = Input::getNumber('adid', 1, 5000000);
        } catch (Exception $e) {
            $error = $e->getMessage();
        }
        try {
            $categoriesArray = Input::get('categories', 1, 50);
            $categories = implode(', ', $categoriesArray);
        } catch (Exception $e) {
            $error = $e->getMessage();
            $errorArray['errCats'] = $error;
        }
        // This portion allows for image uploads.
        // If the user does not upload an image, the value in the readonly input of image url is used instead.
        if (!isset($_FILES['image_upload'])) {
            $filename = Input::get('image_url');
        } else {
            if ($_FILES['image_upload']['name'] != '') {
                $uploads_directory = 'img/uploads/';
                $filename = $uploads_directory . basename($_FILES['image_upload']['name']);
                if (move_uploaded_file($_FILES['image_upload']['tmp_name'], $filename)) {
                    // echo 'The file ' . basename($_FILES['image_upload']['name']) . ' has been uploaded.';
                } else {
                    $errorArray['errImage'] = 'Sorry, there was an error uploading your file.';
                    var_dump($_FILES);
                }
            } else {
                $filename = Input::get('image_url');
            }
//.........这里部分代码省略.........