Learn VBA & Macros in 1 Week!

PHP - Copy Info In Mysql Db Into Same Db With Different Date Ref

Full Excel VBA Course - Beginner to Expert

Copy Info In Mysql Db Into Same Db With Different Date Ref	View Content

I used to code a long time ago - PHP5.

It is slowly coming back to me but not fast enough...

I need to copy data from a mysql data base and put it back in unchanged with another date reference.

This is a calorie recorder that tracks daily calories - food type, calories, protein, carbs, etc.

I simply want to take each entry in that day, then copy it exactly except changing the date recerence.

If I could say "copy all entires where date = (date) into DB with new date (date), that would do it.

The only thing I can think to do is pull each item out and place it back into the DB with a while statement.

There has to be an easier way...

If that is my only option, I need to figure out how to create a while statement to handle an array to do the job.

Any thoughts?

Thanks for the help!!

David

Full Excel VBA Course - Beginner to Expert

Image Copy Resampled Automatically Rotating Based On Exif Date

Similar Tutorials

View Content

Hi there,
on my yardmaps website, if a user uploads an image taken with an iphone, and the exif data sets orientation to 1, the image is automatically rotated when put through the imagecopyresampled function.

If I take the same image, and strip out the exif data with photoshop (save as for web, no meta data), the image uploads correctly.

Is there any way to force imagecopyresampled to not rotate the image?

Thanks
B

Small Date Of Birth Menu Generator I Wrote -> How To Make Code Copy-able?

Similar Tutorials

View Content

Since I didn't want to type it out myself I wrote a small Date of Birth drop down menu generator.

Now I'm wondering how I can make the code copy-able in a text area?

The script should be inserting all the code ready and finished into a textarea so you can copy and go.

How is it done?

Here's the script:

<?php
echo "<center>";
?>
<form action='' method='POST'>
<input type='submit' name='submit' />
</form>
<?php
$submit = $_POST['submit'];

if ($submit) {

echo "<form action='' method='POST'>";
echo "<select name='month'>";

for ($m = 01; $m <= 12; $m++) {

echo " <option value='" . $m . "'>" . $m . "</option> ";

}

echo "</select>";
echo "<select name='day'>";

for ($d = 01; $d <= 31; $d++) {

echo " <option value='" . $d . "'>" . $d . "</option> ";

}

echo "</select>";
echo "<select name='year'>";

for ($y = 1900; $y <= 2010; $y++) {

echo " <option value='" . $y . "'>" . $y . "</option> ";

}

echo "</select>";
echo "</form>";
echo "</center>";
}

?>

Copy Table To Row In Mysql Using Php

Similar Tutorials

View Content

I have a survey that uses colors. At the moment someone takes the survey I need to capture the values that are in a table called "tbl_colors" and write them to each survey in "tbl_surveys" as a row.

tbl_colors
id, hex_color
1 FFF432
2 CC3399
3 DD3399
and so on to the number 12

tbl_survey
id, timestamp, name, hex01, hex02, hex03, hex04, etc to hex12

I have written code that "works" but I know it is extremely redundant and overloaded and someone could probably do the same thing in less than 10 lines of code. So, I post it here so I can learn from my mistakes.

// Make a MySQL Connection
$query = "SELECT * FROM tbl_colors WHERE id = 1";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color1 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 2";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color2 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 3";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color3 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 4";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color4 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 5";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color5 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 6";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color6 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 7";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color7 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 8";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color8 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 9";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color9 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 10";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color10 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 11";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color11 = $row['hex_color'];
$query = "SELECT * FROM tbl_colors WHERE id = 12";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$color12 = $row['hex_color'];

//echo $color1.$color2.$color3.$color4.$color5.$color6.$color7.$color8.$color9.$color10.$color11.$color12;

mysql_query("INSERT INTO tbl_surveys (hex01, hex02, hex03, hex04, hex05, hex06, hex07, hex08, hex09, hex10, hex11, hex12)
VALUES ('$color1', '$color2', '$color2', '$color3', '$color4', '$color5', '$color6', '$color7', '$color8', '$color9', '$color10', '$color11', '$color12')");

Convert Form Inputs For Date Into A Mysql Date Format

Similar Tutorials

View Content

I have tried a large number of "solutions" to this but everytime I use them I see 0000-00-00 in my date field instead of the date even though I echoed and can see that the date looks correct.

Here's where I'm at:
I have a drop down for the month (1-12) and date fields (1-31) as well as a text input field for the year. Using the POST array, I have combined them into the xxxx-xx-xx format that I am using in my field as a date field in mysql.

<code>
$date_value =$_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
echo $date_value;
</code>

This outputs 2012-5-7 in my test echo but 0000-00-00 in the database.

I have tried unsuccessfully to use in a numberof suggested versions of:
strtotime()
mktime

Any help would be extremely appreciated.
I am aware that I need to validate this data and insure that it is a valid date. That I'm okay with. I would like some help on getting it into the database.

Custom Date Format, To Mysql Date

Similar Tutorials

View Content

Hi there,

I have a string '12/04/1990', that's in the format dd/mm/yyyy.

I'm attempting to convert that string to a Date, and then insert that date into a MySQL DATE field.

The problem is, every time I try to do so, I keep getting values like this in the database: 1970-01-01.

Any ideas?

Much appreciated.

Adding Info Into Mysql

Similar Tutorials

View Content

hello

i am trying to add infomation into the mysql but it always seems to add it a 0 instead of what i am typeing into the form, the form is to add recipies to a users file. these are the scriprts, the fields that arnt showing up is prep and cook

add_recipie.php
<?php
// Start_session, check if user is logged in or not, and connect to the database all in one included file
include_once("scripts/checkuserlog.php");
// Include the class files for auto making links out of full URLs and for Time Ago date formatting
include_once("wi_class_files/autoMakeLinks.php");
include_once ("wi_class_files/agoTimeFormat.php");
// Create the two objects before we can use them below in this script
$activeLinkObject = new autoActiveLink;
$myObject = new convertToAgo;
?>
<?php
// Include this script for random member display on home page
include_once "scripts/homePage_randomMembers.php";
?>
<?php
$sql_blabs = mysql_query("SELECT id, mem_id, the_blab, blab_date FROM blabbing ORDER BY blab_date DESC LIMIT 30");

$blabberDisplayList = ""; // Initialize the variable here

while($row = mysql_fetch_array($sql_blabs)){

$blabid = $row["id"];

$uid = $row["mem_id"];

$the_blab = $row["the_blab"];

$notokinarray = array("fag", "gay", "shit", "fuck", "stupid", "idiot", "asshole", "cunt", "douche");
$okinarray = array("sorcerer", "grey", "shug", "farg", "smart", "awesome guy", "asshole", "cake", "dude");

$the_blab = str_replace($notokinarray, $okinarray, $the_blab);

$the_blab = ($activeLinkObject -> makeActiveLink($the_blab));

$blab_date = $row["blab_date"];

$convertedTime = ($myObject -> convert_datetime($blab_date));
$whenBlab = ($myObject -> makeAgo($convertedTime));

//$blab_date = strftime("%b %d, %Y %I:%M:%S %p", strtotime($blab_date));

// Inner sql query

$sql_mem_data = mysql_query("SELECT id, username, firstname, lastname FROM myMembers WHERE id='$uid' LIMIT 1");

while($row = mysql_fetch_array($sql_mem_data)){

$uid = $row["id"];

$username = $row["username"];

$firstname = $row["firstname"];

if ($firstname != "") {$username = $firstname; } // (I added usernames late in my system, this line is not needed for you)

/////// Mechanism to Display Pic. See if they have uploaded a pic or not //////////////////////////

$ucheck_pic = "members/$uid/image01.jpg";

$udefault_pic = "members/0/image01.jpg";

if (file_exists($ucheck_pic)) {

$blabber_pic = '<div style="overflow:hidden; width:40px; height:40px;"><img src="' . $ucheck_pic . '" width="40px" border="0" /></div>'; // forces picture to be 100px wide and no more

} else {

$blabber_pic = "<img src=\"$udefault_pic\" width=\"40px\" height=\"40px\" border=\"0\" />"; // forces default picture to be 100px wide and no more

}

$blabberDisplayList .= '

<table width="100%" align="center" cellpadding="4" bgcolor="#CCCCCC">
        <tr>
          <td width="7%" bgcolor="#FFFFFF" valign="top"><a href="profile.php?id=' . $uid . '">' . $blabber_pic . '</a>
          </td>
          <td width="93%" bgcolor="#EFEFEF" style="line-height:1.5em;" valign="top"><span class="greenColor textsize10">' . $whenBlab . ' <a href="profile.php?id=' . $uid . '">' . $username . '</a> said: </span><br />
          ' . $the_blab . '</td>
        </tr>
      </table>';

}

}
?>
<!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" />
    <meta name="Description" content="Web Intersect is a deft combination of powerful free open source software for social networking, mixed with insider guidance and tutorials as to how it is made at its core for maximum adaptability. The goal is to give you a free website system that has a network or community integrated into it to allow people to join and interact with your website when you have the need." />
    <meta name="Keywords" content="web intersect, how to build community, build social network, how to build website, learn free online, php and mysql, internet crossroads, directory, friend, business, update, profile, connect, all, website, blog, social network, connecting people, youtube, myspace, facebook, twitter, dynamic, portal, community, technical, expert, professional, personal, find, school, build, join, combine, marketing, optimization, spider, search, engine, seo, script" />
    <title>CookBookers</title>
    <link href="style/main.css" rel="stylesheet" type="text/css" />
    <link rel="icon" href="favicon.ico" type="image/x-icon" />
    <link rel="shortcut icon" href="favicon.ico" type="image/x-icon" />
    <script src="js/jquery-1.4.2.js" type="text/javascript"></script>
<style type="text/css">
#Layer1 {

height:210px;

}
body {

background-color: #3c60a4;
}
.style4 {font-size: 36px}
</style>
</head>
<body>
<p>
  <?php include_once "header_template.php"; ?>
  </head>
  <body
style="margin:0px;">
  <center>
</p>
<p> </p>
<table border="0" align="center" cellpadding="0" cellspacing="0" class="mainBodyTable">
  <tr>
    <td width="124" valign="top">
    <td width="776" colspan="2" align="left" valign="top" style="background-color:#EFEFEF; border:#999 0px; padding:10px;">
<table border="0" cellpadding="6">

  </table>
  <table width="574" border="0">
  <form method="POST" action="include/recipe.php">
    <span class="style4">Add Recipie</span>

    <tr>
      <th width="232" scope="col"> </th>
      <th width="332" scope="col"> </th>
    </tr>
    <tr>
      <td><span style="margin-bottom:5px; color:brown;">Public:</span></td>
      <td><span style="margin-bottom:5px; color:brown;">
        <input name="Pub" value="1" type="checkbox" id="Pub"/>
      </span></td>
    </tr>
    <tr>
      <td><span style="margin-bottom:5px; color:brown;">Title:</span></td>
      <td><span style="margin-bottom:5px; color:brown;">
        <input type="text" name="title" />
      </span></td>
    </tr>
    <tr>
      <td><span style="margin-bottom:5px; color:brown;">Prep time:</span></td>
      <td><span style="margin-bottom:5px; color:brown;">
        <input name="prep" type="text" size="7" maxlength="10" />
    </tr>
    <tr>
      <td><span style="margin-bottom:5px; color:brown;">Cooking time:</span></td>
      <td><span style="margin-bottom:5px; color:brown;">
        <input name="cook" type="text" size="7" maxlength="10" />
    </tr>
    <tr>
      <td><span style="margin-bottom:5px; color:brown;">Makes:</span></td>
      <td><span style="margin-bottom:5px; color:brown;">
         <input type="text" name="make" />
      </span></td>
    </tr>
    <tr>
      <td><span style="margin-bottom:5px; color:brown;">Ingrediants:</span></td>
      <td><span style="margin-bottom:5px; color:brown;">
        <textarea rows="5" name="ingr" cols="40"></textarea>
      </span></td>
    </tr>
    <tr>
      <td><span style="margin-bottom:5px; color:brown;">Method: </span></td>
      <td><span style="margin-bottom:5px; color:brown;">
        <textarea rows="5" name="desc" cols="40"></textarea>
      </span></td>
    </tr>
    <tr>
      <td><span style="margin-bottom:5px; color:brown;">Notes:</span></td>
      <td><span style="margin-bottom:5px; color:brown;">
        <textarea rows="5" name="note" cols="40"></textarea>
      </span></td>
    </tr>

</tr>
  </table>
    </tr>
</table>
            </td>
</tr>
        </table>

<?php include_once "footer_template.php"; ?>
</body>

recipie.php
<?php
//include("session.php");
include("database.php");
@session_start();

$user = $_SESSION['username'];

//die($user);

$Pub=$_POST['Pub'];
$title=$_POST['title'];

$prep=$_POST['prep'];
    $cook=$_POST['cook'];
    $make=$_POST['make'];
    $ingr=$_POST['ingr'];
    $desc=$_POST['desc'];
    $note=$_POST['note'];
    //if($user=="Guest"||$user==""){
    //header("Location: ../index.php");
    //}
    //else{
    $database->AddRecipe($user,$Pub,$title,$prep,$cook,$make,$ingr,$desc,$note);
    header("Location: ../recipe_added.php");
    //}
?>

database.php
<?
/**
* Database.php
*
* The Database class is meant to simplify the task of accessing
* information from the website's database.
*
* Written by: Jpmaster77 a.k.a. The Grandmaster of C++ (GMC)
* Last Updated: August 17, 2004
*/
include("constants.php");

class MySQLDB
{
   var $connection;         //The MySQL database connection
   var $num_active_users;   //Number of active users viewing site
   var $num_active_guests;  //Number of active guests viewing site
   var $num_members;        //Number of signed-up users
   /* Note: call getNumMembers() to access $num_members! */

   /* Class constructor */
   function MySQLDB(){
      /* Make connection to database */
      $this->connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die(mysql_error());
      mysql_select_db(DB_NAME, $this->connection) or die(mysql_error());

      /**
       * Only query database to find out number of members
       * when getNumMembers() is called for the first time,
       * until then, default value set.
       */
      $this->num_members = -1;

      if(TRACK_VISITORS){
         /* Calculate number of users at site */
         $this->calcNumActiveUsers();

         /* Calculate number of guests at site */
         $this->calcNumActiveGuests();
      }
   }

   /**
    * confirmUserPass - Checks whether or not the given
    * username is in the database, if so it checks if the
    * given password is the same password in the database
    * for that user. If the user doesn't exist or if the
    * passwords don't match up, it returns an error code
    * (1 or 2). On success it returns 0.
    */
   function confirmUserPass($username, $password){
      /* Add slashes if necessary (for query) */
      if(!get_magic_quotes_gpc()) {

      $username = addslashes($username);
      }

      /* Verify that user is in database */
      $q = "SELECT password FROM ".TBL_USERS." WHERE username = '$username'";
      $result = mysql_query($q, $this->connection);
      if(!$result || (mysql_numrows($result) < 1)){
         return 1; //Indicates username failure
      }

      /* Retrieve password from result, strip slashes */
      $dbarray = mysql_fetch_array($result);
      $dbarray['password'] = stripslashes($dbarray['password']);
      $password = stripslashes($password);

      /* Validate that password is correct */
      if($password == $dbarray['password']){
         return 0; //Success! Username and password confirmed
      }
      else{
         return 2; //Indicates password failure
      }
   }

   /**
    * confirmUserID - Checks whether or not the given
    * username is in the database, if so it checks if the
    * given userid is the same userid in the database
    * for that user. If the user doesn't exist or if the
    * userids don't match up, it returns an error code
    * (1 or 2). On success it returns 0.
    */
   function confirmUserID($username, $userid){
      /* Add slashes if necessary (for query) */
      if(!get_magic_quotes_gpc()) {

      $username = addslashes($username);
      }

      /* Verify that user is in database */
      $q = "SELECT userid FROM ".TBL_USERS." WHERE username = '$username'";
      $result = mysql_query($q, $this->connection);
      if(!$result || (mysql_numrows($result) < 1)){
         return 1; //Indicates username failure
      }

      /* Retrieve userid from result, strip slashes */
      $dbarray = mysql_fetch_array($result);
      $dbarray['userid'] = stripslashes($dbarray['userid']);
      $userid = stripslashes($userid);

      /* Validate that userid is correct */
      if($userid == $dbarray['userid']){
         return 0; //Success! Username and userid confirmed
      }
      else{
         return 2; //Indicates userid invalid
      }
   }

   /**
    * usernameTaken - Returns true if the username has
    * been taken by another user, false otherwise.
    */
   function usernameTaken($username){
      if(!get_magic_quotes_gpc()){
         $username = addslashes($username);
      }
      $q = "SELECT username FROM ".TBL_USERS." WHERE username = '$username'";
      $result = mysql_query($q, $this->connection);
      return (mysql_numrows($result) > 0);
   }
   function showRecipees($username){
      $q = "SELECT * FROM recipies WHERE user = '$username'";
      $result = mysql_query($q, $this->connection);
      /* Error occurred, return given name by default */
      if(!$result || (mysql_numrows($result) < 1)){
         return NULL;
      }
      /* Return result array */
        $rows;
        $i=0;
      while($row=mysql_fetch_row($result))
      {
             $rows[$i]=$row;
             $i++;
      }
      return $rows;
   }

   function showRecipees1(){
      $q = "SELECT * FROM recipies";
      $result = mysql_query($q, $this->connection);
      /* Error occurred, return given name by default */
      if(!$result || (mysql_numrows($result) < 1)){
         return NULL;
      }
      /* Return result array */
        $rows;
        $i=0;
      while($row=mysql_fetch_row($result))
      {
             $rows[$i]=$row;
             $i++;
      }
      return $rows;
   }

   /**
    * usernameBanned - Returns true if the username has
    * been banned by the administrator.
    */
   function usernameBanned($username){
      if(!get_magic_quotes_gpc()){
         $username = addslashes($username);
      }
      $q = "SELECT username FROM ".TBL_BANNED_USERS." WHERE username = '$username'";
      $result = mysql_query($q, $this->connection);
      return (mysql_numrows($result) > 0);
   }

   /**
    * addNewUser - Inserts the given (username, password, email)
    * info into the database. Appropriate user level is set.
    * Returns true on success, false otherwise.
    */
   function addNewUser($username, $password, $email){
      $time = time();
      /* If admin sign up, give admin user level */
      if(strcasecmp($username, ADMIN_NAME) == 0){
         $ulevel = ADMIN_LEVEL;
      }else{
         $ulevel = USER_LEVEL;
      }
      $q = "INSERT INTO ".TBL_USERS." VALUES ('$username', '$password', '0', $ulevel, '$email', $time)";
      return mysql_query($q, $this->connection);
   }

   /**
    * updateUserField - Updates a field, specified by the field
    * parameter, in the user's row of the database.
    */
   function updateUserField($username, $field, $value){
      $q = "UPDATE ".TBL_USERS." SET ".$field." = '$value' WHERE username = '$username'";
      return mysql_query($q, $this->connection);
   }

   /**
    * getUserInfo - Returns the result array from a mysql
    * query asking for all information stored regarding
    * the given username. If query fails, NULL is returned.
    */
   function getUserInfo($username){
      $q = "SELECT * FROM ".TBL_USERS." WHERE username = '$username'";
      $result = mysql_query($q, $this->connection);
      /* Error occurred, return given name by default */
      if(!$result || (mysql_numrows($result) < 1)){
         return NULL;
      }
      /* Return result array */
      $dbarray = mysql_fetch_array($result);
      return $dbarray;
   }

   /**
    * getNumMembers - Returns the number of signed-up users
    * of the website, banned members not included. The first
    * time the function is called on page load, the database
    * is queried, on subsequent calls, the stored result
    * is returned. This is to improve efficiency, effectively
    * not querying the database when no call is made.
    */
   function getNumMembers(){
      if($this->num_members < 0){
         $q = "SELECT * FROM ".TBL_USERS;
         $result = mysql_query($q, $this->connection);
         $this->num_members = mysql_numrows($result);
      }
      return $this->num_members;
   }

   /**
    * calcNumActiveUsers - Finds out how many active users
    * are viewing site and sets class variable accordingly.
    */
   function calcNumActiveUsers(){
      /* Calculate number of users at site */
      $q = "SELECT * FROM ".TBL_ACTIVE_USERS;
      $result = mysql_query($q, $this->connection);
      $this->num_active_users = mysql_numrows($result);
   }

   /**
    * calcNumActiveGuests - Finds out how many active guests
    * are viewing site and sets class variable accordingly.
    */
   function calcNumActiveGuests(){
      /* Calculate number of guests at site */
      $q = "SELECT * FROM ".TBL_ACTIVE_GUESTS;
      $result = mysql_query($q, $this->connection);
      $this->num_active_guests = mysql_numrows($result);
   }

   /**
    * addActiveUser - Updates username's last active timestamp
    * in the database, and also adds him to the table of
    * active users, or updates timestamp if already there.
    */
   function addActiveUser($username, $time){
      $q = "UPDATE ".TBL_USERS." SET timestamp = '$time' WHERE username = '$username'";
      mysql_query($q, $this->connection);

      if(!TRACK_VISITORS) return;
      $q = "REPLACE INTO ".TBL_ACTIVE_USERS." VALUES ('$username', '$time')";
      mysql_query($q, $this->connection);
      $this->calcNumActiveUsers();
   }

   /* addActiveGuest - Adds guest to active guests table */
   function addActiveGuest($ip, $time){
      if(!TRACK_VISITORS) return;
      $q = "REPLACE INTO ".TBL_ACTIVE_GUESTS." VALUES ('$ip', '$time')";
      mysql_query($q, $this->connection);
      $this->calcNumActiveGuests();
   }

   /* These functions are self explanatory, no need for comments */

   /* removeActiveUser */
   function removeActiveUser($username){
      if(!TRACK_VISITORS) return;
      $q = "DELETE FROM ".TBL_ACTIVE_USERS." WHERE username = '$username'";
      mysql_query($q, $this->connection);
      $this->calcNumActiveUsers();
   }

   /* removeActiveGuest */
   function removeActiveGuest($ip){
      if(!TRACK_VISITORS) return;
      $q = "DELETE FROM ".TBL_ACTIVE_GUESTS." WHERE ip = '$ip'";
      mysql_query($q, $this->connection);
      $this->calcNumActiveGuests();
   }

   /* removeInactiveUsers */
   function removeInactiveUsers(){
      if(!TRACK_VISITORS) return;
      $timeout = time()-USER_TIMEOUT*60;
      $q = "DELETE FROM ".TBL_ACTIVE_USERS." WHERE timestamp < $timeout";
      mysql_query($q, $this->connection);
      $this->calcNumActiveUsers();
   }

   /* removeInactiveGuests */
   function removeInactiveGuests(){
      if(!TRACK_VISITORS) return;
      $timeout = time()-GUEST_TIMEOUT*60;
      $q = "DELETE FROM ".TBL_ACTIVE_GUESTS." WHERE timestamp < $timeout";
      mysql_query($q, $this->connection);
      $this->calcNumActiveGuests();
   }
   function AddRecipe($user,$Pub,$title,$prep,$cook,$make,$ingr,$desc, $note){
      if(!TRACK_VISITORS) return;
      $q = "INSERT INTO recipies (`user` ,`Pub` ,`title` ,`prep` ,`cook` ,`makes` ,`ingredients` ,`recipe` ,`notes`)VALUES ('$user', '$Pub', '$title', 'prep', 'cook','$make', '$ingr', '$desc', '$note');";
      mysql_query($q, $this->connection) or die(mysql_error());
      $this->calcNumActiveGuests();
   }
   function recipie_comment($user,$comment,$recipie_id){
      if(!TRACK_VISITORS) return;
      $q = "INSERT INTO recipie_comment (`user` ,`comment`, `recipie_id`);";
      mysql_query($q, $this->connection) or die(mysql_error());
      $this->calcNumActiveGuests();
   }
   /**
    * query - Performs the given query on the database and
    * returns the result, which may be false, true or a
    * resource identifier.
    */
   function query($query){
      return mysql_query($query, $this->connection);
   }
};

/* Create database connection */
$database = new MySQLDB;

?>

and also the fields in the database are int 11 for both prep and cook

thanks

Inserting Info Into Mysql Table

Similar Tutorials

View Content

Hello, me again.

I have created a little forum - very very basic.

main_forum.php :

Code: [Select]
<?php
$host="localhost"; // Host name
$username="yvonnedp"; // Mysql username
$password="yvonne"; // Mysql password
$db_name="forum"; // Database name
$tbl_name="forum_question"; // Table name

// Connect to server and select databse.
mysql_connect('localhost', 'yvonnedp', 'yvonne')or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name ORDER BY id";
// OREDER BY id DESC is order result by descending
$result=mysql_query($sql);
?>
<table width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="6%" align="center" bgcolor="#E6E6E6"><strong>#</strong></td>
<td width="53%" align="center" bgcolor="#E6E6E6"><strong>Topic</strong></td>
<td width="15%" align="center" bgcolor="#E6E6E6"><strong>Views</strong></td>
<td width="13%" align="center" bgcolor="#E6E6E6"><strong>Replies</strong></td>
<td width="13%" align="center" bgcolor="#E6E6E6"><strong>Date/Time</strong></td>
</tr>

<?php
while($rows=mysql_fetch_array($result)){ // Start looping table row
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><a href="view_topic.php?id=<? echo $rows['id']; ?>"><? echo $rows['topic']; ?></a><BR></td>
<td align="center" bgcolor="#FFFFFF"><? echo $rows['view']; ?></td>
<td align="center" bgcolor="#FFFFFF"><? echo $rows['reply']; ?></td>
<td align="center" bgcolor="#FFFFFF"><? echo $rows['datetime']; ?></td>
</tr>

<?php
// Exit looping and close connection
}
mysql_close();
?>
create_topic.php :

Code: [Select]
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form id="form1" name="form1" method="post" action="add_topic.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3" bgcolor="#E6E6E6"><strong>Create New Topic</strong> </td>
</tr>
<tr>
<td width="14%"><strong>Topic</strong></td>
<td width="2%">:</td>
<td width="84%"><input name="topic" type="text" id="topic" size="50" /></td>
</tr>
<tr>
<td valign="top"><strong>Detail</strong></td>
<td valign="top">:</td>
<td><textarea name="detail" cols="50" rows="3" id="detail"></textarea></td>
</tr>
<tr>
<td><strong>Name</strong></td>
<td>:</td>
<td><input name="name" type="text" id="name" size="50" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Submit" /> <input type="reset" name="Submit2" value="Reset" /></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
add_topic.php :

Code: [Select]
<?php
$host="localhost"; // Host name
$username="yvonnedp"; // Mysql username
$password="yvonne"; // Mysql password
$db_name="forum"; // Database name
$tbl_name="forum_question"; // Table name

// Connect to server and select database.
mysql_connect('localhost', 'yvonnedp', 'yvonne')or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// get data that sent from form
$topic=$_POST['topic'];
$detail=$_POST['detail'];
$name=$_POST['name'];

$datetime=date("d/m/y h:i:s"); //create date time

$sql="INSERT INTO $tbl_name(topic, detail, name, datetime)VALUES('$topic', '$detail', '$name', '$datetime')";
$result=mysql_query($sql);

if($result){
echo "Successful<BR>";
echo "<a href=main_forum.php>View your topic</a>";

$email_from = "forums@thenewme.co.za";
     $email_to = "info@thenewme.co.za";
     $email_subject = "The New Me - New Forum Topic";

     $email_message = "A new topic has been posted on the Forum!\n";
     $email_message .= "Check it out : http://www.thenewme.co.za/forum/main_forum.php";

     $headers = 'From: '.$email_from."\r\n";
'Reply-To: '.$email_from."\r\n" . 'X-Mailer: PHP/' . phpversion();
  @mail($email_to, $email_subject, $email_message, $headers);

}
else {
echo "ERROR";
}
mysql_close();
?>
add_answer.php :

Code: [Select]
<?php

$host="localhost"; // Host name
$username="yvonnedp"; // Mysql username
$password="yvonne"; // Mysql password
$db_name="forum"; // Database name
$tbl_name="forum_answer"; // Table name

// Connect to server and select databse.
mysql_connect('localhost', 'yvonnedp', 'yvonne')or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Get value of id that sent from hidden field
$id=$_POST['id'];

// Find highest answer number.
$sql="SELECT MAX(a_id) AS Maxa_id FROM $tbl_name WHERE question_id='$id'";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);

// add + 1 to highest answer number and keep it in variable name "$Max_id". if there no answer yet set it = 1
if ($rows) {
$Max_id = $rows['Maxa_id']+1;
}
else {
$Max_id = 1;
}

// get values that sent from form
$a_name=$_POST['a_name'];
$a_answer=$_POST['a_answer'];

$datetime=date("d/m/y H:i:s"); // create date and time

// Insert answer
$sql2="INSERT INTO $tbl_name(question_id, a_id, a_name, a_answer, a_datetime)VALUES('$id', '$Max_id', '$a_name', '$a_answer', '$datetime')";
$result2=mysql_query($sql2);

if($result2){
echo "Successful<BR>";
echo "<a href='view_topic.php?id=".$id."'>View your answer</a>";

// If added new answer, add value +1 in reply column
$tbl_name2="forum_question";
$sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'";
$result3=mysql_query($sql3);

$email_from = "forums@thenewme.co.za";
     $email_to = "info@thenewme.co.za";
     $email_subject = "The New Me - New Forum Answer";

     $email_message = "A new answer to a forum topic has been posted on the Forum!\n";
     $email_message .= "Check it out : http://www.thenewme.co.za/forum/main_forum.php";

     $headers = 'From: '.$email_from."\r\n";
'Reply-To: '.$email_from."\r\n" . 'X-Mailer: PHP/' . phpversion();
  @mail($email_to, $email_subject, $email_message, $headers);

}
else {
echo "ERROR";
}

mysql_close();
?>
view_topic :

Code: [Select]
<?php
$tbl_name2="forum_answer"; // Switch to table "forum_answer"

$sql2="SELECT * FROM $tbl_name2 WHERE question_id='$id'";
$result2=mysql_query($sql2);

while($rows=mysql_fetch_array($result2)){
?>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td bgcolor="#F8F7F1"><strong>ID</strong></td>
<td bgcolor="#F8F7F1">:</td>
<td bgcolor="#F8F7F1"><? echo $rows['a_id']; ?></td>
</tr>
<tr>
<td width="18%" bgcolor="#F8F7F1"><strong>Name</strong></td>
<td width="5%" bgcolor="#F8F7F1">:</td>
<td width="77%" bgcolor="#F8F7F1"><? echo $rows['a_name']; ?></td>
</tr>
<tr>
<td bgcolor="#F8F7F1"><strong>Answer</strong></td>
<td bgcolor="#F8F7F1">:</td>
<td bgcolor="#F8F7F1"><? echo $rows['a_answer']; ?></td>
</tr>
<tr>
<td bgcolor="#F8F7F1"><strong>Date/Time</strong></td>
<td bgcolor="#F8F7F1">:</td>
<td bgcolor="#F8F7F1"><? echo $rows['a_datetime']; ?></td>
</tr>
</table></td>
</tr>
</table><br>

<?
}

$sql3="SELECT view FROM $tbl_name WHERE id='$id'";
$result3=mysql_query($sql3);

$rows=mysql_fetch_array($result3);
$view=$rows['view'];

// if have no counter value set counter = 1
if(empty($view)){
$view=1;
$sql4="INSERT INTO $tbl_name(view) VALUES('$view') WHERE id='$id'";
$result4=mysql_query($sql4);
}

// count more value
$addview=$view+1;
$sql5="update $tbl_name set view='$addview' WHERE id='$id'";
$result5=mysql_query($sql5);

mysql_close();
?>
the problem is. With add_answer, I am not able to insert an answer. This has worked for the very first question, but all subsequent questions, I am unable to add answers. It keeps telling me ERROR.

This is where the live forum is : http://www.thenewme.co.za/forum/main_forum.php

Can it be an issue with the field that gets autmatically incremented? i have echo'd the data which get entered in when someone types in an answer, and everything is perfect!

Can anyone help me?

Display Mysql Info Alphabetically?

Similar Tutorials

View Content

I have a 'user' table and a display users page.

How would I display them in alphabetical order by their username?

Heres my current basic display page:
<?php
include 'dbwire.php';
include 'header.php';
$query = mysql_query('SELECT * FROM user');

while ($row = mysql_fetch_array($query)) {
       echo '<b>Username:</b> ' . $row['user'] . '<br />';
       echo '<b>Real Name:</b> ' . $row['name'] . '<br />';
       echo '<b>Email:</b> ' . $row['email'] . '<br />';
       echo '<b>Location:</b> ' . $row['location'] . '<br /> <hr>';
}
?>

Theres also an id row but since user wouldn't be added alphabetically I wouldn't be able to order them by id.

Need Help To Get Info From Mysql Db And Loop In Slider

Similar Tutorials

View Content

Im turning a static slider revolution in a dynamic.

Images are uploading and fetching perfect from Mysql DB but the texts (top-text) is showing only in the first slide. The rest is empty.

Here is the Code

Any help would be great.
Thanks in advance.

UPLOAD.php

<?php
// Include the database configuration file
include 'database/dbConfig.php';
$statusMsg = '';

// File upload path
$targetDir = "uploads/";
$fileName = basename($_FILES["file"]["name"]);
$top_text = filter_input(INPUT_POST, 'top_text');
$targetFilePath = $targetDir . $fileName;
$fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION);

if(isset($_POST["submit"]) && !empty($_FILES["file"]["name"])){
    // Allow certain file formats
    $allowTypes = array('jpg','png','jpeg','gif','pdf');
    if(in_array($fileType, $allowTypes)){
        // Upload file to server
        if(move_uploaded_file($_FILES["file"]["tmp_name"], $targetFilePath)){
            // Insert image file name into database
            $insert = $db->query("INSERT into images (file_name, top_text, uploaded_on) VALUES ('".$fileName."', '".$top_text."', NOW())");
            if($insert){
                $statusMsg = "The file ".$fileName. " has been uploaded successfully.";
            }else{
                $statusMsg = "File upload failed, please try again.";
            } 
        }else{
            $statusMsg = "Sorry, there was an error uploading your file.";
        }
    }else{
        $statusMsg = 'Sorry, only JPG, JPEG, PNG, GIF, & PDF files are allowed to upload.';
    }
}else{
    $statusMsg = 'Please select a file to upload.';
}

// Display status message
echo $statusMsg;
?>

SLIDER

<!-- Revolution slider -->
<section id="slider">
        <div class="tp-banner-container ">
            <div class="tp-banner rev-banner-fullscreen">
                 <ul>
                    <!-- SLIDE -->
                    <?php
                     // Include the database configuration file
                      include 'database/dbConfig.php';
        
                     // Get images from the database
                       $query = $db->query("SELECT * FROM images ORDER BY uploaded_on DESC");
        
                          if($query->num_rows > 0){
                          while($row = $query->fetch_assoc()){
                         $imageURL = 'uploads/'.$row["file_name"];
                         $top_text = $row['top_text'];
                    ?>
                        <!-- DYNAMIC SLIDE  -->
                    <li data-index="rs-140" data-transition="slideup" data-slotamount="default" data-easein="default" data-easeout="default" data-masterspeed="default" data-thumb="" data-rotate="0" data-saveperformance="off" data-title="1/2" data-description="">
                        <!-- MAIN IMAGE -->
                        <img src="<?php echo $imageURL; ?>" alt="" style='background-color:#f4f4f4' alt="" width="482" height="800" data-bgposition="center center" data-bgfit="cover" data-bgrepeat="no-repeat" class="rev-slidebg" data-no-retina>
                        <!-- LAYERS -->

                        <!-- LAYERS 1.2 -->
                        <div class="tp-caption tp-resizeme" id="slide-1-layer-2" data-x="['left','left','left','left']" data-hoffset="['102','102','67','40']" data-y="['top','top','top','top']" data-voffset="['150','150','60','60']" data-fontsize="['18','18','14','14']" data-width="['345','345','345','259']" data-height="none" data-whitespace="normal" data-transform_idle="o:1;" data-transform_in="y:50%;z:0;rX:0deg;rY:0;rZ:0;sX:1;sY:1;skX:0;skY:0;opacity:0;s:900;e:Power4.easeInOut;" data-transform_out="x:-50%;opacity:0;s:800;e:Power2.easeInOut;s:300;e:Power2.easeInOut;" data-start="500" data-splitin="none" data-splitout="none" data-responsive_offset="on" style="z-index: 6; min-width: 345px; max-width: 345px; white-space: normal; color: #3e3e3e; font-family: 'Montserrat'; letter-spacing: 7px;">
                        <?php echo $top_text; ?>
                        </div>
                        
                        <!-- /END DYNAMIC SLIDE  -->
                    </li>    

                        <?php }
                         }else{?>
                         

                          <!-- DEFAULT SLIDE  -->
                    <li data-index="rs-140" data-transition="slideup" data-slotamount="default" data-easein="default" data-easeout="default" data-masterspeed="default" data-thumb="" data-rotate="0" data-saveperformance="off" data-title="1/2" data-description="">
                        <!-- MAIN IMAGE -->
                        <img src="images/slide/slide-5-bg.jpg" style='background-color:#f4f4f4' alt="" width="482" height="800" data-bgposition="center center" data-bgfit="cover" data-bgrepeat="no-repeat" class="rev-slidebg" data-no-retina>
                        <!-- LAYERS -->

                        <!-- LAYERS 1.2 -->
                        <div class="tp-caption tp-resizeme" id="slide-1-layer-2" data-x="['left','left','left','left']" data-hoffset="['102','102','67','40']" data-y="['top','top','top','top']" data-voffset="['150','150','60','60']" data-fontsize="['18','18','14','14']" data-width="['345','345','345','259']" data-height="none" data-whitespace="normal" data-transform_idle="o:1;" data-transform_in="y:50%;z:0;rX:0deg;rY:0;rZ:0;sX:1;sY:1;skX:0;skY:0;opacity:0;s:900;e:Power4.easeInOut;" data-transform_out="x:-50%;opacity:0;s:800;e:Power2.easeInOut;s:300;e:Power2.easeInOut;" data-start="500" data-splitin="none" data-splitout="none" data-responsive_offset="on" style="z-index: 6; min-width: 345px; max-width: 345px; white-space: normal; color: #3e3e3e; font-family: 'Montserrat'; letter-spacing: 7px;">
                            New Arrival
                        </div>

                    
                    <!-- /END DEFAULT SLIDE -->

                       <?php  } ?>

                    </li>
                    <!-- /SLIDE 1 -->

                    

                </ul>
            </div>
            <!-- /tp-banner -->
        </div>
        <!-- /tp-banner-container -->
    </section>
    <!-- /#Revolution slider -->

Adding Info To Mysql Database

Similar Tutorials

View Content

Hi Im having some trouble implementing info into a database

Php Image Upload Help: Copy() [function.copy]: Filename Cannot Be Empty In

Similar Tutorials

View Content

Hi guys,

I am wirting a script to upload an image file, but I get the error:

copy() [function.copy]: Filename cannot be empty in

Obviouly it has something to do with the copy() function - (copy($HTTP_POST_FILES['product_img']['tmp_name'], $path))

I think it is not copying from my temp folder or something.

Can anyone help me out?

Code is:

Code: [Select]
//IMAGE FILE
$file_name = $_FILES['product_img']['name'];

echo '<p>File Name:' . $file_name . '</p>';
//IMAGE UPLOAD
// random 4 digit to add to file name
$random_digit=rand(0000,9999);

//combine random digit to file name to create new file name
//use dot (.) to combile these two variables
$new_image_name = $random_digit.$file_name;

echo $new_image_name;

//SET DESINATION FOLDER
$path= "uploads/".$new_image_name;
echo '<p>Path:' . $path . '</p>';
if($product_img !=none)
{
if(copy($HTTP_POST_FILES['product_img']['tmp_name'], $path))
{
echo "Successful<BR/>";
echo "File Name :".$new_file_name."<BR/>";
echo "File Size :".$HTTP_POST_FILES['product_img']['size']."<BR/>";
echo "File Type :".$HTTP_POST_FILES['product_img']['type']."<BR/>";
}
else
{
echo "Image upload Error<BR/>";
}
}
Any help would be greatly appreciated!

Thanks

Warning: Copy() [function.copy]: Open_basedir Restriction In Effect

Similar Tutorials

View Content

Ok I am designing a php upload that will take a image file from a form and change the name of the file to the productnumber also recieved from the form. I had it working the otherday now it says Warning: copy() [function.copy]: open_basedir restriction in effect File() is not within the allowed path(s): (/home:/tmp:/usr) addpro.php on line 51.

my files are attached.... note that $pnum is the product number gotten from my form and image is the image being uploaded gotten from the form also. The thing is it worked the other day but now it don't is it a change to the server ( I dont run the server) or did I mess up my code since then? I really need a code that will do this two time over once for a small image being put into a folder called small and once for a folder called large both images being uploaded and being changed to $pnum.ext so they will both be displayed when being called out by the product number. but I can work on that after I get this one working.

line 51 is $copied = copy($_FILES['image']['tmp_name'], $newname);

How To Assign Different Css Values To Info Pulled From Mysql

Similar Tutorials

View Content

I am trying to figure out the best way to do something if there is a way.

I am pulling values from a MySQL table and using a while loop to display the data, so it looks something like this.

while($row = mysql_fetch_array($result))
  {

  echo "<tr>";

  echo "<td>" . $row['last_name'] . "</td>\n";
  echo "<td>" . ucwords($row['first_name']) . "</td>\n";

  echo "<td>" . $row['Class_Date'] . "</td>\n";

  echo "</tr>";

for the class dates, I want the column background to be a different color depending on the date. For instance January would hvae a blue background, February a red one etc.

I was going to try and do that with CSS like

Code: [Select]
echo "<td class="blue">" . $row['Class_Date'] . "</td>\n";

in the CSS...
Code: [Select]
.blue{
background-color:#06c;
}

but not sure the best way to make the changing data values different colors with CSS.

any suggestions?

Php Insert Info Mysql Table Query

Similar Tutorials

View Content

How can i use single quote for values?

$qry='insert into tablename values('a','b');';

Get Specific Mysql/mariadb Error Info

Similar Tutorials

View Content

I wish to respond specifically to PDO errors. $e->getMessage() shows something like the following:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails... SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ...

I suppose I can just look for 1452 and 1062, but thought using http://php.net/manual/en/pdo.errorcode.php would be better, but it is empty. I am using Server version: 10.2.18-MariaDB MariaDB Server. Any suggestions?

Thanks

try{
    $this->pdo->prepare($sql)->execute([$value, $id, $this->accountsId]);
}
catch(\PDOException $e) {
    syslog(LOG_ERR, json_encode($this->pdo->errorCode()));
    syslog(LOG_ERR, json_encode($this->pdo->errorInfo()));
}

"00000"
["00000",null,null]

Mysql Database Display Info Separately

Similar Tutorials

View Content

Hi there.

I have this simple code which displays 5 results. How can i grab each element separately instead of displaying all the results at once.

Thanks:)

Code: [Select]
<?php
$query = mysql_query("SELECT product_name, product_price FROM products WHERE product_type = 'laptop' LIMIT 5");
$numrows = mysql_num_rows($query);

if ($numrows != 0)
{
while ($row = mysql_fetch_assoc($query))
{
$product_name = $row['product_name'];
$product_price = $row['product_price'];
echo $product_name . '<br />';
echo $product_price . '<br /><br />';
}
}
?>

Adding Info To An Existing Mysql Cell. Is It Possible?

Similar Tutorials

View Content

Im trying to add some info to an existing cell in a mysql database.

The cell currently reads: This is a piece of information.
I would like to update the cell to read: This is a piece of information. a great piece of info.

I have a variable with the following; $info = a great piece of info.

Is it possible to add $info to the existing cell via php

eg.

<?php mysql_query("UPDATE mytable SET info = '$info' WHERE row = '$row'"); ?>

all fine except I dont want to SET the info to $info I simply want to add $info onto the end of the existing data in the info record.

Is this possible and how do i change the above query and go about it?

Many thanks

Pull User Info From Mysql Db In Session

Similar Tutorials

View Content

Hello all,

I have a membership website which is using sessions... and ive been asked to add some promotion points system. So that each user is able to see how many promotion points they have...

Now, I'm a beginner in mysql and php, but feel I'm learning fairly quickly. What I need help with, is to be able to display the amount of promotion points for the logged in user.

I created a new field in my "essenti1_Users" table for the promotion code.

database is called "essenti1_membership"
table is "essenti1_Users"
feild is "promo"

I think im going to have to manually add the points to each user manually through phpMyAdmin Navicat unfortunatly. Unless anyone has any other ideas just for adding the points to each user account?
ziggynerja is online now Add to ziggynerja's Reputation Report Post Edit/Delete Message

Clone Creates A Shallow Copy Or Deep Copy?

Similar Tutorials

View Content

I came across the PHP clone method. Does this clone first level fields and methods or does it also do deep copying e.g. copying references to those fields. For example, a field may be an array. Does it make a copy of the actual array or does it refer to the same array position in memory, so if the original changes, then the copy's changes as well?

Probably Can't Be More Basic! Warning: Copy() [function.copy]: Filename Cannot

Similar Tutorials

View Content

This was generated through phpFormGenerator, but I'm getting the following warning message when a file is not uploaded. I didn't set it as a required field.

"Warning: copy() [function.copy]: Filename cannot be empty ..."

If it possible to skip this check since it's not supposed to be required to upload a file? I'm simply trying to make a contact form that emails basic information with the added option of attaching a file/picture.

Code: [Select]
<?php
include("global.inc.php");
$errors=0;
$error="The following errors occured while processing your form input.<ul>";
pt_register('POST','FullName');
pt_register('POST','Email');
pt_register('POST','Phone');
pt_register('POST','QuestionsorComments');
$QuestionsorComments=preg_replace("/(\015\012)|(\015)|(\012)/"," <br />", $QuestionsorComments);$AttachPictureforQuote=$HTTP_POST_FILES['AttachPictureforQuote'];
pt_register('POST','Howdidyoufindus');
if($FullName=="" || $Email=="" ){
$errors=1;
$error.="<li>You did not enter one or more of the required fields. Please go back and try again.";
}
if($HTTP_POST_FILES['AttachPictureforQuote']['tmp_name']==""){ }
else if(!is_uploaded_file($HTTP_POST_FILES['AttachPictureforQuote']['tmp_name'])){
$error.="<li>The file, ".$HTTP_POST_FILES['AttachPictureforQuote']['name'].", was not uploaded!";
$errors=1;
}
if(!eregi("^[a-z0-9]+([_\\.-][a-z0-9]+)*" ."@"."([a-z0-9]+([\.-][a-z0-9]+)*)+"."\\.[a-z]{2,}"."$",$Email)){
$error.="<li>Invalid email address entered";
$errors=1;
}
if($errors==1) echo $error;
else{
$image_part = date("h_i_s")."_".$HTTP_POST_FILES['AttachPictureforQuote']['name'];
$image_list[4] = $image_part;
copy($HTTP_POST_FILES['AttachPictureforQuote']['tmp_name'], "files/".$image_part);
$where_form_is="http".($HTTP_SERVER_VARS["HTTPS"]=="on"?"s":"")."://".$SERVER_NAME.strrev(strstr(strrev($PHP_SELF),"/"));
$message="Full Name: ".$FullName."
Email: ".$Email."
Phone: ".$Phone."
Questions or Comments: ".$QuestionsorComments."
Attach Picture for Quote: ".$where_form_is."files/".$image_list[4]."
How did you find us: ".$Howdidyoufindus."
";
$message = stripslashes($message);
mail("webmaster@gmail.com","Form Submitted at your website",$message,"From: phpFormGenerator");
?>



<h2>Thank you!</h2>

<table width=50%>
<tr><td>Full Name: </td><td> <?php echo $FullName; ?> </td></tr>
<tr><td>Email: </td><td> <?php echo $Email; ?> </td></tr>
<tr><td>Phone: </td><td> <?php echo $Phone; ?> </td></tr>
<tr><td>Questions or Comments: </td><td> <?php echo $QuestionsorComments; ?> </td></tr>
<tr><td>Attach Picture for Quote: </td><td> <?php echo $AttachPictureforQuote; ?> </td></tr>
<tr><td>How did you find us: </td><td> <?php echo $Howdidyoufindus; ?> </td></tr>
</table>


<?php
}
?>
Thanks for your time and any help you can provide!