PHP - If Anyone Could Give Me Any Suggestions On This

In a Switch statement, can you give the Default: a specific name, maybe like this...


switch ($resultsCode){
// Missing Primary Key.
case 'COMMENT_MISSING_KEYS_2050':
echo '<h1>System Error</h1>';
echo '<p>A Fatal Error has occurred.  Please contact the System Administrator. (2050)</p>';
break;

default 'DEFAULT_CATCHALL_ERROR_CODE_9999':
echo '<p>You have reached the catch-all error code... (9999)</p>';
break;



Debbie

what i want is to upload my informations to database when i press the submit button.
but if any field is empty it should show a text that all fields are required but in the same page(up or down to the form).
However with this code my database is not working>informations are not send to the database.
why?Any sggesstions?

Code: [Select]
<?php 
// Start a session for error reporting
session_start();
//Connect to database
require("includes/connect_to_mysql.php");

//check if the button is pressed
if(isset($_POST['submit'])){
// Check to see if the type of file uploaded is a valid image type
function is_valid_type($file)
{
// This is an array that holds all the valid image MIME types
$valid_types = array("image/jpg", "image/jpeg", "image/bmp", "image/gif", "image/png");


if (in_array($file['type'], $valid_types))
return 1;
    return 0;
}
// This variable is the path to the image folder where all the images are going to be stored
// Note that there is a trailing forward slash
$TARGET_PATH = "upload_form_images/";

// Get our POSTed variables
$name = $_POST['name'];
$surname = $_POST['surname'];
$email = $_POST['email'];
$city = $_POST['city'];
$details = $_POST['details'];
$price = $_POST['price'];
$image = $_FILES['image'];

// Sanitize our inputs
$name = mysql_real_escape_string($name);
$surname = mysql_real_escape_string($surname);
$email = mysql_real_escape_string($email);
$city = mysql_real_escape_string($city);
$details = mysql_real_escape_string($details);
$price = mysql_real_escape_string($price);
$image['name'] = mysql_real_escape_string($image['name']);

// Build our target path full string.  This is where the file will be moved do
// i.e.  images/picture.jpg
$TARGET_PATH .= $image['name'];

// Make sure all the fields from the form have inputs
if ( $name == "" || $surname == "" || $email == "" || $city == ""  || $details == "" || $price == ""|| $image['name'] == "" )
{
$_SESSION['error'] = "Te gjithe fushat duhet plotesuar";
echo "Te gjithe fushat duhet plotesuar";
header("Location: upload_form.php");
exit;
}

// Check to make sure that our file is actually an image
// You check the file type instead of the extension because the extension can easily be faked
if (!is_valid_type($image))
{
$_SESSION['error'] = "Fotografite duhet te jene te formateve jpg, jpeg, bmp, gif, ose png";
header("Location: upload_form.php");
exit;
}

// Here we check to see if a file with that name already exists
// You could get past filename problems by appending a timestamp to the filename and then continuing
if (file_exists($TARGET_PATH))
{
$_SESSION['error'] = "Ju lutem nderroni emrin e fotos.";
header("Location: upload_form.php");
exit;
}

/*
// See if that product name is an identical match to another product in the system
$sql = mysql_query("SELECT id FROM upload_form WHERE name='$name' LIMIT 1");
$productMatch = mysql_num_rows($sql); // count the output amount
    if ($productMatch > 0) {
$_SESSION['error'] = 'Ju lutem nderroni emrin sepse egziston ne databaze';
header("Location: upload_form.php");
exit();
}
*/

// Lets attempt to move the file from its temporary directory to its new home
if (move_uploaded_file($image['tmp_name'], $TARGET_PATH))
{
// NOTE: This is where a lot of people make mistakes.
// We are *not* putting the image into the database; we are putting a reference to the file's location on the server
$sql = "insert into people (name, surname, email, city, details, price, filename) values ('$name', '$surname', '$email', '$city', '$details',  '$price', '" . $image['name'] . "')";
$result = mysql_query($sql) or die ("Futja e te dhenave ne databaze DESHTOI: " . mysql_error());
echo "Shtimi i te dhenave u krye me SUKSES";
exit;
}
else
{
// A common cause of file moving failures is because of bad permissions on the directory attempting to be written to
// Make sure you chmod the directory to be writeable
$_SESSION['error'] = "Shtimi i te dhenave NUK u krye me Sukses.  Ju lutem provoni perseri";
header("Location: upload_form.php");
exit;
}
}
?>

<!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>Qiraja.com</title>
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<!--[if lte IE 6]><link rel="stylesheet" href="css/ie6.css" type="text/css" media="all" /><![endif]-->
<!--[if IE]><style type="text/css" media="screen"> #navigation ul li a em { top:32px; } </style><![endif]-->


</head>
<body>

<!-- Header -->
<div id="header">
<div class="shell">

<!-- Logo -->
<h1 id="logo"><a href="#">Company Name</a></h1>
<!-- End Logo -->

<!-- Navigation -->
<div id="navigation">

<ul>
    <li><a href="#">Prishtine<span><em></em></span></a></li>
    <li><a href="#">Prizren<span><em></em></span></a></li>
<li><a href="#">Ferizaj<span><em></em></span></a></li>
    <li><a href="#">Peje<span><em></em></span></a></li>
<li><a href="#">Mitrovice<span><em></em></span></a></li>
<li><a href="#">Gjilan<span><em></em></span></a></li>
    <li class="last"><a href="#">Gjakove<span><em></em></span></a></li>

</ul>
</div> 
</div>
</div>


<div id="slider">
<div class="shell">

<!-- Slides -->
<div class="slides">
<ul>
<!-- Slide -->
    <li>
               
               
<form action="upload_form.php" enctype="multipart/form-data" name="myForm" id="myform" method="post">
    <table width="90%" border="0" cellspacing="0" cellpadding="6">
      <tr>
        <td width="20%" align="center">Name</td>
        <td width="80%"><label>
          <input name="name" type="text" id="name" size="25" />
        </label></td>
      </tr>
      <tr>
        <td align="center">Surname</td>
        <td><label>
          <input name="surname" type="text" id="surname" size="25" />
        </label></td>
      </tr>
       <tr>
        <td align="center">Email</td>
        <td><label>
          <input name="email" type="text" id="email" size="25" />
        </label></td>
      </tr>
      <tr>
        <td align="center">City</td>
        <td><select name="city" id="city">
        <option value=""></option>
          <option value="Prishtine">Prishtine</option>
          <option value="Prizren">Prizren</option>
          <option value="Ferizaj">Ferizaj</option>
          <option value="Peje">Peje</option>
          <option value="Mitrovice">Mitrovice</option>
          <option value="Gjilan">Gjilan</option>
          <option value="Gjakove">Gjakove</option>
          </select></td>
      </tr>
      <tr>
        <td align="center">Cmimi</td>
        <td><label>
          <input name="price" type="text" id="price" size="10" />
          &euro;
        </label></td>
      </tr>
      <tr>
        <td align="center">Fotografite</td>
        <td><label>
          <input type="file" name="image" id="image" />
        </label></td>
      </tr>     
      <tr>
        <td>&nbsp;</td>
        <td align="right"><label>
        <input type="hidden" name="MAX_FILE_SIZE" value="100000" />
          <input type="submit" name="submit" id="submit" value="Shto te dhenat" />
        </label></td>
      </tr>
    </table>
    </form>

    </li>
    <!-- End Slide -->
   
    <!-- Slide -->
    <li>
    <div class="slide-info">
    <h2><span>Reklamo</span> Shtepine</h2>
    <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam arcu ligula, faucibus eu imperdiet eu, bibendum sit amet augue. Sed turpis sem, interdum sit amet egestas a, mattis non libero. Suspendisse tristique nisi sed justo accumsan vel mattis nulla fermentum. Etiam varius est id mi fermentum aliquam.</p>
    <p>Quisque quis vestibulum turpis. Sed venenatis ipsum laoreet elit pulvinar vitae pharetra massa dignissim. Curabitur ligula sapien, auctor ut porttitor a, ultricies lobortis dui. Suspendisse lacinia tellus a diam rutrum rhoncus. </p>

<a href="#" class="more">read more</a></p>
    </div>
    <span class="slide-image image1"></span>
    </li>
    <!-- End Slide -->
   
    <!-- Slide -->
    <li>
    <div class="slide-info">
    <h2><span>Reklamo</span> Apartmanin</h2>
    <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam arcu ligula, faucibus eu imperdiet eu, bibendum sit amet augue. Sed turpis sem, interdum sit amet egestas a, mattis non libero. Suspendisse tristique nisi sed justo accumsan vel mattis nulla fermentum. Etiam varius est id mi fermentum aliquam.</p>
    <p>Quisque quis vestibulum turpis. Sed venenatis ipsum laoreet elit pulvinar vitae pharetra massa dignissim. Curabitur ligula sapien, auctor ut porttitor a, ultricies lobortis dui. Suspendisse lacinia tellus a diam rutrum rhoncus. </p>

<a href="#" class="more">read more</a></p>
    </div>
    <span class="slide-image image1"></span>
    </li>
<!-- End Slide -->
   
    </ul>
</div>
<!-- End Slides -->

</div>
</div>
<!-- End Slider -->

<!-- Slider Nav -->
<div id="slider-navigation">
<div class="shell">
<ul>
    <li><a href="index.php" class="active">Kthehu ne fillim<strong>Home</strong><em class="ico1"></em></a></li>
    <li><a href="upload_form.php">Shto<strong>Upload</strong><em class="ico2"></em></a></li>
    <li class="last"><a href="contact_form.php">Kontakti<strong>Contact</strong><em class="ico3"></em></a></li>
</ul>
</div>
</div>
<!-- End Slider Nav -->

<!-- Main -->
<div id="main">
<div class="shell">

<!-- Cols -->
<div class="cols">
<div class="cl">&nbsp;</div>

<!-- Col -->
<div class="col">
<h3>Sed Turpis sem</h3>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam arcu ligula, faucibus eu imperdiet eu, bibendum sit amet augue. Sed turpis sem, interdum sit amet egestas a, mattis non libero.<br /><a href="#" class="more">read more</a></p>
<p>Suspendisse tristique nisi sed justo accumsan vel mattis nulla fermentum. Etiam varius est id mi fermentum aliquam. <br /><a href="#" class="more">read more</a></p>
</div>
<!-- End Col -->

<!-- Col -->
<div class="col">
<h3>Ligula amet augue</h3>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam arcu ligula, faucibus eu imperdiet eu, bibendum sit amet augue. <br /><a href="#" class="more">read more</a></p>
<p>Sed turpis sem, interdum sit amet egestas a, mattis non libero. Suspendisse tristique nisi sed justo accumsan vel mattis nulla fermentum. Etiam varius est id mi fermentum aliquam. <br /><a href="#" class="more">read more</a></p>
</div>
<!-- End Col -->

<!-- Col -->
<div class="col col-last">
<h3>Ligula amet augue</h3>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam arcu ligula, faucibus eu imperdiet eu, bibendum sit amet augue. <br /><a href="#" class="more">read more</a></p>
<p>Sed turpis sem, interdum sit amet egestas a, mattis non libero. Suspendisse tristique nisi sed justo accumsan vel mattis nulla fermentum. Etiam varius est id mi fermentum aliquam. <br /><a href="#" class="more">read more</a></p>
</div>
<!-- End Col -->

<div class="cl">&nbsp;</div>
</div>
<!-- End Cols -->

</div>
</div>


</body>
</html>

Hi

I was playing with a poll, but for some reasons it won't email me(the bottom most part). Where did I go wrong?

Also any suggestions on how to improve this?

Thanks your the best guys!


<?php
include('config.php');
$name = strip_tags($_POST['name']);
$email = $_POST['email'];
$qst_id=strip_tags($_POST['qst_id']);
//if no ajax
$opt = strip_tags($_POST['opt']);
$s_id = $_SERVER['REMOTE_ADDR'];

//validate email 
if (!preg_match('/^.+@.+\..{2,3}$/',$email));
{
$email = 'email was blocked';
}
if (strlen($name) >= 50)
{
$name = 'name was blocked';
}


if ($opt == '')
{
$vote ="no";
}
elseif (($opt=='Yes') || ($opt=='No'))
{
$qt=mysql_query("insert into plus_poll_ans(s_id,qst_id,opt) values('".$s_id."','".$qst_id."','".$opt."')");
}
else
{
$vote = "no";
}

echo "<font size='2' face='Verdana' color='#000000' style='font-size:1.2em;'> Declaration of Faith</font>";

$qst_id=1; // change this to change the poll 

/* Find out the question first */
$fg=mysql_query("select qst from plus_poll where qst_id='".$qst_id."'");
$row=mysql_fetch_object($fg);

echo "<br><b><br>$row->qst</b><br>"; // display the question
/* for percentage calculation we will find out the total number
 of answers ( options submitted ) given by the visitors */
$rt=mysql_num_rows(mysql_query("select ans_id from plus_poll_ans where qst_id='".$qst_id."'"));


/* Find out the answers and display the graph */
$query="select count(*) as no,qst,plus_poll_ans.opt from plus_poll,plus_poll_ans where plus_poll.qst_id=plus_poll_ans.qst_id and plus_poll.qst_id='".$qst_id."' group by opt desc ";
$rs=mysql_query($query);

//count the answers by yes or no
$count= "SELECT opt, count(opt) FROM plus_poll_ans GROUP BY opt desc"; 
$result = mysql_query($count) or die(mysql_error());

//separate the results
while($row = mysql_fetch_array($result)){
$total_opt[] = $row['count(opt)'];
}

// Print out result
echo "<table cellpadding='0' cellspacing='0' border='0' width='100%' >";

$i = 0;
while($noticia = mysql_fetch_array($rs)){
 echo "<tr>
    <td width='5%' bgcolor='#F1F1F1'>&nbsp;<font size='1' face='Verdana' color='#000000'>$noticia[opt]</font></td>";
$width2=$noticia['no'] *10 ; /// change here the multiplicaiton factor //////////
$ct=($noticia[no]/$rt)*100;
$ct=sprintf ("%01.2f", $ct); // number formating 

echo "    <td width='20%' bgcolor='#F1F1F1'>&nbsp;<font size='1' face='Verdana' color='#000000'>($ct %)</font></td><td width='60%' align='left' bgcolor='#F1F1F1'>&nbsp;<img src='graph.jpg' height=10 width=$width2>";
 echo "</td><td width='15%' align='right'>";
 echo "<font size='1' face='Verdana' color='#000000'>".$total_opt[$i];
 echo " votes";
 echo "</font></td>";
 echo  "</tr>";
 echo "<tr>
    <td  bgcolor='#ffffff' colspan=2>"; 
 echo "</td>";
 echo "</tr>";
 $i=$i+1;
}
echo "<tr><td></td><td></td><td><font size='1' face='Verdana' color='#000000'>Total Votes:</font></td><td align='right'>";
//count the total votes
$count = 'select count(ans_id) from plus_poll_ans';
$count = mysql_query($count);
$count = mysql_fetch_array($count);
$total_count = $count['count(ans_id)'];

echo "<font size='1' face='Verdana' color='#000000'>".$total_count." votes</font>";
echo "</td></tr>";
echo "</table>";
echo "</font>";


if ($vote!='no')
{
//email
$to = 'person1@example.com, person2@example.com';
$subject = 'Someone just made a declaration of faith';
$message = "Someone from the ip address ".$s_id;
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
$headers .= 'From: Vote Detector <website@example.com>'. "\r\n";
if ($name!='')
{
$message = $message." with the name ".$name;
}
if ($email!='')
{
$message = $message." with email ".$email;
}
$message = $message." voted "."yes<br/>";
$message = $message."total number of people who declared their faith: ".$total_count." people<br/>";
$message = $message."with a total of ".$total_opt[0]." people saying yes";
$message = $message." and a total of ".$total_opt[1]." people saying no<br/>";
mail($to, $subject, $message, $headers);
}

?>

Hi,

Hope this is the right place for this...

I have php routines that print itineraries.  For some reason the timestamp (1351378800) returns the same date Sunday 28th October (2012) as the time stamp (1351465200).

$count = 0;
while ($count <= ($nights+1))
              {
              echo date ('l', $startdate1)." (".$startdate1.")";
   echo "<br>";
   echo date ('jS F', $startdate1);
   $startdate1 += 86400;
               
               // more code
              }

Any ideas?

Many thanks,
Peter
 

I am trying to learn PHP basics, and I just cant figure out a way to insert color when certain conditions are met. In my  code below, I want to print out red color on lets say, odd numbers from 20-49.

Appreciate your help big time! 

<?php

    for ($i=20; $i<=49; $i++){        
        echo "$i<br>";  
    } 

?>