PHP - Get Data Records In Blocks

how would i setup special date blocks in date search?
for example easter this year is 17-04-2011 to 25-04-2011

for these dates each night will have an extra charge for it

now if a user checks 13-04-2011 to 18-04-2011 he will have 4 days of special charge

how do i setup this range?

Hi, I have a new website I have been working on for the past 6 months supposed to be going live on Jan 1st. It is my first attemp at a home made CMS and I am now in BETA stages, my testers have mentioned that my image upload script is not perfect. At the moment my images simply upload with no alterations. What they have suggested and I agree is that the images should be resized on upload and have unique names. I have tried to do both but failed. I have managed to change the name of the image that is being uploaded by putting random numbers on the end but the name that is stored in the table is the original name and I can't get it to add the random numbers on the end. The other task I totally failed at and have been working on all week and broke my code so bad I have now reverted back to square one. Could someone please help me to add image resize on upload and to put the new image name into my table, I wld be most greatful. Thanks in advance for your time.

Code: [Select]
<?php

 $idir = "../fleet/";   // Path To Images Directory


if (isset ($_FILES['fupload'])){

//upload the image to tmp directory
$url = $_FILES['fupload']['name'];   // Set $url To Equal The Filename For Later Use 
if ($_FILES['fupload']['type'] == "image/jpg" || $_FILES['fupload']['type'] == "image/jpeg" || $_FILES['fupload']['type'] == "image/pjpeg") { 
$file_ext = strrchr($_FILES['fupload']['name'], '.');   // Get The File Extention In The Format Of , For Instance, .jpg, .gif or .php 
$copy = copy($_FILES['fupload']['tmp_name'], "$idir" . $_FILES['fupload']['name'], $file_ext).rand(10000 , 99999).$file_ext);   // Move Image From Temporary Location To Perm  
}
}
if (isset ($_FILES['fupload2'])){

//upload the image to tmp directory
$url = $_FILES['fupload2']['name'];   // Set $url To Equal The Filename For Later Use 
if ($_FILES['fupload2']['type'] == "image/jpg" || $_FILES['fupload2']['type'] == "image/jpeg" || $_FILES['fupload2']['type'] == "image/pjpeg") { 
$file_ext = strrchr($_FILES['fupload2']['name'], '.');   // Get The File Extention In The Format Of , For Instance, .jpg, .gif or .php 
$copy = copy($_FILES['fupload2']['tmp_name'], "$idir" . $_FILES['fupload2']['name'], $file_ext).rand(10000 , 99999).$file_ext);   // Move Image From Temporary Location To Perm  
}
}
if (isset ($_FILES['fupload3'])){

//upload the image to tmp directory
$url = $_FILES['fupload3']['name'];   // Set $url To Equal The Filename For Later Use 
if ($_FILES['fupload3']['type'] == "image/jpg" || $_FILES['fupload3']['type'] == "image/jpeg" || $_FILES['fupload3']['type'] == "image/pjpeg") { 
$file_ext = strrchr($_FILES['fupload3']['name'], '.');   // Get The File Extention In The Format Of , For Instance, .jpg, .gif or .php 
$copy = copy($_FILES['fupload3']['tmp_name'], "$idir" . $_FILES['fupload3']['name'], $file_ext).rand(10000 , 99999).$file_ext);   // Move Image From Temporary Location To Perm  
}
}
if (isset ($_FILES['fupload4'])){

//upload the image to tmp directory
$url = $_FILES['fupload4']['name'];   // Set $url To Equal The Filename For Later Use 
if ($_FILES['fupload4']['type'] == "image/jpg" || $_FILES['fupload4']['type'] == "image/jpeg" || $_FILES['fupload4']['type'] == "image/pjpeg") { 
$file_ext = strrchr($_FILES['fupload4']['name'], '.');   // Get The File Extention In The Format Of , For Instance, .jpg, .gif or .php 
$copy = copy($_FILES['fupload4']['tmp_name'], "$idir" . $_FILES['fupload4']['name'], $file_ext).rand(10000 , 99999).$file_ext);   // Move Image From Temporary Location To Perm 
}
}

error_reporting (E_ALL ^ E_NOTICE);
    $usr = "user";
    $pwd = "pass";
    $db = "db";
    $host = "host";

    # connect to database
    $cid = mysql_connect($host,$usr,$pwd);
    if (!$cid) { echo("ERROR: " . mysql_error() . "\n");    }

    if ($_POST['submit']) {

$fleetmake = mysql_real_escape_string($_POST['fleetmake']);
$fleetmodel = mysql_real_escape_string($_POST['fleetmodel']);
$fleetyear = mysql_real_escape_string($_POST['fleetyear']);
$fleetberth = mysql_real_escape_string($_POST['fleetberth']);
$fleetlength = mysql_real_escape_string($_POST['fleetlength']);
$fleetchassis = mysql_real_escape_string($_POST['fleetchassis']);
$fleetengine = mysql_real_escape_string($_POST['fleetengine']);
$fleetlayout = mysql_real_escape_string($_POST['fleetlayout']);
$fleettype = mysql_real_escape_string($_POST['fleettype']);
$fleetcomments = mysql_real_escape_string($_POST['fleetcomments']);
$pricelow = mysql_real_escape_string($_POST['pricelow']);
$pricemid = mysql_real_escape_string($_POST['pricemid']);
$pricehigh = mysql_real_escape_string($_POST['pricehigh']);
$fleetlocation = mysql_real_escape_string($_POST['fleetlocation']);
$fleetimage1 = mysql_real_escape_string("$idir" . $_FILES['fupload']['name']);
$fleetimage2 = mysql_real_escape_string("$idir" . $_FILES['fupload2']['name']);
$fleetimage3 = mysql_real_escape_string("$idir" . $_FILES['fupload3']['name']);
$fleetimage4 = mysql_real_escape_string("$idir" . $_FILES['fupload4']['name']);
$fleetadded = date("F j, Y, g:i a");
$fleetof = $account;
$searchtags = "$fleetmake $fleetmodel $fleetberth berth motorhome for hire year $fleetyear $fleetmodel $fleetmake $fleetchassis motorhome $fleetmake $fleetmodel $fleetchassis $fleetmake $fleetchassis $fleettype $fleetlayout $fleetmake motorhome $fleetmodel motorhome $fleetberth berth motorhome $fleetmake $fleetberth berth motorhome $fleetmake motorhomes $fleetmake motor home $fleetmake motor homes $fleetmodel motorhomes $fleetlocation motorhome hire motorhome hire in $fleetlocaiton $fleetmake $fleetlocation $fleetmake $fleetmodel $fleetlocation";

        $SQL = " INSERT INTO fleet ";
        $SQL .= " (fleetmake, fleetmodel, fleetyear, fleetberth, fleetlength, fleetchassis, fleetengine, fleetlayout, fleettype, fleetcomments, pricelow, pricemid, pricehigh, fleetlocation, fleetimage1, fleetimage2, fleetimage3, fleetimage4, fleetadded, fleetof, searchtags) VALUES ";
        $SQL .= " ('$fleetmake', '$fleetmodel', '$fleetyear', '$fleetberth', '$fleetlength', '$fleetchassis', '$fleetengine', '$fleetlayout', '$fleettype', '$fleetcomments', '$pricelow', '$pricemid', '$pricehigh', '$fleetlocation', '$fleetimage1', '$fleetimage2', '$fleetimage3', '$fleetimage4', '$fleetadded', '$fleetof', '$searchtags') ";

        
        $result = mysql_db_query($db,$SQL,$cid);
      $last=mysql_insert_id();


        
        if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n");    }

header("location:fleet_add_confirm.php?last=$last");
exit();

    }
?>

Hi all,
I'm trying to get a search box and a checkbox to both work at the same time. I have two versions of this code, when I use the first one my checkbox works like it should, filtering out all records with product_type = 3, but the search bar no longer works as it should, filtering things out of three fields defined elsewhere. The bottom code has the search bar working but doesnt incorporate the checkbox as a filter. Thanks for any help!

Checkbox works:
Code: [Select]
$where_filter = "";
     if($where != "*"){
     foreach($search_map as $search_name){
        $where_filter .=" $op $search_name $not REGEXP '$where'";
     }
    $where_filter = substr($where_filter, 5)." AND ";
     }
     if ($exclude == "exclude"){
       $where_filter .= "product_type!='3'";
     $q->addWhere("($where_filter)");
     $q->addOrder('product_id');
     }
Search works:
Code: [Select]
$where_filter = " ";
    foreach($search_map as $search_name)
        $where_filter .=" $op $search_name $not REGEXP '$where'";
    $where_filter = substr($where_filter, 5);

    if($where != "*")
       $q->addWhere("($where_filter)");
    $q->addOrder('product_id');

Hi all, I'm trying to set up a situation where a function loops through a multidimensional array and echos an html block for each item in the $skus['skunum'] array and also increments $i each time . ( Each is a product on the site)   
The catch is that I'm trying to have a function within that one that goes through the $skus['sizes'] and echoes an option if the substring (shirt size) exists.

The idea being that I can manage products by adding 4 elements, Skunum, name, price and size.

And well, I'm failing miserably. 

At this point it won't even work because of the variable scope, I'm getting Notice: Undefined variable: skus
from the functions, but am not sure of the right way to get that information.

Am I going about doing this entirely wrong or am I on the right track?

Code: [Select]
<?php $BANDNAME="Apocalypse"; 
$BANDCAPS="APOCALYPSE";
$BANDLOWER="apocalypse";
$SKUCAPS="FGD";
$skus = array
  (
  "skunum"=>array
  (
  "101",
  "102",
  "103", 
  "104",
  "105", 
  "106", 
  "107", 
  "108", 
  "109", 
  "110", 
  "111", 
  "112" 
  ),
  "name"=>array
  (
  "RIDDICK /TSHIRT",
  "MAFIA / TSHIRT",
  "ORACLES / TSHIRT", 
  "AGONY / TSHIRT",
  "BLOODY VIOLINIST / TSHIRT",
  "THE VIOLATION / TSHIRT",
  "AGONY-TOUR DATES / TSHIRT",
  "BAND PHOTO / TSHIRT",
  "SILVER AGONY LOGO / TSHIRT",
  "PHOENIX-TOUR DATES / TSHIRT",
  "PHOENIX / TSHIRT",
  "BLOODY VIOLINIST / ZIP HOOD"
  ),
  "price"=>array
  (
  "15.95",
  "15.95",
  "15.95", 
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "15.95",
  "42.95"
  ),  
  "sizes"=>array
  (
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X",
  "S, M, L, 1X, 2X, 3X, 4X"
  )
  
  );
 
function makeProducts() {
 //Products Sizes
 $sizes = $skus['sizes'][$i];
 $S="S";$M="M";$L="L";$XL="1";$XXL="2";$XXXL="3";$XXXXL="4";

$small = strpos($sizes,$S);
$medium = strpos($sizes,$M);
$large = strpos($sizes,$L);
$xlarge = strpos($sizes,$XL);
$xxlarge = strpos($sizes,$XXL);
$xxxlarge = strpos($sizes,$XXXL);
$xxxxlarge = strpos($sizes,$XXXXL);

function sizeOptions () {
if($small === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'S">S</OPTION>';
}
if($medium === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'M">M</OPTION>';
}
if($large === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'L">L</OPTION>';
}
if($xlarge === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'X">XL</OPTION>';
}
if($xxlarge === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XX">XXL</OPTION>';
}
if($xxxlarge === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XXX">XXXL</OPTION>';
}
if($xxxxxlarge === true) {
 echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XXXX">XXXXL</OPTION>';
}
}
 
foreach ( $skus['skunum'] as $value){ 
  
   
  

   echo '<!-- PRODUCT BEGIN -->
  <li class="product" >
<a href="product_files/large/'.$SKUCAPS.$skus['skunum'][$i].'jpg" rel="lightbox"><img src="product_files/'.$SKUCAPS.$skus['skunum'][$i].'.png"></a><br>
                            <strong>'.$skus['name'][$i].'</strong><br>('.$SKUCAPS.$skus['skunum'][$i].')<br>$'.$skus['price'][$i].'<br>
                            <form name="'.$SKUCAPS.$skus['skunum'][$i].'" method="GET" target="_blank" action="http://www.jsrdirect.com/cgi-bin/Make-a-Store.cgi">
                            <input type="hidden" name="band" value="'.$BANDCAPS.'"> <input type="hidden" name="back" value="http://www.jsrdirect.com/bands/'.$BANDLOWER.'/index.html">
                            <strong>Qty:</strong>
                            <input type="text" name="quantity" size="1" value="1" >
                            <strong>Size:</strong>&nbsp; 
                            <SELECT name="item">'
.sizeOptions();
'</SELECT>
                            <br><br>
                            <input type="image" src="images/addtocart.png" value="Add To Cart">
                            </form>
                        </li>
                <!-- Product End -->';
   }
  
} // End Function

?>

I faced some problem or a message that out when i working on my admin/index.php file that i do it from dreamweaver and display it at firefox but that result showing me Antiphishing Filter and Antimalware Filter things at my admin/index.php page.. Here the screenshot of it.. it only appear at the admin/index.php.. and it didnt appear at the index.php since i have 2 users type that are student and the admin/index.php is for admin access..    

I am trying to wrap my head around the best approach to accomplish this.   I am trying to come up with a random schedule for a full 24 hour day with random time periods ranges including breaks. The only constants will be the minimum time and maximum time of the events and the minimum and maximum time of the breaks between each event.   for example There are three teams Team A Team B Team C   Each event will last either a minimum of 7 minutes to a maximum of 38 minutes The breaks will last a minimum of 30 seconds to a maximum of 5 minutes.   so the events need to be generated randomly with a break period following each event and the timelines are different for each team with the current event time left going to  a timer on the page   I think I have the part to generate the random blocks figured out by using 

<!DOCTYPE html>
<html>
<body>
<?php
function eventRange($min, $max, $blocks) {
    $events = range($min, $max);
    shuffle($events);    
    return array_slice($events, 0, $blocks);
    
}

function breakRange($min, $max, $blocks) {
    $breaks = range($min, $max, 0.1);
    shuffle($breaks);    
    return array_slice($breaks, 0, $blocks);
    
}
echo"<pre>";
print_r( eventRange(7,38,32) );
echo"</pre>";

echo"<pre>";
print_r( breakRange(.5,5,32) );
echo"</pre>";

?>
</body>
</html>

bur is there a way to make it fill a full 24 hour period and then a way to determine which block to display based on the current time when either team is viewing the page.   Sounds totally confusing to me as I try to explain it so I hope what Im asking makes sense. Thanks for any guidance..          

I am have a query with a limit of 3 i want it to echo the first two in one li class and the 3 in another li class. This is what i have, but i know the logic is not right, but i cant figure it out

Code: [Select]
            </div>
 <?php 

 echo "<ul class='services-list'>";
 //echo "<li class='bubble'>";
 $i = 1;
 foreach ($rows_class as $record_class ){
 ?>
<li class="bubble"><a href="viewclass.php?class_id=<?php echo base64_encode($record_class[class_id]) ?>" /><h6 class="title"><img src="./images/services/picture-services.png" class="picture" alt="logo" /><? echo $record_class[class_title]; ?></h6></a><p><?php $string = $record_class['description'];  echo substr(strip_tags($string), 0, 200); ?></p>
               
               
               
<?php if( $i % 2 === 0 && $record_class !== end($rows_class) ) {
 echo "</li>\n<li class='bubble last'>\n";?>

 
 <?php
  } elseif ( $record_class === end($rows_class) ) {
      echo "</li>\n ";
   }
   $i++;
}
                    
 
  ?>
      </ul> 

I've got query.

Hi All

I am using the below code to display users registered on my site:

Code: [Select]
<div class="profilbox" id="apDiv11"><div></div>
<div align="center">Registered Users</div>
<div class="text_area"><?php

//to display image from source - registerd users
$dir = "profpics";

echo '<table>';
$result = mysql_query("SELECT * FROM users order by id");
while ($row = mysql_fetch_assoc($result)) {
    echo "<tr><td><img src=\"$dir/{$row['prof_pic']}\" width='40' height='40'>{$row['username']}</td></tr>";
}
//close out table
echo '</table>';
?></div>

</div>
Could anybody tell me how i can limit this to 3 random results? I then plan adding a link to 'see all'

Howdy,

The following code wil geenrate a dynamic pull-down list based on column values.

Can someone help me tweak it so that is will NOT display a duplicate record value.  That is, if the sponsors values in the table were Hart, Michaels, Michaels, Morella   ...it would only display Hart, Michaels, Morella in the pull-down menu.

<form name="form0">
<? $result = @mysql_query("select distinct sponsor from table ORDER BY sponsor ASC");
if (mysql_num_rows($result) > 0) {
  print "<select name=\"link\">"; ?>
  <option <?php if(empty($_GET['sponsor'])){ echo "selected=\"selected\""; } ?> value="<? echo "$page_name" ?>">SELECT A SPONSOR</option>
  <? while ($row = mysql_fetch_array($result)) {
    print "<option ";
    if($_GET['sponsor'] ==   $row['sponsor']  ){ echo "selected=\"selected\""; }
    print " value=\"index?sponsor=" . $row['sponsor'] . "\">" . $row['sponsor'] . "</option>\n";
  }
  print "</select>";
} 
?>
</form>

Thank you.

~Wayne

Hi there i have 4 fields in a record and 3 records in a table that i need to add up.

Heres what they look like when outputted: 0024  0103  1126

Each of the fields that need to be added are called: Class1, Class2, Class3, Class4

So i want to add each number in those fields with the result of the records so above would look like:

1, 2, 4, 13

Would i need to put them in an array of somekind??

Code: [Select]
$colname_resultp = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_resultp = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_resultp = sprintf("SELECT Class1, Class2, Class3, Class4 FROM planet WHERE PlayerName = %s", GetSQLValueString($colname_resultp, "text"));
$resultp = mysql_query($query_resultp, $swb) or die(mysql_error());
$row_resultp = mysql_fetch_assoc($resultp);
$totalRows_resultp = mysql_num_rows($resultp);

<?php do { ?>
  <?php 
echo $row_resultp['Class1'];
echo $row_resultp['Class2'];
echo $row_resultp['Class3'];
echo $row_resultp['Class4']; ?>

<?php } while ($row_resultp = mysql_fetch_assoc($resultp)); 
mysql_free_result($resultp);
?>

If you could please, please help that would be great as im finding this a real headache at the moment :(

Thank you

Tom

Hi all

Complete noob here.....

What I have to do is create a new database every year, but I can't just import last years data completely, only records when needed.

I can do it myself in PHPMyAdmin, but I don't want my employees touching mysql directly.

What I am trying to do is write a php script that will serach for a reocrd in last years database and if it exists insert it into the new database if it doesn't exists bring up a form so it can be entered.

Any help would be greatly appreciated.


Thanx
ZZ

Hello there,

I have made a ban form on my website. It is all going good until I open phpmyadmin. There is two records from one submission. Usually the second record has some missing information. There should not be a duplicate and I do not understand why it is happening. If anybody could explain what is causing this would be great.

Here is the page.

<?php
session_start();
require_once 'database.php';
if(isset($_SESSION['mod']))
 {
     $userid = $_SESSION['user'];
     if(isset($_GET['action']) && strcasecmp($_GET['action'], "file") == 0) // checks to see if form is submitted
     { 
         $username = $_POST['user'];
         $time = $_POST['time'];
         $reason = $_POST['reason'];
         $u_time = date("U");
         $r_time = date("m-j-Y g:i A");
         if($time == "00")
         { // if the time is a permaban
             $sql=mysql_query("SELECT * FROM user WHERE username='$username'") or die("Error 1");
             $data=mysql_query($sql);
             $user_ip = $data['last_ip'];
            if ($user_ip != 127.0.01)
             { // admin stuff ;)
                 $p_ban=mysql_query("INSERT INTO ip_ban (ip,real_time,unix_time,days_left,reason) VALUES ('$user_ip','$r_time','$u_time','99999999999','$reason')") or die("Error 2");
                 echo 'The user '.$username.' has been banned.'; 
             }else{ // if it is an admin
            echo 'You cannot ban that user.';
             }
         }else{ // not a perma ban
         if($username != "admin") // admin stuff
         {
             $temp_ban=mysql_query("INSERT INTO blacklist (email,reason,end_date,appeal,unixtime) VALUES ('$username','$reason','$time','No','$u_time')") or die("Error 3");
             echo 'The user '.$username.' has been banned.';
         }else{
         echo 'You cannot ban that user.';
         }
         }
     }else{
     $user_ban = $_GET['user'];
     if(isset($user_ban))
     {
     ?>
     <form name="file_ban" method="post" action="?action=file">
     Username: <input type="text" name="user" value="<?php echo $user_ban; ?>"><br />
     Length of Ban: <select name="time">
     <option value="1">1 Day</option>
     <option value="3">3 Days</option>
     <option value="5">5 Day</option>
     <option value="7">1 Week</option>
     <option value="15">15 Days</option>
     <option value="30">1 Month</option>
     <option value="90">3 Months</option>
     <option value="99999999999">&#8734; Infinity (Permaban)</option>
     <option value="00">IP Ban (Does not expire)</option>
     </select><br />
     Reason: <br />
     <textarea name="reason" cols="50" row="4"></textarea><br />
     <input type="submit" value="Ban">
     <?php
 
 
     }else{
 
 
     }
 
 
 
 
     }
 }else{   // If session is not set
 header("Location: index.php");
 }
?>


If you need any explanation of what anything does, just please ask.

Thank you!

Hi, can someone help me understand why it 's only printing the first record in the database ?

Code: [Select]

<?php
require_once("functions.php");
?>
<!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=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
DatabaseConnection();
mysql_select_db("auntievics");
$query= "SELECT product_id FROM treats";
$result_set= mysql_query($query);
if ($result_set){
$products= mysql_fetch_row($result_set);
foreach ($products as $value){
print $value;
}
print "<br />";
}
//print_r(mysql_fetch_row($result_set));
?>
</body>
</html>

Hey again guys,

i am building a site admin page and i want to do a php script with will show the heading and the date of my news database into a table, and on the right or left side of each row i want to put 2 small icons one which will remove the specific record and one which will open a new small window with the whole record viewing.

any idears?