PHP - Help! How To Take Input Message In A Form And Output Each Charain A Square Box?

Code: [Select]
<?php
ob_start();
session_start();

require_once ("functions.php");

$returnurl = urlencode(isset($_GET["returnurl"])?$_GET["returnurl"]:"");
if($returnurl == "")
$returnurl = urlencode(isset($_POST["returnurl"])?$_POST["returnurl"]:"");

$do = isset($_GET["do"])?$_GET["do"]:"";

$do = strtolower($do);

switch($do)
{
case "":
if (checkLoggedin())
{include("usernav.php");?>
<h3>User Logged In</h3>
<p>This is the members only area.</p>
<?php } else {?>

<a name="User Panel"></a>
<h1>User Panel</h1>
<h3>User Login</h3>
<form name="login" action="login.php?do=login" method="POST" onsubmit="return aValidator();">
<input type="hidden" name="returnurl" value="<?$returnurl?>">
<table cellPadding=3 width=225 border=1>
<tr>
<td colSpan=2>
<center>
<p><b>Members-Only Area!</b></font></p>
</center></td></tr>
<tr>
<td align=center width=70>Username:</td>
<td><input type="text" name="username"></td></tr>
<tr>
<td align=center width=70>Password:</td>
<td><input type="password" name="password"></font></td></tr>
<tr>
<td align=middle colspan=2>
<input type="submit" name="submit" value="Login"></td></tr>
<td align=middle colSpan=2>
<input type="checkbox" name="remme" value="on">&nbsp;Remember me for the next time I visit</td>
</form></table></td>
<?php
}
break;
case "login":
$username = isset($_POST["username"])?$_POST["username"]:"";
$password = isset($_POST["password"])?$_POST["password"]:"";

if ($username=="" or $password=="" )
{
echo "<h1>Username or password is blank</h1>";//this does not show when the input(s) are blank
clearsessionscookies();
header("location: index.php?returnurl=$returnurl");
}
else
{
if(confirmuser($username,$password))
{
createsessions($username,$password);
if ($returnurl<>"")
header("location: $returnurl");
else
{
header("Location: index.php");
}
}
else
{
echo "<h1>Invalid Username and/Or password</h1>";//this message does not show when the user login invalid
clearsessionscookies();
header("location: index.php?returnurl=$returnurl");
}
}
break;
case "logout":
clearsessionscookies();
header("location: index.php");
break;
}
?>
What maybe the case, could anyone help me with this?
Thanks Ted.

function showCart() {
   global $db;
   
   $cart = $_SESSION['cart'];
   $output[] = '<div align="center"><table cellpadding="1" cellspacing="1" bgcolor="#666666" width="400">';
         $output[] = '<tr bgcolor="#FFFFFF" valign="middle">';
         $output[] = '<td width="70" align="center">Titlu</td>';
         $output[] = '<td width="90" align="center">Imagine </td>';
         $output[] = '<td width="60" align="center">Pret</td>';
         $output[] = '<td align="center">Sterge Produs</td>';
         
         $total += $price * $qty;
         $output[] = '</tr>';
         $output[] = '</table>';
   if ($cart) {
      $items = explode(',',$cart);
      $contents = array();
      foreach ($items as $item) {
         $contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
      }
         $output[] = '<form  action="http://www.sprayart.info/new/sprayart.php"><div align="center" name="trimite" id="trimite"><table width="400">';
      foreach ($contents as $id=>$qty) {
                  

         $sql = 'SELECT * FROM com_images WHERE id = '.$id;
         $result = $db->query($sql);
         $row = $result->fetch();
         extract($row);
         
         $output[] = '<tr bgcolor="#FFFFFF">';
         $output[] = '<td width="70">
         <input type="hidden" name="title[ ]"         
          value="'.$title.'" size="5" maxlength="5" />
         <input type="text"  value="'.$title.'" size="5" maxlength="5" disabled="disabled" /></td>';
         $output[] = '<td width="90" align="center" valign="middle"><img src=../../'.$thumbnail.'> </td>';
         $output[] = '<td width="60" align="center">'.$price.'</td>';
         $output[] = '<td ></td>';
         $total += $price * $qty;
         $output[] = '<td width="50"><a href="cart.php?action=delete&id='.$id.'" class="r"><img src="../../media/sterge.jpg"></a></td>';
         $output[] = '</tr>';   
      }
   
      $output[] = '</table>';
      $output[] = '<hr>';
      $output[] = '<p align="right">Total De plata: <strong>'.$total.' RON</strong></p></div>';
      
      $output[] = '<table border="0" width="444" id="table29" cellspacing="0" cellpadding="0" background="#BASE_URL#media/comand_form.gif" height="322">
  <form action="#BASE_URL#sprayart.php" method="post" name="trimite" id="trimite">
    <tr>
      <td width="25"></td>
      <td width="71" class="text_negru_left_25"><span class="style4">*</span> Nume:</td>
      <td width="146"><input name="nume" type="text" class="text_negru_fild_19" /></td>
      <td width="170"></td>
      <td width="32"></td>
    </tr>
    <tr>
      <td width="25"></td>
      <td  class="text_negru_left_25"><span class="style4">*</span> Adresa:</td>
      <td ><input name="adresa" type="text" class="text_negru_fild_19"></td>
      <td width="170"></td>
      <td width="32"></td>
    </tr>
    <tr>
      <td width="25"></td>
      <td  class="text_negru_left_25"><span class="style4">*</span> E-mail:</td>
      <td ><input name="email" type="text" class="text_negru_fild_19" /></td>
      <td width="170"></td>
      <td width="32"></td>
    </tr>
    <tr>
      <td width="25"></td>
      <td class="text_negru_left_25"><span class="style4">*</span> Telefon:</td>
      <td ><input name="telefon" type="text" class="text_negru_fild_19" /></td>
      <td width="170"></td>
      <td width="32"></td>
    </tr>
    <tr>
      <td width="25" height="139"></td>
      <td colspan="3" class="text_negru_left_25"><span class="style4">*</span>        <textarea name="mesaj" cols="44" rows="7" ></textarea></td>
      <td width="32"></td>
    </tr>
    <tr>
      <td width="25" height="39"></td>
      <td colspan="2" valign="top" class="text_negru_left_25"></td>
      <td valign="top" class="text_negru_left_25"><input style="BORDER-RIGHT: #3a3a3a 1px solid; BORDER-TOP: #3a3a3a 1px solid; FONT-SIZE: 8pt; FLOAT: right; BORDER-LEFT: #3a3a3a 1px solid; COLOR: #b1b1a7; BORDER-BOTTOM: #3a3a3a 1px solid; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #3a3a3a" type="submit" class="buton" name="trimite" value="Trimite" /></td>
      <td width="32"></td>
    </tr></table></form>';


  how can i get the "title" for all products ! if i buy one its ok it will send me in email, but if is more products i get only the last added product!!

 Please help thank you !

Hello, I have coded a contact form in PHP and I want to know, if according to you, it is secure! I am new in PHP, so I want some feedback from you.

Moreover, I have also two problems based on the contact form. It is a bit complicated to explain, thus, I will break each of my problem one by one.

FIRST:The first thing I want to know, is if my contact form secure according to you:

The HTML with the PHP codes:

Code: [Select]
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {

//Assigning variables to elements
$first = htmlentities($_POST['first']);
$last = htmlentities($_POST['last']);
$sub = htmlentities($_POST['subject']);
$email = htmlentities($_POST['email']);
$web = htmlentities($_POST['website']);
$heard = htmlentities($_POST['heard']);
$comment = htmlentities($_POST['message']);
$cap = htmlentities($_POST['captcha']);

//Declaring the email address with body content
$to = 'alithebestofall2010@gmail.com';
$body ="First name: '$first' \n\n Last name: '$last' \n\n Subject: '$sub' \n\n Email: '$email' \n\n Website: '$web' \n\n Heard from us: '$heard' \n\n Comments: '$comment'";

//Validate the forms
if (empty($first) || empty($last) || empty($sub) || empty($email) || empty($comment) || empty($cap)) {
echo '<p class="error">Required fields must be filled!</p>';
header ('refresh= 3; url= index.php');
return false;

} 
elseif (filter_var($first, FILTER_VALIDATE_INT) || filter_var($last, FILTER_VALIDATE_INT)) {
echo '<p class="error">You cannot enter a number as either the first or last name!</p>';
return false;
} 
elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
echo '<p class="error">Incorrect email address!</p>';
return false;
}
elseif (!($cap === '12')){
echo '<p class="error">Invalid captcha, try again!</p>';
return false;
}
else {
mail ($to, $sub, $body);
echo '<p class="success">Thank you for contacting us!</p>';
}
}
?>
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<p>Your first name: <span class="required">*</span></p>
<p><input type="text" name="first" size="40" placeholder="Ex: Paul"/></p>

<p>Your last name: <span class="required">*</span></p>
<p><input type="text" name="last" size="40" placeholder="Ex: Smith"/></p>

<p>Subject: <span class="required">*</span></p>
<p><input type="text" name="subject" size="40" placeholder="Ex: Contact"/></p>

<p>Your email address: <span class="required">*</span></p>
<p><input type="text" name="email" size="40" placeholder="Ex: example@xxx.com"/></p>

<p>Website:</p>
<p><input type="text" name="website" size="40" placeholder="Ex: http//:google.com"/></p>

<p>Where you have heard us?: <span class="required">*</span></p>
<p><select name="heard">
<option>Internet</option>
<option>Newspapers</option>
<option>Friends or relatives</option>
<option>Others</option>
</select></p>

<p>Your message: <span class="required">*</span></p>
<p><textarea cols="75" rows="20" name="message"></textarea></p>

<p>Are you human? Sum this please: 5 + 7 = ?: <span class="required">*</span></p></p>
<p><input type="text" name="captcha" size="10"/></p>

<p><input type="submit" name="submit" value="Send" class="button"/>
<input type="reset" value="Reset" class="button"/></p>
</form>

SECOND PROBLEM:If a user has made a mistake, he gets the error message so that he can correct! However, when a mistake in the form occurs, all the data the user has entered are disappeared! I want the data to keep appearing so that the user does not start over again to fill the form.

THIRD: When the erro message is displayed to notify the user that he made a mistake when submitting the form, the message is displaying on the top of the page. I want it to appear below each respective field. How to do that? In JQuery it is simple, but in PHP, I am confusing!

how do I make it so that $message displays on form submit on the same page?:
Code: [Select]
<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['id'])) { 
   echo 'Please <a href="login.php">log in</a> to access your account';
   exit(); 
}

//Connect to the database through our include 
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];
?>
<?php
$message ='Registration has been verified!';
// Process the form if it is submitted
if ($_POST['submit']) {
$verified = $_POST['verified'];

  
$sql = mysql_query("UPDATE Events SET verified='yes',  WHERE barcode='$verified'");


exit();
} // close if post
?>
<?php
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid'");
while($row = mysql_fetch_array($sql)){
$userid = $row["userid"];
$name = $row["name"];
$phone = $row["phone"];
$username = $row["username"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
$accounttype = $row["accounttype"];
$rank = $row["rank"];
$badges = $row["badges"];
$password = $row["password"];
$password2 = $row["password2"];
}
?>
<!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"><!-- InstanceBegin template="/Templates/template2.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- InstanceEndEditable -->
<style type="text/css">

#editregion {
position:absolute;
left:-8px;
top:272px;
width:1293px;
height:51px;
z-index:1;
text-align: center;
clear: none;
float: none;
}

body {
background-image: url(file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/button/boyscout1.png);
background-repeat: no-repeat;
position: relative;
}
#menu {
position:relative;
left:160px;
top:0px;
width:931px;
height:59px;
z-index:19;

}
#menu #MenuBar1 li a {
color: #000;
border-top-style: outset;
border-right-style: outset;
border-bottom-style: outset;
border-left-style: outset;
width: 100px;
}

#status {
position:relative;
left:16px;
top:180px;
width:124px;
height:44px;
z-index:14;
}


</style>
<script src="file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<script type="text/javascript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
</script>
<!-- InstanceBeginEditable name="head" -->


<style type="text/css">
body {
background-image: url(file:///Macintosh%20HD/Users/aaron/Downloads/memberSystemBasic%204/button/boyscout1.png);
background-repeat: no-repeat;
}
</style>
<!-- InstanceEndEditable -->
<!-- InstanceParam name="id" type="text" value="apDiv6" -->
<link href="file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
<style type="text/css">
#logout {
position:relative;
left:0px;
top:0pxpx;
width:134px;
height:38px;
z-index:20;
font-weight: bold;
font-size: 24px;
}
#logout a {
color: #000;
}


#status {
text-align: center;
}
#logout1 {
position:absolute;
left:1071px;
top:191px;
width:224px;
height:61px;
z-index:2;
}
#menu2 {
position:absolute;
left:-1px;
top:172px;
width:497px;
height:92px;
z-index:20;
}
#footer {
position:fixed;
left:-10px;
top:0px2
width:1290px;
height:63px;
z-index:1;
color: #000;
background-color: #000;
right: 0px;
bottom: 0px;
}
</style>
</head>
<body>
<div id="logout1"><div id="logout"><a href="file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/logout.php">Logout</a></div></div>
<div id="status"><?php echo "$accounttype"; ?>
  <br /><?php echo "$name"; ?>
  <p>&nbsp;</p>
</div>
<div id="editregion"><!-- InstanceBeginEditable name="EditRegion3" -->
  <p>&nbsp;</p>
  <form id="form1" name="form1" method="post" action="">
    Please enter verification code:
    <label for="verified"></label>
<input type="text" name="verified" id="verified" />
  </form>
  <p>&nbsp; </p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
<!-- InstanceEndEditable --><br /><br />

<?php if ($accounttype == "Admin") {echo '<div id="footer"><img src="footer_admin.png" width="1290" height="63" border="0" usemap="#Map" />
  <map name="Map" id="Map">
    <area shape="rect" coords="10,5,112,32" href="myprofile.php" />
    <area shape="rect" coords="153,5,235,31" href="register.php" />
    <area shape="rect" coords="277,7,333,32" href="news.php" />
    <area shape="rect" coords="471,7,682,33" href="scoutmanager.php" />
    <area shape="rect" coords="726,5,874,34" href="membermanager.php" />
    <area shape="rect" coords="906,3,1058,34" href="eventmanager.php" />
    <area shape="rect" coords="1092,6,1226,32" href="newsmanager.php" />
  </map>
</div>'; } else if ($accounttyp="scout"){echo '<div id="footer"><img src="footer_scout.png" width="1290" height="63" border="0" usemap="#Map" />
  <map name="Map" id="Map">
    <area shape="rect" coords="526,6,632,34" href="myprofile.php" />
    <area shape="rect" coords="668,5,752,32" href="register.php" />
    <area shape="rect" coords="789,5,850,34" href="news.php" />
  </map>
</div>';} else {echo '<div id="footer"><img src="footer_admin.png" width="1290" height="63" border="0" usemap="#Map" />
  <map name="Map" id="Map">
    <area shape="rect" coords="10,5,112,32" href="myprofile.php" />
    <area shape="rect" coords="153,5,235,31" href="register.php" />
    <area shape="rect" coords="277,7,333,32" href="news.php" />
    <area shape="rect" coords="471,7,682,33" href="scoutmanager.php" />
    <area shape="rect" coords="726,5,874,34" href="membermanager.php" />
    <area shape="rect" coords="906,3,1058,34" href="eventmanager.php" />
    <area shape="rect" coords="1092,6,1226,32" href="newsmanager.php" />
  </map>
</div>'; }
?></div>



<div id="menu2"><div id="menu">
  <ul id="MenuBar1" class="MenuBarHorizontal">
    <li><a href="file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/myprofile.php">My Profile</a>    </li>
    <li><a href="file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/register.php">Register</a></li>
    <li><a href="file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/projects.php">Projects</a>    </li>
    <li><a href="file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/news.php">News</a></li>
    <?php if ($accounttype == "Admin") {
?>
    <li><a href="file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/membermanager.php">Scout Manager</a></li>
    <li><a href="file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/eventmanager.php">Event Manager</a></li>
    <li><a href="file:///Macintosh HD/Users/aaron/Downloads/memberSystemBasic 4/newsmanager.php">News Manager</a></li>
  </ul><?php
}
?>
</div></div>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"../SpryAssets/SpryMenuBarDownHover.gif", imgRight:"../SpryAssets/SpryMenuBarRightHover.gif"});
</script>
</body>
<!-- InstanceEnd --></html>

Form.php

Code: [Select]
<html>
<head>
<script type="text/javascript">
function addsmiley(code)
{
var pretext = document.smile.message.value;
              this.code = code;
              document.smile.message.value = pretext + code;
}

function a()
{
 var x = document.smile.message.value;
 if(x=="")
 {
  alert("Please insert an message!");
  return false;
 }
 
}

</script>
<style type="text/css">
body{ background-color: #d8da3d }
</style>
</head>
<body>
  <form name="smile" method="post" action="registration.php" onSubmit="return a()" >
   Your message:<br><textarea name='message' cols='40' rows='2'></textarea><br>
   <img src="smile.gif" alt=":)" onClick="addsmiley(':)')" style="cursor:pointer;border:0" />
   <img src="blush.gif" alt=":)" onClick="addsmiley('*blush*')" style="cursor:pointer;border:0" />
   <input type='submit' name='submit' value='Set Name' class='biasa'  ></form>
   
   
 
  <br> <br>
  </body>
</html>
Registration.php
Code: [Select]
<?php
$m=$_POST['message'];
echo("<SCRIPT LANGUAGE='JavaScript'>window.alert('$m')</SCRIPT>");
?>
<html>
<head>
<script type="text/javascript">
  function a()
{
   var x = document.register.username.value;
   var y = document.register.pass.value;
   var z = document.register.pass2.value;
   
   if(x==""&& y==""&& z=="")
   {
    alert("Please insert all message!");
    return false;
   }
   if(x=="")
   {
     alert("Please insert an username!");
     return false;
   }
   if(y=="")
   {
     alert("Please insert an password!");
     return false;
   }
   if(z=="")
   {
     alert("Please insert an password2!");
     return false;
   }
   
   if (y!=z)
   {
     alert("Your passwords did not match");
     return false;
   }
   



}
</script>
</head>
<body>



  <form name="register" method="post" action="login.php"  onsubmit="return a()">
  <table border='0'>
  <input type="text" name="<?php $m?>">
  <tr><td>Username:</td><td><input type="text"name="username" maxlength="60"></td></tr>
  <tr><td>Password:</td><td><input type="password" name="pass" maxlength="10"></td></tr>
  <tr><td>Confirm Password:</td><td><input type="password" name="pass2" maxlength="10"></td></tr>
  <tr><th colspan=2><input type="submit" name="sub" value="Register"></th></tr> </table>
  </form>
 

  </body>
 </html>
Your message:<br><textarea name='message' cols='40' rows='2'></textarea><br>     This i took from form.php and when it passed to registration.php when im called it in javascript  <?php
$m=$_POST['message'];
echo("<SCRIPT LANGUAGE='JavaScript'>window.alert('$m')</SCRIPT>");  it can show the message im put in form.php but when im put into input text that is  <input type="text" name="<?php $m?>">  but the input text is blank not put the message im post in form php may i know which is the error

As some of y'all may not know, I am new to this php coding stuff so if anything does not work the way I want it to, it goes to the forum. And this is the case when just after I solved a problem with my first contact form, I run into another problem again.  My latest problem involves the form error thing that tells you that you did not enter any required fields. After I added a error message thing to my contact page and tested it, it doesn't show up.
Oh and here's the code:
Code: [Select]
<?php if ($missing || $errors) { ?>
<div id="maincontent">
<p class="warning">You did not enter the required information. Please try again.</p></div>

Here is what makes up my contact form.
Code: [Select]
<?php $errors = array();
$missing = array();
if (isset($_POST['send'])) {
$to = 'tate.mikey@gmail.com';
$subject = 'New Feedback Received on MikeyTateLive Productions website';
$expected = array('name', 'email', 'comments');
$required = array('name', 'comments');
require ('/www/zymichost.com/m/t/l/mtlproductions/htdocs/processmail.inc.php'); } ?>
<div id="wrapper">
    <div id="maincontent">
      <p>*=required</p>
    </div>
</div>
<form id="feedback" method="get" action="">
  <p>
    <label for="name">*Name:</label></br>
    <input name="name" id="name" type="text" class="formbox">
  </p>
  <p>
    <label for="email">Email:</label></br>
    <input name="email" id="email" type="text" class="formbox">
  </p>
  <p>
    <label for="comments">*Comments:</label></br>
    <textarea name="comments" id="comments" cols="60" rows="8"></textarea>
  </p>
  <p>
    <input name="send" id="send" type="submit" value="Send"
  </p>
  </form>

how can i disply this message withing the form echo "data submitted successfully!";

currently after validation check when data is entered the message show on top of my page not within the form



function insertDATA($postData) {

if(!ifEmailExists($postData['email'])){
$sql = " INSERT INTO tbl SET
email = '".$postData['email']."',
name = '".$postData['name']."',
phone = '".$postData['phone']."'
";
                      echo "data submitted successfully!";//this line withing the form
executeSql($sql);
}

Hi I built a really simple customer review form https://kickasssoftwear.uk/dev/reviews.html (it's only been optimised for mobile view so far) and it works using the php mail script on this page https://kickasssoftwear.uk/dev/empty2.php - the emails are being sent to me and the format of the emails is OK, and the form redirects to the empty2 page with a mailsent message in the address bar.

I know I can leave that page as is and write a nice thank you message in the html - but what I really want to do is have the customers name there too, Thanks 'name' your review has been sent,

but I can't get it to work - it's been 4 whole days now and I really need to eat & sleep! Please if anyone has suggestions or advice for a noob, please help. Thanks

I have a calendar select date function for my form that returns the date in the calendar format for USA: 02/16/2012.  I need to have this appear as is for the form and in the db for the 'record_date' column, but I need to format this date in mysql DATE format (2012-02-16) and submit it at the same time with another column name 'new_date' in the database in a hidden input field.  Is there a way to do this possibly with a temporary table or something?

Any ideas would be welcome.

Doug

I have a form that searches a database then outputs the data via php how do I take the info from the radio button and the age range and search the database with it

Code: [Select]
<?php
$max_age = 18;

$ageOptions = "<option value='00'>From</option>\n";
for($age=1; $age<=$max_age; $age++)
{
$ageOptions .= "<option value='{$age}'>{$age}</option>\n";
}

?>

<form name="child_info" action="selectdata.php" method="post" id="child_info">
<table width="444" align="center" >

<tr>
<td width="208">Choose Male or Female:</td>
<td width="224">
<input type="radio" name="gender" value="male" /> Male
<input type="radio" name="gender" value="Female" /> Female
</td>
</tr>
<tr>
<td>Choose age range:</td>
<td>
<select name="first_age" id="first_age">
<?php echo $ageOptions; ?>
</select>
<select name="second_age" id="second_age">
<?php echo $ageOptions; ?>
</select>
</td>
</tr>
<tr>
<td></td>
<td>
<div align="right">
<input type="submit" name="submit" id="submit" value="submit" />
<input type="reset" name="reset" id="reset" value="reset" />
</div>
</td>
</tr>
</table>
</form>

<?php
$con = mysql_connect("localhost","","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("", $con);

$query = "SELECT picture_number, first_name, middle_name, first_family_name, second_family_name, DATE_FORMAT(birthdate, '%c-%e-%Y') as birthdate, gender
FROM child_info ORDER BY picture_number ASC";

$result = mysql_query($query);


if(!$result)
{
echo "There was a problem getting the data";
}
else if(!$result)
{
echo "There were no results";
}
else
{
echo "<b><center>Children to be sponsored</center></b><br><br>\n";
while($row = mysql_fetch_assoc($result))
{


echo "<table border='1'>
<tr>
<th>Picture Number</th>
<th>First Name</th>
<th>Middle Name</th>
<th>First Family Name</th>
<th>Second Family Name</th>
<th>Birthdate<br> M-D-Y</th>
<th>Gender</th>
</tr>";


{
echo "<tr>";
echo "<td>" . $row['picture_number'] . "</td>";
echo "<td>" . $row['first_name'] . "</td>";
echo "<td>" . $row['middle_name'] . "</td>";
echo "<td>" . $row['first_family_name'] . "</td>";
echo "<td>" . $row['second_family_name'] . "</td>";
echo "<td>" . $row['birthdate'] . "</td>";
echo "<td>" . $row['gender'] . "</td>";
echo "</tr>";
}
echo "</table>";
}
}
mysql_close();
?>

Hi all

I have a script that I have patched together and got to work in pieces.  I'm up to the last part.  I have the form working and emailing.  It also will upload an image by itself and put it in a folder.  Now i just need to tie those together and have the image put in the email as an attachment then deleted from server.

I have it at a stage where it sends me the users details.. and it tries to send the photo but it comes through as junk txt.  I think its the MIME encoding stuff that I have wrong.. not sure?

Here's what I have so far.

Code: [Select]

$attachment = $path_of_uploaded_file;
$fileatt = $attachment; // Path to the file                 
$fileatt_type = "application/octet-stream"; // File Type
    $start= strrpos($attachment, '/') == -1 ? strrpos($attachment, '//') : strrpos($attachment, '/')+1;
$fileatt_name = substr($attachment, $start, strlen($attachment)); // Filename that will be used for the file as the attachment

    $file = fopen($fileatt,'rb');
$data = fread($file,filesize($fileatt));
fclose($file);

$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
$headers = "\nMIME-Version: 1.0\n" .
            "Content-Type: multipart/mixed;\n" .
            " boundary=\"{$mime_boundary}\"";

$email_message .= "This is a multi-part message in MIME format.\n\n" .
                "--{$mime_boundary}\n" .
                "Content-Type:text/html; charset=\"iso-8859-1\"\n" .
               "Content-Transfer-Encoding: 7bit\n\n" .

$data = chunk_split(base64_encode($data));
$email_message .= "--{$mime_boundary}\n" .
                  "Content-Type: {$fileatt_type};\n" .
                  " name=\"{$fileatt_name}\"\n" .
                  "Content-Disposition: attachment;\n" .
                  " filename=\"{$fileatt_name}\"\n" .
                  "Content-Transfer-Encoding: base64\n\n" .
                 $data . "\n\n" .
                  "--{$mime_boundary}--\n";
     
// create email headers
$headers .= 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();

@mail($email_to, $email_subject, $email_message, $headers); 



Thanks

Wolfsta

I am trying to use the new way of validating the entered email in a register form.

Code: [Select]
/* REGISTER FORM */
// check if submit button has been clicked
if (isset($_POST['submit_signup'])) {

// process and assign variables after post submit button has been clicked
$user_email = strip_tags(trim($_POST['email']));
$user_email             = filter_var($user_email, FILTER_VALIDATE_EMAIL);

$nickname = strip_tags(trim($_POST['nickname']));
$password = $_POST['password'];
$repassword = $_POST['repassword'];
$month = $_REQUEST['month'];
$day = $_REQUEST['day'];
$year = $_REQUEST['year'];
$dob = $year . "-" . $month . "-" . $day;
$find_us_question = strip_tags(trim($_POST['find_us_question']));

// connect to database
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

$check_query = "SELECT * FROM user WHERE nickname = '$nickname'";

$check_connect  = mysqli_query($dbc, $check_query) or die(mysqli_error($dbc));

$check_count =  mysqli_num_rows($check_connect);

       
       
       
        // Check if the email exists twice
       
        $query_get = "SELECT email FROM user WHERE email = '$user_email'";

        $query_run = mysqli_query($dbc, $query_get);

        $num_rows = mysqli_num_rows($query_run);
       
       
       
       
       
       
       
// check if username is already taken
if ($check_count != 0) {
echo "Username already exists!";
           
               
        } elseif ($num_rows != 0) {
           
            echo "This email address is already registered in the database, you can not register it twice.";
           
           
// check if fields are empty
} elseif (empty($user_email) || empty($nickname) || empty($password) || empty($day) || empty($month) || empty($year)) {
echo "Please fill out all the fields!";

// check char length of input data
} elseif (strlen($nickname) > 30 || strlen($user_email) > 50) {
echo "Maximum allowed character length for nickname/firstname/lastname are 30 characters!";

// check password char length
} elseif (strlen($password) > 25 || strlen($password) < 6) {
echo "Your password must be between 6 and 25 characters!";

// check if passwords match with each other
} elseif ($password != $repassword) {
echo "Please make sure your passwords are matching!";

} else {
// encrypt password
$password = sha1($password);
I would like to implement now an error message stating something along the lines that the entered email address is not valid, how would I have to do the if statement to check the condition?

I have read around and can't seem to find the right coding for what I need on this forum and some other other forums.

I have a contact form (as listed below) and I need 2 locations (Print Name and Title) fields to auto-populate on a separate form (can be a doc, pdf, etc. any form of document which is easiest) and this form can be totally back end and the individual using the form never is going to see the form.

It's going on a contract form, that we would like to auto-populate.

Also is there a simple attachment code so individuals can attach documents to the code?


<p style: align="center"><form action="mailtest.php" method="POST">
<?php
$ipi = getenv("REMOTE_ADDR");
$httprefi = getenv ("HTTP_REFERER");
$httpagenti = getenv ("HTTP_USER_AGENT");
?>

<input type="hidden" name="ip" value="<?php echo $ipi ?>" />
<input type="hidden" name="httpref" value="<?php echo $httprefi ?>" />
<input type="hidden" name="httpagent" value="<?php echo $httpagenti ?>" /> 
<div align="center">
<p class="style1">Name</p> 
<input type="text" name="name">
<p class="style1">Address</p> 
<input type="text" name="address">
<p class="style1">Email</p> 
<input type="text" name="email">
<p class="style1">Phone</p> 
<input type="text" name="phone">
<p class="style1">Debtor</p> 
<input type="text" name="debtor">
<p class="style1">Debtor Address</p> 
<input type="text" name="debtora">
<br />
<br />
<a href="authoforms.php" target="_blank" style="color:#ffcb00"  vlink="#ffcb00">Click here to view Assignment Agreement and Contract Agreement</a>

<p class="style1"><input type='checkbox' name='chk' value='I Have read and Agree to the terms.'> I have read and agree to the Assignment and Contract Agreement <br></p>
<p class="style1">Print Name</p> 
<input type="text" name="pname">
<p class="style1">Title</p> 
<input type="text" name="title">


<p class="style1">I hear by agree that the information I have provided is true, accurate and the information I am submitting is <br />
not fraudulent. Please click the agree button that you adhere to Commercial Recovery Authority Inc.'s terms:</p>
<select name="agree" size="1">
<option value="Agree">Agree</option>
<option value="Disagree">Disagree</option>
</select>
<br />
<br />
<p class="style1">Employee ID:</p> 
<input type="text" name="employee">

<br />

<input type="submit" value="Send"><input type="reset" value="Clear">
</div>
</form>
</p>


The mailtest php is this
?php
$ip = $_POST['ip'];
$httpref = $_POST['httpref'];
$httpagent = $_POST['httpagent'];
$name = $_POST['name'];
$address = $_POST['address'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$debtor = $_POST['debtor'];
$debtora = $_POST['debtora'];
$value = $_POST['chk'];
$pname = $_POST['pname'];
$title = $_POST['title'];
$agree = $_POST['agree'];
$employee = $_POST['employee'];
$formcontent=" From: $name \n Address: $address \n Email: $email \n Phone: $phone \n Debtor: $debtor \n Debtor's Address: $debtora \n 'Client' has read Assignment and Contract Agreement: $value \n Print Name: $pname \n Title: $title \n I hear by agree that the information I have provided is true, accurate and the information I am submitting is not fraudulent. Please click the agree button that you adhere to Commercial Recovery Authority Inc.'s terms: $agree \n \n  Employee ID: $employee \n IP: $ip";
$recipient = "mail@crapower.com";
$subject = "Online Authorization Form 33.3%";
$mailheader = "From: $email \r\n";
mail($recipient, $subject, $formcontent, $mailheader) or die("Error!");
echo "Thank You!" . " -" . "<a href='index.php' style='text-decoration:none;color:#ffcb00;'> Return Home</a>";
$ip = $_POST['visitoraddress']
?>

Hi

I am having a problem with my form output. No matter what I search I get "No matching records". Even if I am searching words that I know should return a result. Any help would be much appreciated

 

<?php                                                 

define("PERPAGE", 15);                                                // number of records on each page

/**************************************************************************************
* function to output page selection buttons
*                     
* @param int $total   total records
* @param int $page    current page number
* @return string      selection buttons html
*/
function page_selector($total, $page)
{
    if ($total==0) {
        return '';
    }
    $kPages = ceil($total/PERPAGE);
    $filler = '&nbsp;&middot;&nbsp;&middot;&nbsp;&middot;&nbsp;';
    $lim1 = max(1, $page-2);
    $lim2 = min($kPages, $page+3);
    $p = $page==1 ? 1 : $page - 1;
    $n = $page== $kPages ? $kPages : $page + 1;;
    $out = "$kPages page" . ($kPages==1 ? '' : 's') . " &emsp;";
    if ($kPages==1) {
        return $out;
    }
    $out .= ($page > 1) ? "<div class='pagipage' data-pn='$p'>Prev</div>&ensp;" : '';
    if ($page > 4) {
        $out .= "<div class='pagipage' data-pn='1'>1</div> $filler";
    }
    elseif ($page==4) {
        $out .= "<div class='pagipage' data-pn='1'>1</div>";
    } 
    for ($i=$lim1; $i<=$lim2; $i++) {
        if ($page==$i)
            $out .= "<div class='pagicurrent'>$i</div>";
        else
            $out .= "<div class='pagipage' data-pn='$i'>$i</div>";
    }
    if ($page < $kPages-3) {
        $out .= "$filler <div class='pagipage' data-pn='$kPages'>$kPages</div>";
    }
    $out .= $page < $kPages ? "&ensp;<div class='pagipage' data-pn='$n'>Next</div>" : '';
    return $out;
}

/***********************************************
**  SEARCH FOR MATCHING TVS
************************************************/
$showResults = 0;
$search = '';
if (isset($_GET['tag'])) {
    $showResults = 1;
    $search = $_GET['tag'];
    $srch = array_unique(explode(' ', trim($_GET['tag'])));
    foreach ($srch as $t) {
        $repl[] = "<span class='hilite'>$t</span>";
        $placeholders[] = '?';
        $params[] = $t;
    }
    $params[] = count($srch);
    //
    // FINDTOTAL RECORDS IN SEARCH RESULTS                                      
    //
    $res = $db->prepare("SELECT COUNT(*) as tot
                        FROM  television
                        WHERE MATCH(title,description,keywords) AGAINST(? IN BOOLEAN MODE)
                        ");
    $res->execute($params);
    $total = $res->fetchColumn();

    $page = $_GET['page'] ?? 1;
    
    
    $params[] = ($page-1)*PERPAGE;    // append parameters offset
    $params[] = PERPAGE;              // and number of records for limit clause
    //
    // GET A PAGEFUL OF RECORDS
    //
   $sql = "SELECT 
                   id
                 , title
                 , description
                 , keywords
            FROM television
            WHERE MATCH(title,description,keywords) AGAINST(? IN BOOLEAN MODE)
            ORDER BY TITLE
            LIMIT ?,? ";
    $stmt = $db->prepare($sql);
    $stmt->execute($params);
    
    if ($stmt->rowCount()==0) {
        $results = "<h3>No matching records</h3>";
    } else {
        $results = "<tr><th>Product Id</th><th>Title</th><th>Description</th><th>Tags</th><th>Edit</th></tr>\n";
        foreach ($stmt as $rec) {
            $alltags = str_replace($srch, $repl, $rec['keywords']);
            $results .= "<tr><td>{$rec['id']}</td><td>{$rec['title']}</td><td>{$rec['description']}</td><td>$alltags</td>
            <td><a href='?action=edit&id={$rec['id']}'><img src='edit-icon.png' alt='edit'></a></td>
            </tr>\n";
        }
    }
}
?>
<div id='title'>Television Search</div>
<form id='form1'>
    <fieldset>
    <legend>Search for tags</legend>
        <input type='text' name='tag' size='50' value='<?=$search?>' placeholder='Search for...' >
        <input type="hidden" name="page" id="page" value="1">
        <input type="hidden" name="action" id="page" value="search">
        <input type="submit" name="btnSub" value="Search">
    </fieldset>
    <div id='formfoot'></div>
</form>
<?php if ($showResults) { ?>
         <div class="paginate_panel">
             <?=page_selector($total, $page)?>
         </div>
         <table border='1'>
             <?=$results?>
         </table>
<?php } ?>