PHP - Xn Times Using The Same Function

I only see one "mysql_query($memberquery);"  Yet the record is inserted 4 times when I check the db.  Anyone see why?

Thank you for your time!

Code: [Select]
<?php 
$link_register = 1;
session_start(user);
include("header.php"); 



$firstname      = $_SESSION['firstname'];
$middleinitial  = $_SESSION['middleinitial'];
$lastname      = $_SESSION['lastname'];
$phone      = $_SESSION['phone'];
$email      = $_SESSION['email'];
$street      = $_SESSION['street'];
$city      = $_SESSION['city'];
$state      = $_SESSION['state'];
$categoryArray  = $_SESSION['categoryArray'];
$gender      = $_SESSION['gender'];


$con = mysql_connect("localhost", "root", "");

if (!$con)
{
die("Could not connect: ". mysql_error());
}

//The database is selected with the mysql_select_db() function.
mysql_select_db("hobbyclub", $con);

//put the data insert into a varaible so it can be checked later
$memberquery = "INSERT INTO member (firstname, middleinitial, lastname, phone, email, street, city, state, gender) 
VALUES ('$firstname', '$middleinitial', '$lastname', '$phone', '$email', '$street', '$city', '$state', '$gender')";

// if ($categoryArray){
 // foreach ($categoryArray as $category){
// $categoryString .= "'$".$category."',";
// }
// }
// $categoryquery = "INSERT INTO category (categoryname) VALUES('$categoryString')";
// $categoryquery = "INSERT INTO category (categoryname) VALUES(".$categoryString.")";
 

//insert the data
mysql_query($memberquery);


?>
The commented out block of code is just me trying to figure out how to insert an array into the db.

I have an array of appointment start times throughout a day. All appointments last 30 mins.

I also have a list of times that staff are available to meet these appointment times (can be in any format, array etc.)

I need to ensure the appointment times are fully covered by members of staff.

E.g.
Code: [Select]

$appointmentStart[] = "09:30";
$appointmentStart[] = "10:00";
$appointmentStart[] = "11:00";
$appointmentStart[] = "12:30";
$appointmentStart[] = "13:30";
$appointmentStart[] = "15:00";
$appointmentStart[] = "17:00";

$staffMembers[] = "09:00*12:00";
$staffMembers[] = "13:00*16:00";
$staffMembers[] = "15:00*18:00";

In the above case, no, there are not enough staff members to cover this as nobody works from 12:00 to 13:00. I only really need a yes or no. Don't worry about staff breaks, they never work more than 3 hours each at a time.

Thanks in advance for any help.

Hello PHP Freaks,

I am using a basic payment frame system, and it requires me to pass in a GMT time in this format, in a hidden form.

"YYYYMMDDHHMMSS"

I have found a lot of examples in PHP on how to format the above tag, but what would be the easiest way to generate it as is?
To make things a little more complicated, there are different users in different GMT times, and based on the state they select it needs to + or - hours from the current time to get the GMT time.

The formulas to calculate the results are as follows, just after the best approach in PHP to calculate:

State #1:   CURRENT_TIME + 10 HOURS = GMT TIME (echo as YYYYMMDDHHMMSS) and assign to $GMT_TIMESTAMP
State #2:    CURRENT TIME + 9.5 HOURS = GMT TIME  (echo as YYYYMMDDHHMMSS) and assign to $GMT_TIMESTAMP



What would be the best way to tackle this ? At the moment I have select boxes where the user can pick the state, then click SUBMIT.

Thankyou in advance,

D

hello, i have an event reservation system. i need to make sure that every time someone is booking a new time, it's not overlap another reservation.   for example lets say i have an event reserved starting at X and ending at Y

X = Wed Sep 10 2014 07:30:00 GMT+0000
Y = Wed Sep 10 2014 08:00:00 GMT+0000

and now im reserving a new event

start = Wed Sep 10 2014 09:30:00 GMT+0000
end = Wed Sep 10 2014 09:30:00 GMT+0000

how can i check if they are not crushing? lets say the first event starts at 12:00 and end 14:00, i need to make sure that the new event is not held between these hours. it need to be started and end before 12:00 or after 14:00.   thanks in advance!

Is there a way to put the value of every 15mins into an array starting and finishing at 2 var times

$time1=10.00am
$time2=1.30pm

$timearray=array($time1, and every 15min interval up to but not including $time2)
        eg  $timearray=array(10.00am,10.15am,10.30am..........1.15pm)

Are either of these OK depending on circumstance or stupid things I should never do? Is one or the other sensible/idiotic? Is there an obvious 'better' way?   I think all the php tags opening and closing within the DIVs is untidy but it's static HTML therefore if there's a LOT of it it's easier on the server right/wrong?

On the other hand, maybe all the open/close of php tags defeats the object.

I'm applying for a web design apprenticeship (I know, I need one) so I'm trying to appear less stupid as much as make nice php.   Many thanks in advance, I know I'll end up better off by asking here

<?php
 
// php in here

?>
    <div class='content header'>
        <?php include("includes/header.php"); ?>
    </div>
    <div class='content content1'>
        <?php include("includes/intro.php"); ?>
    </div>
    <div class='content content2'>
        <?php include("includes/quals.php"); ?>
    </div>
    <div class='content content3'>
        <?php include("includes/experience.php"); ?>
    </div>
    <div class='content content4'>
        <?php include("includes/hobbies-and-interests.php"); ?>
    </div>
<?php

// More php here

?>

Or this one:

<?php
    print("<div class='content header'>");
        include("includes/header.php");
    print("</div> \r\n <div class='content content1'>");
        include("includes/intro.php");
    print("</div> \r\n <div class='content content2'>");
        include("includes/quals.php");
    print("</div> \r\n <div class='content content3'>");
        include("includes/experience.php");
    print("</div> \r\n <div class='content content4'>");
        include("includes/hobbies-and-interests.php");
    print("</div> \r\n");
?>

 test.zip   1.5KB   0 downloads

Hello,

I am having a heck of a time trying to get time right on my website lol  When a user logs in, they select what timezone they are in (UTC -1,-2,-3,-4,-5,-6....)  Now this is great an all, but with daylight savings time my times are off by one hour in either direction.  How do sites like this get times to work for users so easily?

Thanks!
weee

I have a form created that seems to work across most devices/connection.. but for some reason some phones, Androids specifically so far, seem to time out when the form is submitted using the mobile network. This has happened on multiple android phones. Doesn't seem to have an issue with iPhones. I also had a problem with a Surface tablet when connected to an android wireless signal.. tethering, the same phone that had the issue.   So what happens is once the form is submitted, it hangs for a while and then it'll say "No data received - Unable to load the webpage because the server sent no data. Reload this webpage Press the reload button to resubmit the data needed to load the page. Error code: ERR_EMPTY_RESPONSE" and then after i refresh, it submits and goes through without a problem. Sometimes it refreshsed by itself after flashing this error and goes through.    Another time, using the Surface Pro, wifi and IE, I got the error "Forbidden" you don't have permission to access /new-window-2.php on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.   You can see an example of one of the forms here - connecttopros(dot)com/windows.php   And some of the code is attached below. I'm lost. I've tried using a different server completely, twice, and it didn't fix the issue, so it must be the way the php is put together? Thanks for your help!     Attached Files  Php Freaks.zip   12.25KB   1 downloads

I've simply set some sessions....

$_SESSION['LoggedIn'] = 1;
$_SESSION['UserID'] = $row["UserID"];

They don't seem to last very long, usually when I close my browser and go back on later, they'll expire. I want them to last permanently unless the user logs out.

How do I do this?

Thanks in advance.

Well I'm hoping someone will have some fun with this.
My database has a list of times for a given date, and a schedule for each time. I'm trying to change the input backgrounds for rows between 2 different times. Like this:

8:00   enter some data
8:10   enter some data
8:20   enter some data
etc.
What I want is to change the background color of any input field between say 9:00 and 10:00, but leave everything else white.
I can change the color, just can't figure out how to compare the times.

Here's part of the code:
Code: [Select]
while($row = mysql_fetch_array( $result ))
{


$opentimeID = date("g:i",strtotime(1530)); //not sure if these statements are correct.
$closetimeID = date("g:i",strtotime(1730));
if (strtotime($row['Time']) //...not sure how to finish this statement to compare the time in the database row to $opentime and $closetime.


{
echo "<tr><td>";
echo date("g:i ", strtotime($row[Time]));
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player1]' name='player1[$i]'
style ='background-color: #FFFF66;'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player2]' name='player2[$i]'
style ='background-color: #FFFF66;'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player3]' name='player3[$i]'
style ='background-color: #FFFF66;'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player4]' name='player4[$i]'
style ='background-color: #FFFF66;'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player5]' name='player5[$i]'
style ='background-color: #FFFF66;'>";
}
else
{
echo "<tr>";
echo "<td>";
echo date("g:i ", strtotime($row[Time]));
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player1]' name='player1[$i]'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player2]' name='player2[$i]'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player3]' name='player3[$i]'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player4]' name='player4[$i]'>";
echo "</td><td>";
echo "<input type='text' size='20' value= '$row[Player5]' name='player5[$i]'>";
}

Thanks for any advice!

I have a string, and I have a variable

$var = 5;
$str = '<img src="img.jpg" />';


i want to display a $str (the image) $var amount of times (5). how can I do this?

Hi There,

I am trying to use PHP to create a calendar that only show's working days - which are monday to friday.

Is there any way that PHP can return a list of the next 5 working day's dates? For example, if today is Thursday 15th Sept - could it return the numbers 15,16,19,20 and 21?

Thanks
Matt

Hi guys, i got the following code i wrote which displays a small pop up on screen if the user has mail, and display a little icon. The problem is it displays a new icon for each new mail message. How can i make it so it only display 1 icon no matter how many unread mail the user has. Or even better if not too complicated display a number next too the image?

Code: [Select]
<?
require'xxxxxxxxxxxxxxxxx.php';
mysql_select_db("membership") or die( "Unable to select database");
$sql=("SELECT * FROM user_alerts WHERE user_id = '".($_SESSION['user_id'])."'") or die (mysql_error());
if ($query=@mysql_query($sql)) {
if (mysql_num_rows($query) > 0) {
while ($req=mysql_fetch_array($query)) {

if ($req['messageRead'] == 'NO')
{
?>
<div>
<img src="xxxxxxxxxxxxxx.png" width="32" height="32" alt="unread mail" /> <a href="http://www.xxxxxxxxxxxx/account=account">You have Mail!</a>
<div id="boxes">
<div style="top: 199.5px; left: 551.5px; display: none;" id="dialog" class="window">
<h2>You have new mail!</h2>
<br />
<p>Visit your account page to read it.</p>
<br>
<a href="#" class="close">Close Window</a>
</div>
<!-- Mask to cover the whole screen -->
<div style="width: 1478px; height: 602px; display: none; opacity: 0.8;" id="mask"></div>
</div>
</div>
<?
}
}
}
}
You can ignore most of the div stuff but that's pretty much it. It should check my database for any entries with the users session id in the column called 'user_id'. and only show the image if it then finds an entry with 'NO' in the 'messageRead' column. It currently shows the images for each entry it finds.

Thanks for any help

Hey guys

I have a client who wants to upload images then have them display on his page... obviously that process is not an issue at all.
The catch is he wants the image to change at midnight and display the next image in the sequence, then display it until midnight strikes, and then the next in the sequence is displayed.

Is there any code type that will recognise a set time/date and display coressponding images in a database?
I realise I made need to add a field for an ID number/date ID for the code to identify which image to display, but not sure what code will/wont work

Can some one point me in the right direction
would be much appreciated


Thanks
Tom

Hi, I am having some trouble re-using a method of a class which I use to setup my pages. I have an include which instantiates the class and then I make a call at the top of each page depending on the content required. I have several javascripts I want to include for a specific page and would like to just keep calling the same method to load them. If I try to call the method twice on the last one is echoed. I don't really want have to write out different methods for each file I may need.

Any help much appreciated.



The included class has this:

Code: [Select]
class Page {

   public function display_top() {
     
     # page specific atrributes
     $this->display_js();

    }

    public function display_js() {
echo "<script type='text/javascript' src='{$this->js}'></script>\n";
}
}

my page has this:

Code: [Select]
require ('classes/page_class.php');

$page = new Page;
 $page->js = "js/jquery-1.3.2.min.js";
 $page->js = "js/revealClass.js";