PHP - Moved: Calendar Styling

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=330163.0

I would like to style this echo in my css, how would I go about making it a div class or something to give it a ID.
Code: [Select]
die ("Sorry, No Results Match Your Search.");

Thank You

Hi Bit new to this so bear with me. I have an API call that outputs to a .php file (the data in the file appears to be xml - no format). Can you please advise if i would link this to a .css file as per .html to get the formatting i require...if so, can you offer a suggestion on the syntax?   This is my API call:   <?php 

hey guys, I am wondering how to style the below code snippet using css? the code itself is working - i just am trying to figure out how to style it :(

<div class="section">
<?php
if(isset($_SESSION['uid'])) {
  echo 'Hello,';
  echo $_SESSION["uid"];
  }
 ?>
</div>

 

Hey guys, I have a PHP pagination script, but for some reason the while looping part that shows each row doesnt show the css styling I have.

Here is my code.



<?php


    $tableName="news";        
    $targetpage = "archive.php";     
    $limit = 10; 
    
    $query = "SELECT COUNT(*) as num FROM $tableName";
    $total_pages = mysql_fetch_array(mysql_query($query));
    $total_pages = $total_pages['num'];
    
    $stages = 3;
    $page = mysql_escape_string($_GET['page']);
    if($page){
        $start = ($page - 1) * $limit; 
    }else{
        $start = 0;    
        }    
    
    // Get page data
    $query1 = "SELECT * FROM $tableName LIMIT $start, $limit";
    $result = mysql_query($query1);
    
    // Initial page num setup
    if ($page == 0){$page = 1;}
    $prev = $page - 1;    
    $next = $page + 1;                            
    $lastpage = ceil($total_pages/$limit);        
    $LastPagem1 = $lastpage - 1;                    
    
    
    $paginate = '';
    if($lastpage > 1)
    {    
    

    
    
        $paginate .= "<div class='paginate'>";
        // Previous
        if ($page > 1){
            $paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
        }else{
            $paginate.= "";    }
            

        
        // Pages    
        if ($lastpage < 7 + ($stages * 2))    // Not enough pages to breaking it up
        {    
            for ($counter = 1; $counter <= $lastpage; $counter++)
            {
                if ($counter == $page){
                    $paginate.= "<span class='current'>$counter</span>";
                }else{
                    $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
            }
        }
        elseif($lastpage > 5 + ($stages * 2))    // Enough pages to hide a few?
        {
            // Beginning only hide later pages
            if($page < 1 + ($stages * 2))        
            {
                for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
                {
                    if ($counter == $page){
                        $paginate.= "<span class='current'>$counter</span>";
                    }else{
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
                }
                $paginate.= "...";
                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";        
            }
            // Middle hide some front and some back
            elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
            {
                $paginate.= "<a href='$targetpage?page=1'>1</a>";
                $paginate.= "<a href='$targetpage?page=2'>2</a>";
                $paginate.= "...";
                for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
                {
                    if ($counter == $page){
                        $paginate.= "<span class='current'>$counter</span>";
                    }else{
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
                }
                $paginate.= "...";
                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";        
            }
            // End only hide early pages
            else
            {
                $paginate.= "<a href='$targetpage?page=1'>1</a>";
                $paginate.= "<a href='$targetpage?page=2'>2</a>";
                $paginate.= "...";
                for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
                {
                    if ($counter == $page){
                        $paginate.= "<span class='current'>$counter</span>";
                    }else{
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
                }
            }
        }
                    
                // Next
        if ($page < $counter - 1){ 
            $paginate.= "<a href='$targetpage?page=$next'>next</a>";
        }else{
            $paginate.= "<span class='disabled'>next</span>";
            }
            
        $paginate.= "</div>";        
    
    
}
 //echo $total_pages.' Results';
 // pagination
 echo $paginate;
?>
                                <div class="newsBorder">
    <table cellspacing="0" border="0" id="newsList" class="width100">
<tbody>
<tr class="row_a">
<td width="30%" class="1 first" id="titleCat">
<b>Category</b>
</td>
<td width="50%" class="item" id="titleTitle">
<b>News Item</b>
</td>
<td width="20%" align="right" class="date">
<b>Date</b>
</td>
</tr>
                    </tbody>

                    </table>
                    



<?php 
 

        while($row = mysql_fetch_array($result))
        {
        
        
?>        
<tr class="pad">

<td valign="top">
<a href="list.ws?cat=3&amp;page=1" class="catLink">
<img alt="" src="http://www.runescape.com/img/news/mini_customer_support.gif">
<span>Website</span>
</a>
</td>

<td valign='middle'><a href="news.php?newsid=<?php echo $row['newsid'] ?>" class="titleLink"><?php echo $row['title']; ?> </a></td>

<td valign="middle" align="right" class="date"><?php echo $row['dtime']; ?></td></tr><br>
            <?php
        }
    ?>

    </div>
    

Here is how it looks right now:


Here is how I want it to look like.


Its basically everything inside the while is not formatting.

I have all the CSS I need so that isnt the problem.

Thanks for the help ahead of time.

Hello, I need some simple help styling the output of some simple php code, I have attached a view of what the output is of right now and of what I need it to look like in the end, I have tried several times myself with faulty results. The number 3 in the first screenshot attachment is what I am looking for on the article count code, it has a div style of Code: [Select]
<div class="cart-count"> the number 5 is the output of the code and that is what I need changed to the cart count class. I need the article count to be centered and to the left of the text output code, example of what I am looking for is in screenshot2 attachment. Can someone please help???

Code: [Select]
<?php // no direct access
defined('_JEXEC') or die('Restricted access'); ?>
<div class="articles_count<?php echo $params->get('moduleclass_sfx'); ?>">

<!--- I need this article count to have a different output style then the next php code below, I also need to have it float center and to the left--->
<?php foreach($lists->artcount as $key => $value): ?>
                          <!--- End --->

<!--- I need this to float center and right to the above article count code --->
<?php echo trim($params->get('beforeText')); ?> <?php echo $value; ?>
                                         <!--- End --->

<?php if ($lists->type == 'section'){ echo trim($params->get('afterTextSection')); } else {echo trim($params->get('afterTextCategory')); } ?> <?php echo $lists->names[$key]; ?>
<?php endforeach; ?>

In CSS, most people add most styling to the A tag instead of UL or LI.  Do you know why?

 

    Good Evening ! 
little help or a lot please ?

I have coded a calendar on my site and am now trying to input the data info from MySQL into the 
calendar by PHP for each corresponding date...the calendar code works but I cant figure out how to 
get the info that's submitted in to the specified/corresponding date in the calendar :/ but I can get 
it to the bottom of the page.

I've been at this 3 days and a million searches to find an example to follow but now I am at my wits 
end ! been about 15 years since I've done this. PLEASE help :) and thank you so much
The HTML is good I can add to it if needed but the problem area is the calendar portion and putting 
it all in the right place without an error or code issue.

I'm not sure how much more information i can provide. Like I said I am still trying to remember all 
of this stuff and trying to teach myself again and im not having much luck but i am a fast learner 
and 
can pickup by seeing how the code is written usually

Here is my code: or at least the PHP portion of it. I hope this helps.

<?php
/*MAKES THE CONNECTION*/
include 'config.php';
$conn = mysqli_connect($servername, $username, $password, $dbname);
// CHECK CONNECTION
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
/*DRAWS CALENDAR*//
function draw_calendar($month,$year){

$calendar = '<table cellpadding="0" cellspacing="0" class="calendar">';

$headings = array('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday');
$calendar.= '<tr class="calendar-row"><td class="calendar-day-head">'.implode('</td><td 
class="calendar-day-head">',$headings).'</td></tr>';

$running_day = date('w',mktime(0,0,0,$month,1,$year));
$days_in_month = date('t',mktime(0,0,0,$month,1,$year));
$days_in_this_week = 1;
$day_counter = 0;
$dates_array = array();
$start_day = 

$calendar.= '<tr class="calendar-row">';

for($x = 0; $x < $running_day; $x++):
    $calendar.= '<td class="calendar-day-np"> </td>';
    $days_in_this_week++;
endfor;

for($list_day = 1; $list_day <= $days_in_month; $list_day++):
    $calendar.= '<td class="calendar-day">';
        /* add in the day number */
        $calendar.= '<div class="day-number">'.$list_day.'</div>';

        /** QUERY THE DATABASE FOR AN ENTRY FOR THIS DAY !!  IF MATCHES FOUND, PRINT THEM !! **/
        $sql = "SELECT * FROM $tablename WHERE $current_epoch BETWEEN $start_day AND $end_day";
        /** NEED TOQUERY THE DATABASE FOR AN ENTRY FOR THIS DAY !!  IF MATCHES FOUND, PRINT THEM !! 
**/
$calendar.= str_repeat('<p>'.$start_day.'</p>',2);

     $calendar.= '</td>';
    if($running_day == 6):
        $calendar.= '</tr>';
        if(($day_counter+1) != $days_in_month):
            $calendar.= '<tr class="calendar-row">';
        endif;
        $running_day = -1;
        $days_in_this_week = 0;
    endif;
    $days_in_this_week++; $running_day++; $day_counter++;
endfor;

if($days_in_this_week < 8):
    for($x = 1; $x <= (8 - $days_in_this_week); $x++):
        $calendar.= '<td class="calendar-day-np"> </td>';
    endfor;
endif;

/* final row */
$calendar.= '</tr>';

/* end the table */
$calendar.= '</table>';

return $calendar;
}
$sql = "SELECT id, name, phone, item, start_day, end_day, start_time, end_time FROM $tablename";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $calendar. "id: " . $row["id"]. " - Name: " . $row["name"]. " - Phone: " . $row["phone"]. " - 
Item: " . $row["item"]. " - Start Day: " . $row["start_day"]. " - End Day:  " . $row["end_day"]. " - 
Start Time:  " . $row["start_time"]. " - End Time:  " . $row["end_time"]. "<br>";
}
} else {
echo "0 results";
}

	
	/*END OF SHOWINGCALENDAR_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
*/	
	
	
$sql = "SELECT id, name, phone, item, start_day, end_day, start_time, end_time FROM $tablename";
$result = $conn->query($sql);
	
/*GETS THE RESULTS OF THE CALENDAR FROM DATABASE TABLE*/
if ($result->num_rows > 0) {
  // output data of each row
  while($row = $result->fetch_assoc()) {
    echo $calendar. "id: " . $row["id"]. " - Name: " . $row["name"]. " - Phone: " . $row["phone"]. " - Item: " . $row["item"]. " - Start Day: " . $row["start_day"]. " - End Day:  " . $row["end_day"]. " - Start Time:  " . $row["start_time"]. " - End Time:  " . $row["end_time"]. "<br>";
  }
} else {
  echo "0 results";
}

 

Edited January 18 by Isfun42ofus

Hello Guys,
My goal is to make a Php and SQL calendar. I started learning php and sql a while ago, and basically got distracted. I'm now back, with a new project in the unhelpful position of having forgotten most of what I had learnt!

I am making a project where I want to make a booking system. I have 3 rooms that are available to be booked Room 1, Room 2 and Room 3. I want to make a table that displays the current year in the top row, with the option to be able to click on a '<' or a '>' to change years. I want the same option for months and weeks. I think I am happy with how I would do this. The next bit is more tricky. I want a column for each of the days of the week. directly under this I want to display the correct date, under the correct day, starting with the current week we are on. for example it might look like this:

               -------------------------------------------
               |             <     2012      >                    |
               -------------------------------------------
               |             <      March     >                   |
               -------------------------------------------
               |             <      2     >                          |
               -------------------------------------------
               |mon | tues | wed| thur | fri  | sat | sun |
              | 5th  |  6th |  7th|  8th |9th |10th| 11th |
               ---------------------------------------------
Room 1   | yes    |        |       |       |      |     |        |
               ----------------------------------------------
Room 2   |         |        | yes  |       |      |     |        |
               ----------------------------------------------
Room 3   |         |        |       |       |yes  |     |        |
               ----------------------------------------------

Although at the moment I'm struggling with the whole flippin' thing, the main issue is getting the correct dates to line up under the correct days of the week. I'm not asking for you to do this for me- but a bit of gentle help in this, and maybe some general advice in what I'm trying to achieve would be really useful!

Regards,

AJLX

hi,

i have implemented a calendar in php and added contols to display the previous and next months. How will I enhance my code to add links to display the previous and next year calendars?

My code is as follows:
Code: [Select]
<?php
 session_start();
 $_SESSION['username'];
 $_SESSION['unique_id'];
 $username = $_SESSION['username'];
 $unique_id = $_SESSION['unique_id'];
 ?>

<?php
    $host = "localhost";
    $user=""; 
    $password=""; 
    $db_name=""; 
    $tbl_name=""; 
    
    $con = mysql_connect("localhost","","");
    if (!$con)
      {
          die('Could not connect: ' . mysql_error());
      }
    mysql_select_db("$db_name", $con);
    
    // Now we need to define "A DAY", which will be used later in the script:
    define("ADAY", (60*60*24));
     
    // The rest of the script will stay the same until about line 82
     
    if ((!isset($_GET['month'])) || (!isset($_GET['year']))) {
        $nowArray = getdate();
        $month = $nowArray['mon'];  //mon - Numeric representation of a month
    $year = $nowArray['year'];
    } else {
        $month = $_GET['month'];
    $year = $_GET['year'];
    }
    $start = mktime(12,0,0,$month,1,$year);
    $firstDayArray = getdate($start);
    ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?php echo "Calendar: ".$firstDayArray['month']."" . $firstDayArray['year']; ?></title>
<link type="text/css" href="css/style_inner.css" rel="stylesheet" />
</head>

<body>
    <form method="get" action="<?php echo $_SERVER['PHP_SELF']; ?>" style="padding-top:50px">
    <?php
        /* "next month" control */
$next_month = '<a href="?month='.($month != 12 ? $month + 1 : 1).'&year='.($month != 12 ? $year : $year + 1).'" class="control" style="text-decoration:none; padding-left:50px;">Next Month&nbsp;&nbsp;></a>';

/* "previous month" control */
$previous_month = '<a href="?month='.($month != 1 ? $month - 1 : 12).'&year='.($month != 1 ? $year : $year - 1).'" class="control" style="text-decoration:none; padding-left:200px; padding-right:50px;"><&nbsp;&nbsp;Previous Month</a>';


/*$next_year = '<a href="?year='.($year != 2050 ? $year + 1 : 1).'&year='.($year != 2050 ? $year : $year + 1).'" class="control" style="text-decoration:none; padding-left:10px;">Next Year&nbsp;&nbsp;>></a>';

$previous_year = '<a href="?month='.($year != 2011 ? $year - 1 : 2050).'&year='.($year != 2011 ? $year : $year - 1).'" class="control" style="text-decoration:none; padding-left:150px;"><<&nbsp;&nbsp;Previous Year</a>';

echo $previous_year;*/
echo $previous_month;
    ?>
    <select name="month"><br/>
    <?php
    $months = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
     
    for ($x=1; $x<=count($months); $x++){
        echo "<option value=\"$x\"";
    if ($x == $month){
            echo " selected";
        }
        echo ">".$months[$x-1]."</option>";
    }
    ?>
    </select>
    <select name="year">
    <?php
    for ($x=2011; $x<=2050; $x++){
    echo "<option";
        if ($x == $year){
        echo " selected";
        }
        echo ">$x</option>";
    }
    ?>
    </select>
<input type="submit" name="submit" value="Go!">
<?php
    echo $next_month;
    /*echo $next_year;*/
?>
    </form>
    <br />
    <?php
    $days = Array("Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat");
    echo "<table border=\"1\" style=\"padding-left:100px;\"><tr>\n";
    foreach ($days as $day) {
        echo "<td style=\"background-color: #000000; width: 100px\" align=\"center\">
              <strong style=\"color:#FFFFFF;\">$day</strong></td>\n";
    }
     
    for ($count=0; $count < (6*7); $count++) {
        $dayArray = getdate($start);
        if (($count % 7) == 0) {
        if ($dayArray["mon"] != $month) {
            break;
        } else {
                echo "</tr><tr>\n";
        }
        }
        if ($count < $firstDayArray["wday"] || $dayArray["mon"] != $month) { //wday - Numeric representation of the day of the week
        echo "<td height=\"110px\"> </td>\n";
        } else { //mday - Numeric representation of the day of the month
            $chkEvent_sql = "SELECT event_title, event_shortdesc FROM calendar_events WHERE month(event_start) = '".$month."' AND dayofmonth(event_start) = '".$dayArray["mday"]."' AND year(event_start) = '".$year."' ORDER BY event_start";
       $chkEvent_res = mysql_query($chkEvent_sql, $con) or die(mysql_error($con));
 
        if (mysql_num_rows($chkEvent_res) > 0) {
            $event_title = "<br/>";
            while ($ev = mysql_fetch_array($chkEvent_res)) {
                    $event_title .= "<font color=\"#006600\">" . stripslashes($ev["event_title"])."</font><br/>";
                    //$event_shortdesc .= stripslashes($ev["event_shortdesc"])."<br/>";
            }
                mysql_free_result($chkEvent_res);
            } else {
            $event_title = "";
            $event_shortdesc = "";
            }
 
        echo "<td height=\"110px\" style=\"color : #0000CC;\">".$dayArray["mday"]."<a href=\"event.php?m=".$month."&d=".$dayArray["mday"]."&y=".$year."\" style=\"text-decoration:none;\"><img src=\"images/Add Event.jpg\" alt=\"Add Event\" title=\"Add Event\" height=\"20px\" width=\"20px\" style=\"padding-left:20px;\"/></a><br/>".$event_title."</td>\n";
         unset($event_title);
     
            $start += ADAY;
        }
    }
    echo "</tr></table>";
    mysql_close($con);
    ?>

</body>
</html>

Please help me out its urgent..


Thank you in advance...

Hello there!

I've been at this for too long! I've got a normal calendar at the side of my website that works fine, however i would like one that shows the next 7 days starting at today. I have an image here that kind of shows what i want...



So it will show the next 7 days starting with today, and going into the next month if todays date is the 30th etc.

Could anybody please help me? :\

Hi, I'd really appreciate some guidance regarding the GET method. 

Thus far I've developed a calendar that displays a month at a time.
I've created a 'next' button (div) that onclick - it submits values via GET.  This works well.

Code: [Select]
<div onclick="location.href='cal.php?m=<?php if ($monthly == 12) { 
$monthly = 1; $yearly++; } else { $monthly++; } 
echo $monthly?>&y=<?php echo $yearly?>'" id="nextMonth" class="nextMonth next"></div>
The complication comes with the 'prev' button, which I thought would be the reverse of the next button (logic wise).

Code: [Select]
<div onclick="location.href='cal.php?m=<?php if ($monthly == 1) {
$monthly = 12; $yearly--; } else { $monthly--; } 
echo $monthly?>&y=<?php echo $yearly?>'" id="prevMonth" class="nextMonth prev"></div>
Can you see any reason why this 'prev' button does not work?

FYI, This reads GET and initiates the page
Code: [Select]
$m = !empty($_GET["m"]) ? $_GET["m"] : '';
$y = !empty($_GET["y"]) ? $_GET["y"] : '';
if ($m) {
   $monthly = ($m);
   $yearly = ($y);
} else {
$now = time();
$cur_month = date("n", $now);
$cur_year = date("Y", $now);
$monthly = $cur_month;
$yearly = $cur_year; }
Thanks.

Good Evening,

I have a working knowledge or HTML/CSS and right now I am learning/reading about PHP.

Currently I am looking to build a website around an events calendar, let me explain more.

A user would log onto the site, submit a form (with an event), this would then be added to a calendar as well a new page for the event details.

The calendar would be fully visible to an visitor to the site.

I would also like the ability to add a ticker on the homepage with the latest events added.

How complicated is this to implement? And what are the basic requirements?

I hope this makes sense.

Thanks,

Cain

I'm trying to help someone out with their website (which is entirely in PHP) and I've come across a problem I can't seem to figure out.

On the site is a php calendar that should display as so:



However, sometimes for no apparent reason the calendar appears as so:



I cannot seem to determine what is causing this to display incorrectly. It just started happening for no discernible reason.

Anyone have any idea where I should start looking to find the issue? It is linked to a MySQL database that is somewhat wonky, could that be the issue?

Thanks for any advice you guys can give me.