PHP date2dateDir Examples

Example #1

File: post-manager.php Project: laiello/no-clan-sauerbraten-website

if (!empty($_GET['idPost'])) {
    $idPost = mysql_real_escape_string($_GET['idPost']);
    // Bring back the post for editting
    $query = "SELECT idPost, title, userId, summary, postFor, summary_img, body, tags, date_pub, date, imgs FROM posts WHERE idPost = {$idPost}";
    $result = mysql_query($query, $dbConn);
    $row = mysql_fetch_assoc($result);
    // Make sure the user who wants to edit is the post original editor
    if ($row['userId'] != $arrUser['idUser']) {
        go_home();
    }
    // Put the data in single vars
    //$idPost=$row['idPost']; $title=$row['title']; $body=$row['body']; $date=$row['date']; $date_pub=$row['date_pub']; $summary=$row['summary'];
    //$summary_img=$row['summary_img']; $tags=$row['tags']; $body=$row['body']; $userId=$row['userId']; $imgs=$row['imgs'];
    extract($row);
    // Where are the images of this post stored?
    $dirImgs = date2dateDir($date);
    $arrImgs = glob('../data/images/posts/' . $dirImgs . '/{' . $imgs . '*.jpg}', GLOB_BRACE);
    unset($query, $result, $row);
} else {
    // SETTING THE IMAGE (YEARMONTH) DIR AND THE IMAGES PREFIX
    if (!empty($_GET['dirImgs']) && !empty($_GET['imgs'])) {
        $dirImgs = $_GET['dirImgs'];
        $imgs = $_GET['imgs'];
        $arrImgs = glob('../data/images/posts/' . $dirImgs . '/{' . $imgs . '*.jpg}', GLOB_BRACE);
    } elseif (!empty($_POST['dirImgs']) && !empty($_POST['imgs'])) {
        $dirImgs = $_POST['dirImgs'];
        $imgs = $_POST['imgs'];
        $arrImgs = glob('../data/images/posts/' . $dirImgs . '/{' . $imgs . '*.jpg}', GLOB_BRACE);
    } else {
        $dirImgs = date('Ym');
        $imgs = time();

Example #2

File: index.php Project: laiello/no-clan-sauerbraten-website

            $get_info = 'Your new post has been added.';
            break;
        case 'ready':
            $get_info = 'Your post has ben marked as ready. An admin will check and publish the post. Be patient...';
            break;
    }
}
// DELETE
if (!empty($_GET['del'])) {
    $del = mysql_real_escape_string($_GET['del']);
    // Where are the images of the post?
    $query = "SELECT date, imgs FROM prePosts WHERE idPost = '{$del}'";
    $result = mysql_query($query, $dbConn);
    $row = mysql_fetch_assoc($result);
    $imgs = $row['imgs'];
    $dirImgs = date2dateDir($row['date']);
    unset($query, $result, $row);
    // ... got it! Then delete the images...
    $path = "../data/images/posts/{$dirImgs}";
    $images = glob($path . '/{' . $imgs . '*.jpg}', GLOB_BRACE);
    foreach ($images as $image) {
        @unlink($image);
    }
    // ... and the post on database
    $query = "DELETE FROM prePosts WHERE idPost = {$_GET['del']}";
    $result = mysql_query($query, $dbConn);
    unset($query, $result);
    //... and the comments (poor users...)
    $query = "DELETE FROM comments WHERE postId = {$_GET['del']}";
    $result = mysql_query($query, $dbConn);
    unset($query, $result);