Learn VBA & Macros in 1 Week!

PHP - Popup Boxes?

Full Excel VBA Course - Beginner to Expert

Popup Boxes?	View Content

Im having a problem in popup box..
i made a checkbox in a loop.. then after a success loop ive set a code for a popupbox.

Code: [Select]
echo '<script type="text/javascript">
{alert("Rejected!");}
</script>';

But when a user checked 2 check boxes.. it would also popup a 2 popup box..
How can i make my code only popup once even if it selects multiple checkboxes?

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Need A Popup Code That Can Run Like Popup();

Drop Down Boxes

Check Boxes Help

Drop Down Boxes

Dynamic Check Boxes

Getting Values From Radio Boxes

Question About Multiple Boxes

Populating Dropdown Boxes

Working With Select Boxes

Multiple Check Boxes

Looking For A Better Way To Handle Check Boxes

My Check Boxes Are Not Being Sent In The Email

Problem With Select Boxes

Mysql Update With Check Boxes

Tick Boxes And Database Question

Populate Check Boxes From A Database.

Need Help With Check Boxes, Validation And Sessions

Cure For Long Drop Down Boxes

Learn VBA & Macros for Excel in 1 Week!

Need A Popup Code That Can Run Like Popup();

Similar Tutorials

I have search the forum, but i cant find something thats about my problem.. :S

Im trying to make a kind of a community website for my friends and others who want to be there.. (Its danish)..
I got alot of stuff going in the codes, and now i want some kind of a popup to tell the user when they got a new msg, i trying alot of stuff but i cant find something that works with my codes..

...

I got 2 iframes in the background running to update user status and stuff, i want one of them to create a popup when a new msg is in for the Session user..

This is one of the update pages i got running..

<script>
setTimeout("document.location.reload(true);", 60000);
</script>
<head>

<link rel="stylesheet" type="text/css" href="style_blue.css">
</head>
<?
require_once('#####.php'); //database access
require_once('#####.php'); // php functions
session_start();

if (isset($_SESSION['user']) AND ($_SESSION['user'] <> ''))
{
$result = mysql_query("UPDATE users SET time = '".time()."' WHERE id = '$_SESSION[id]'");
}

$result2 = mysql_query("SELECT id FROM msg WHERE to = '$_SESSION[id]' AND new = '1'");
$antal2 = ( mysql_num_rows($result2) );

if (($antal2 > '0'))
{
## Here i need a code to create a popup telling the user that there is a new msg..
}

?>

I really hope someone can help me... :S
Btw.. i dont wanna use alert popup cuz then they will stack if a user goes out for a few hours but stays on website..

Drop Down Boxes

Similar Tutorials

Hi all

Im looking to do a "SIMPLE" search on a databse usign php.

I want to have a drop down box like so :

<select name="Lowest">
<option>0</option>
<option>100</option>
<option>200</option>
</select>

this is for the prices i want 2 of these so that the first will be the lowest price and the second will be the higher price

Then i will make a query to SELECT * WHERE ( i dont know how to call the results from the select box here to display the whole tabled results )

any help please

thnax

Check Boxes Help

Similar Tutorials

Hi, im new to php and got a simple query.

i have built a web gallery and i want to add keywords to pictures, ive built the interface and mysql statements so it lists all possible keywords and creates a tick box for the user to use.

ive created a table to join the image id's to my keyword id's as its going to be a many to many relationship, ive also built the sql statement below to select the highlighted image, but im not sure how i can join the looping of all keywords to generate the tick boxes and then to loop again to populate the tickboxes that are saved within the DB - if that makes sense??

SELECT * FROM images,img_key,keywords where img_key.img_id=images.id and keywords.id=img_key.key_id and images.id='2'

Search Boxes

Similar Tutorials

I am trying to add two search boxes to the below code. I need First Name, Last Name and Skill. I have added the boxes and connected fname (first_name) but am not sure how to link the other two correctly. Can anybody please help? I think it's something to do with the bold red text.

Thanks

<h3>Search Contacts Details</h3>
<p>You may search either by first or last name</p>
<form method="post" action="a.php?go" id="searchform">
<input type="text" name="fname">
<input type="text" name="lname">
<input type="text" name="skill">
<input type="submit" name="submit" value="Search">
</form>

<?php

if(isset($_POST['submit'])){
if(isset($_GET['go'])){
if(preg_match("/^[ a-zA-Z]+/", $_POST['fname'])){
$fname=$_POST['fname'];

//connect to the database
$db=mysql_connect ("127.0.0.1", "root", "") or die ('I cannot connect to the database because: ' . mysql_error());

//select the database to use
$mydb=mysql_select_db("resource matrix");

//query the database table
$sql="SELECT DISTINCT First_Name, Last_Name, l.Resource_ID FROM ((resource l inner join resource_skill ln on l.Resource_ID = ln.Resource_ID) inner join skill n on ln.Skill_ID = n.Skill_ID) WHERE First_Name LIKE '%" . $fname . "%' OR Last_Name LIKE '%" . $lname ."%' OR Skill_Name LIKE '%" . $skill ."%'";

Drop Down Boxes

Similar Tutorials

Hi

I have 3 drop down boxes and I want my boxes to go to another page when I select them and click go. For example if I click western cape I want it to give me all the resorts in western cape and if I click western cape and beaches I want it to give me all the resorts that are in the western cape that are next to beaches. I have been able to populate the drop down boxes with information and it can go to another page but it doesn't give me the information I want.

This is my drop down boxes code

Code: [Select]
<script type="text/javascript">

function showGo(){

var region_id = $("#region_id").val();

var lifestyle_id = $("#lifestyle_id").val();

var resort_facility_id = $("#resort_facility_id").val();

if((region_id != 'false') || (lifestyle_id != 'false') || (resort_facility_id != 'false')){

$("#destinationSearchButton").css('display', 'block');

}else{

$("#destinationSearchButton").css('display', 'none');

}

</script>

<form action="/pages/search/" method="post">

<select class="formSelect" name="region_id" id="region_id" size="1" tabindex="1" onchange="showGo()">
<option label="Region">
<?php

$regions_model = new regions_model('regions');
$regions = $regions_model -> get_all();

foreach($regions as $region){
$name = $region['name'];
$id =$region['id'];

$select = "SELECT $id, $name FROM regions";
echo "<option value='$id'>$name</option>";
} ?>
</option>

</select>

<select class="formSelect" name="lifestyle_id" id="lifestyle_id" size="1" tabindex="2" onchange="showGo()">
<option label="lifestyle">
<?php

$lifestyles_model = new lifestyles_model('lifestyles');
$lifestyles = $lifestyles_model -> get_all();

foreach($lifestyles as $lifestyle){
$name = $lifestyle['name'];
$id = $lifestyle['id'];

$select = "SELECT $name FROM lifestyles";
echo "<option name='$id'>$name</option>";
} ?>
</option>
</select>

<select class="formSelect" name="resort_facility_id" id="resort_facility_id" size="1" tabindex="3" onchange="showGo()">
<option label="Facilities & Amenities">
<?php

$resort_facilities_model = new resort_facilities_model('resort_facilities');
$resort_facilities= $resort_facilities_model -> get_all();

foreach($resort_facilities as $resort_facility){
$name = $resort_facility['name'];
$id = $resort_facility['id'];

$select = "SELECT $name FROM resort_failities";
echo "<option name='$id'>$name</option>";
} ?>
</option>
</select>

<input class="formInputButton" type="submit" name="submitButtonName" id="destinationSearchButton" value="Go" tabindex="4"/ style="display: none;" />
</form>
</div>

Thank you

Dynamic Check Boxes

Similar Tutorials

I was using this wonderful tutorial on dynamic check boxes and databases http://www.phpfreaks.com/tutorial/working-with-checkboxes-and-a-database . This example is uses checkboxes to give users admin rites.

I have tried to revamp this code to handle more inputs from checkboxes but some where I have made some errors.

<?php
include("db.php");
$updated = FALSE;
if(count($_POST) > 0){
    $DEP = $_POST['MMARS_DEP'];
    array_map('intval',$DEP);
    $DEP = implode(',',$DEP);
    mysql_query("UPDATE master_roles SET MMARS_DEPT=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_DEPT=1 WHERE id IN ($DEP)") or trigger_error(mysql_error(),E_USER_ERROR);
    $MD = $_POST['MMARS_MD'];
    array_map('intval',$MD);
    $MD = implode(',',$MD);
    mysql_query("UPDATE master_roles SET MMARS_MD=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_MD=1 WHERE id IN ($MD)") or trigger_error(mysql_error(),E_USER_ERROR);
    $ORG = $_POST['MMARS_ORG'];
    array_map('intval',$ORG);
    $ORG = implode(',',$ORG);
    mysql_query("UPDATE master_roles SET MMARS_ORG=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_ORG=1 WHERE id IN ($ORG)") or trigger_error(mysql_error(),E_USER_ERROR);
    $SEC = $_POST['MMARS_SEC'];
    array_map('intval',$SEC);
    $SEC = implode(',',$SEC);
    mysql_query("UPDATE master_roles SET MMARS_SEC=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_SEC=1 WHERE id IN ($SEC)") or trigger_error(mysql_error(),E_USER_ERROR);
    $BOG = $_POST['MMARS_BOG'];
    array_map('intval',$BOG);
    $BOG = implode(',',$BOG);
    mysql_query("UPDATE master_roles SET MMARS_BOG=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_BOG=1 WHERE id IN ($BOG)") or trigger_error(mysql_error(),E_USER_ERROR);
    $SW = $_POST['MMARS_SW'];
    array_map('intval',$SW);
    $SW = implode(',',$SW);
    mysql_query("UPDATE master_roles SET MMARS_SW=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_SW=1 WHERE id IN ($SW)") or trigger_error(mysql_error(),E_USER_ERROR);

   $updated=TRUE;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>phpfreaks checkbox tutorial</title>
</head>
<body>
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<?php
if($updated===TRUE){
    echo '<div>Privileges Updated!</div>';
}
?>
<table>
<tr>
<th><td>DEPT</td><td>MD</td><td>ORG</td><td>SEC</td><td>BOG</td><td>SW</td></th>
<?php

$label = array('MMARS','LCM','NM SEC','Classic MMARS','CAPS','PMIS','WRK COMP');
$table = array('MMars','LCM', 'NMSec', 'ClassMars', 'CAPS', 'PMIS', 'WrkComp');

     $i= 0;
     while($i < 1){

     echo "<tr>"
     ."<td>".$label[$i]."</td>";

$array = array();
$count = 0;

$Aid = mysql_query("SELECT DISTINCT id FROM DB") or die (mysql_error());

while ($row= mysql_fetch_assoc($Aid)){
$ID = $row['id']."<br>";
$array[$count] = $ID;
$count++;
}

$Disabled ="";
$sql = "SELECT id, UAID, DB_NAME, MMARS_DEPT, MMARS_MD, MMARS_ORG, MMARS_SEC, MMARS_BOG, MMARS_SW  FROM master_roles  WHERE `UAID`='1000' AND id <= 6";

$result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR);
$row = mysql_fetch_row($result);
list($id, $UAID, $DB_NAME, $MMARS_DEP, $MMARS_MD, $MMARS_ORG, $MMARS_SEC, $MMARS_BOG, $MMARS_SW)= $row;

                $checked = ($MMARS_DEPT==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[0].'<input type="checkbox" name="MMARS_DEP[]" value="'.$array[0].'" '.$checked.' , '.$Disabled.' /></td>';
        $checked = ($MMARS_MD==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[1].'<input type="checkbox" name="MMARS_MD[]"  value="'.$array[1].'"  '.$checked.' , '.$Disabled.' /></td>';
        $checked = ($MMARS_ORG==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[2].'<input type="checkbox" name="MMARS_ORG[]"  value="'.$array[2].'"  '.$checked.' , '.$Disabled.' /></td>';
        $checked = ($MMARS_SEC==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[3].'<input type="checkbox" name="MMARS_SEC[]"  value="'.$array[3].'" '.$checked.' , '.$Disabled.' /></td>';
        $checked = ($MMARS_BOG==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[4].'<input type="checkbox" name="MMARS_BOG[]" value="'.$array[4].'" '.$checked.' , '.$Disabled.' /></td>';
        $checked = ($MMARS_SW==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[5].'<input type="checkbox" name="MMARS_SW[]" value="'.$array[5].'" '.$checked.', '.$Disabled.' /></td>';

     echo "</tr>";
     $i ++;
     }

?>
<tr><td colspan="2"><input type="submit" name="submit" value="Update Privileges" /></td></tr>
</table>
</form>
</body>
</html>

After the post each individual checkbox input is saved into a variable then we query the database and check if any of the checkboxes have been changed to 1. If so then than right is updated to one.

if(count($_POST) > 0){
    $DEP = $_POST['MMARS_DEP'];
    array_map('intval',$DEP);
    $DEP = implode(',',$DEP);
    mysql_query("UPDATE master_roles SET MMARS_DEPT=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_DEPT=1 WHERE id IN ($DEP)") or trigger_error(mysql_error(),E_USER_ERROR);
    $MD = $_POST['MMARS_MD'];
    array_map('intval',$MD);
    $MD = implode(',',$MD);
    mysql_query("UPDATE master_roles SET MMARS_MD=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_MD=1 WHERE id IN ($MD)") or trigger_error(mysql_error(),E_USER_ERROR);
    $ORG = $_POST['MMARS_ORG'];
    array_map('intval',$ORG);
    $ORG = implode(',',$ORG);
    mysql_query("UPDATE master_roles SET MMARS_ORG=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_ORG=1 WHERE id IN ($ORG)") or trigger_error(mysql_error(),E_USER_ERROR);
    $SEC = $_POST['MMARS_SEC'];
    array_map('intval',$SEC);
    $SEC = implode(',',$SEC);
    mysql_query("UPDATE master_roles SET MMARS_SEC=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_SEC=1 WHERE id IN ($SEC)") or trigger_error(mysql_error(),E_USER_ERROR);
    $BOG = $_POST['MMARS_BOG'];
    array_map('intval',$BOG);
    $BOG = implode(',',$BOG);
    mysql_query("UPDATE master_roles SET MMARS_BOG=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_BOG=1 WHERE id IN ($BOG)") or trigger_error(mysql_error(),E_USER_ERROR);
    $SW = $_POST['MMARS_SW'];
    array_map('intval',$SW);
    $SW = implode(',',$SW);
    mysql_query("UPDATE master_roles SET MMARS_SW=0") or trigger_error(mysql_error(),E_USER_ERROR);
    mysql_query("UPDATE master_roles SET MMARS_SW=1 WHERE id IN ($SW)") or trigger_error(mysql_error(),E_USER_ERROR);

The html is a straight forward form. I have arrays set up and while loop ready for implementation because I plan on having this repeat multiple times.

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>phpfreaks checkbox tutorial</title>
</head>
<body>
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<?php
if($updated===TRUE){
    echo '<div>Privileges Updated!</div>';
}
?>
<table>
<tr>
<th><td>DEPT</td><td>MD</td><td>ORG</td><td>SEC</td><td>BOG</td><td>SW</td></th>
<?php

$label = array('MMARS','LCM','NM SEC','Classic MMARS','CAPS','PMIS','WRK COMP');
$table = array('MMars','LCM', 'NMSec', 'ClassMars', 'CAPS', 'PMIS', 'WrkComp');

     $i= 0;
     while($i < 1){

     echo "<tr>"
     ."<td>".$label[$i]."</td>";

I had a lot of problems keeping the id unique for each checkbox. This is why I created an array with the ids and I use them as "value" in the input field.

$array = array();
$count = 0;

$Aid = mysql_query("SELECT DISTINCT id FROM DB") or die (mysql_error());

while ($row= mysql_fetch_assoc($Aid)){
$ID = $row['id']."<br>";
$array[$count] = $ID;
$count++;
}

I sql the database for id, UAID, DB_NAME, and all of the necessary rites. With list I assign each row with the correct name. Each checkbox's associated field in the db is checked to see if it is set to 1. If it is checked="checked".

$sql = "SELECT id, UAID, DB_NAME, MMARS_DEPT, MMARS_MD, MMARS_ORG, MMARS_SEC, MMARS_BOG, MMARS_SW  FROM master_roles  WHERE `UAID`='1000' AND id <= 6";
$result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR);
$row = mysql_fetch_row($result);

list($id, $UAID, $DB_NAME, $MMARS_DEPT, $MMARS_MD, $MMARS_ORG, $MMARS_SEC, $MMARS_BOG, $MMARS_SW)= $row;

        $checked = ($MMARS_DEPT==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[0].'<input type="checkbox" name="MMARS_DEP[]" value="'.$array[0].'" '.$checked.' , '.$Disabled.' /></td>';
        $checked = ($MMARS_MD==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[1].'<input type="checkbox" name="MMARS_MD[]"  value="'.$array[1].'"  '.$checked.' , '.$Disabled.' /></td>';
        $checked = ($MMARS_ORG==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[2].'<input type="checkbox" name="MMARS_ORG[]"  value="'.$array[2].'"  '.$checked.' , '.$Disabled.' /></td>';
        $checked = ($MMARS_SEC==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[3].'<input type="checkbox" name="MMARS_SEC[]"  value="'.$array[3].'" '.$checked.' , '.$Disabled.' /></td>';
        $checked = ($MMARS_BOG==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[4].'<input type="checkbox" name="MMARS_BOG[]" value="'.$array[4].'" '.$checked.' , '.$Disabled.' /></td>';
        $checked = ($MMARS_SW==1) ? 'checked="checked"' : '';
        echo '<td>'.$array[5].'<input type="checkbox" name="MMARS_SW[]" value="'.$array[5].'" '.$checked.', '.$Disabled.' /></td>';

I am attaching a print out of my joined table I am querying as well as my final vision for this form.

In advance, thank you for your help.

Getting Values From Radio Boxes

Similar Tutorials

I have a form that contains radio buttons and when it is submitted the content of the form are added to a database. I was wondering how you get the values of radio boxes when submitting the form. I have the following radio buttons and when submitting I use "$_POST['article_type']" but this doesn't seem to work. Thanks for any help.

<label>PDF Article</label><input name="article_type" value="pdf" type="radio" />
<label>Video Webcast</label><input name="article_type" value="webcast" type="radio" />
<label>Podcast</label><input name="article_type" value="podcast" type="radio" />

Question About Multiple Boxes

Similar Tutorials

I want to create a calculator that allows you to type in how many pieces of data you have, or how many averages you have. Once that is done, the amount of boxes pop up correctly - and you can enter in your data. But how can I get all those pieces of data from EACH box using one form?

Current Example: http://novacms.vacau.com/

Code:

<?php

$boxes = $_POST['input'];

if(!$boxes)
{
echo '<b>How many pieces of data do you have?</b> <form action="index.php" method="POST"><input type="text" name="input"><input type="submit"></form><br/><font size="2">Ex: 88.8,92.3,76.5 - That would be 3 pieces of data</font>';
}
else
{
echo '<form action="index.php" method="POST">';
for($i = 0; $i <= $boxes; $i++)
{
echo '<input type="text"><br/>';
}
echo '<input type="submit" value="Get average"></form>';
}
?>

Populating Dropdown Boxes

Similar Tutorials

I am trying to figure out how to display member records after selecting it from the box. I've got the dropdown box working which retrieves the members name but cannot figure out how to populate that members details on the same page?

I'm using php/mysql and although I want to display the records I also want a user to update that record aswell, creating it for administrators to update accounts?

Any help would be appreciated

I've researched that ajax or javascript might be helpful but not totally familiar with them.

Working With Select Boxes

Similar Tutorials

Hi There,

Is there any way that I can get a select box to auto-select the value from a SQL query? For example, if I have a select box like this:

Dave,Jon,Simon,Fred

And a select statement that brings back the value of Fred then the select box (in HTML) would:

<select name='people'><option>Dave</option><option>Jon</option><option>Simon</option><option selected='selected'>Fred</option></select>

Same as if the name was Dave, or Simon etc etc.

Hope that makes sense?

Cheers
Matt

Multiple Check Boxes

Similar Tutorials

Is it possible to have multiple check boxes on a single form and a single submit button tp post the values into different rows of DB

Kenny

Looking For A Better Way To Handle Check Boxes

Similar Tutorials

Hi guys

On the edit profile page on my website, im trying to get is so that when the user first opens the page, if the database field reads "1" the checkbox is checked. However if the user unchecks it and makes a mistake on the form which returns an error, the checkbox remains unchecked. Also if the user unchecks the text box, the 1 in the database is changed to a 0. And vise versa.

The only way i have got it to work succesfully is by using the following:

<?php
$test = $_POST['test'];
$submit = $_POST['submit'];

if (!isset($test))

{

$test="0";

}

else

{

$test="1";

}

if ($submit)
{

mysql_query("UPDATE profiles SET test='$test' WHERE username='user'");

echo "ok";
}
?>
<html>
<form action="test.php" method="POST">
<input type="checkbox" name="test" <?php if ($submit) { if ($test=="1") { echo "checked='checked'";}} else { if ($row['test'] == "1") {echo "checked='checked'";}} ?> />
<input type="submit" name="submit" />
</form>
</html>

My problem is, i have about 60 check boxes on the page, and i dont really want to write the code below for all of them:

if (!isset($test))
{

$test="0";
}
else
{

$test="1";
}

Does anybody know a better way to do this so i dont end up with 420 lines of extra code?

Many thanks.

My Check Boxes Are Not Being Sent In The Email

Similar Tutorials

I cannot figure out why my checkbox values are not being included in my emails I am posting my html and my php.

<form method="post" action="../leaf.php">
                  <input type="hidden" name="subject" value="Cleanup">


<div>
                <table width="425" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><label><span class="ie7bugfix01">Name:<span class="colour">*<br />
    </span></span> <input type="text" name="contact-name" class="text" value="" /></label></td>
    <td><label><span class="ie7bugfix01">Email:<span class="colour">*</span></span><br />
<input type="text" name="contact-email" class="text" value="" /></label></td>
  </tr>
  <tr>
    <td>      <label><span class="ie7bugfix01">Phone No:</span> <br />
      <input type="text" name="contact-mobile" class="text" value="" /></label>
 </td>
  </tr>
    <tr>
    <td><label><span class="ie7bugfix01">Address:<br />
    </span> <input type="text" name="contact-street" class="text" value="" /></label></td>
    <td><label><span class="ie7bugfix01">City:</span><br />
<input type="text" name="contact-city" class="text" value="" /></label></td>
  </tr>
 <tr>
    <td><label><span class="ie7bugfix01">Property Size:<br />
    </span> <input type="text" name="property-size" class="text" value="" /></label></td>
    
  </tr>
  <tr>
   <td><label><span class="ie7bugfix01">Service request:</span><br /></label>
<input type="checkbox" name="projects[]" value="Lawn Maintenance">
   <label for="type1">Lawn Maintenance</label>
   <br>
   <input type="checkbox" name="projects[]" value="Mulching">
   <label for="type2">Mulching</label>
   <br>
   <input type="checkbox" name="projects[]" value="Gutter Cleaning/Repair">
   <label for="type3">Gutter Cleaning/Repair</label> <br>
   <input type="checkbox" name="projects[]" value="Revitalization">
   <label for="type1">Revitalization</label>
   <br>
<input type="checkbox" name="projects[]" value="Power Washing">
   <label for="type2">Power Washing</label>
   <br>
   </td><td>
   <br>
   <input type="checkbox" name="projects[]" value="Hardscapes">
   <label for="type3">Hardscape</label>
   <br>
   <input type="checkbox" name="projects[]" value="Deck Work">
   <label for="type3">Deck Treatments/Repair/Construction</label>
   <br>
   <input type="checkbox" name="projects[]" value="Snow Removal">
   <label for="type3">Snow Removal</label>
   <br><input type="checkbox" name="projects[]" value="Tree Trimming">
   <label for="type3">Tree Trimming/Removal</label>
   <br>
<input type="checkbox" name="projects[]" value="Privacy Barriers">
   <label for="type3">Privacy Barriers</label> 
   </td></tr>
  <tr>
  </tr>
</table>
<label><span class="ie7bugfix01">Describe your project:<span class="colour">*</span></span><br />
<textarea name="contact-comments" class="text" cols="68" rows="5"></textarea></label>
      
      
      
      <p class="submit">
                   <input type="submit" class="submit" value="submit" />
                   <input type="button" class="reset" value="reset" />
      </p>
     </div></form>


<?php 
$from = $_REQUEST['contact-email'] ; 
$name = $_REQUEST['contact-name'] ;
$subject = $_REQUEST['subject'] ; 
$headers = "From: $from"; 
$headers = "Subject: $subject"; 


$fields = array(); 
$fields{"subject"} = "Subject"; 
$fields{"contact-name"} = "Name"; 
$fields{"contact-email"} = "E-mail";
$fields{"contact-mobile"} = "Phone";
$fields{"contact-street"} = "Address";
$fields{"contact-city"} = "City";
$fields{"property-size"} = "Size";
$selectedProjects  = 'None';


if(isset($_POST['projects']) && is_array($_POST['projects']) && count($_POST['projects']) > 0){
    $selectedProjects = implode(', ', $_POST['projects']);
}


$body .= 'Selected Projects: ' . $selectedProjects;
$fields{"contact-comments"} = "Message"; 


$body = "We have received the following information:\n\n"; foreach($fields as $a => $b){ $body .= sprintf("%20s: %s\n",$b,$_REQUEST[$a]); } 


$headers2 = "From: t***@toma***.com"; 
$subject2 = "Thank you for contacting us"; 
$autoreply = "Thank you for contacting us. Somebody will get back to you as soon as possible, usualy within 48 hours. 


By choosing TOMA you will be able to enjoy your time off with the peace of mind that your lawn is always professionally serviced.  Never worry about finding time to work in the lawn again and gain back at least 35 hours of summer this season!


TOMA provides weekly as needed lawn maintenance for your home or business. We are dedicated to every detail of your unique lawn. We always arrive with sharp blades, we police your property and we make sure everything is left freshly groomed and clean. Easy to sign up, easy billing, invest in your home and time today!


FREE ESTIMATES WHEN YOU CALL ________.


If you have any more questions, please consult our website at www.t**.com or call _________ to get started.";


if($from == '') {print "You have not entered an email, please go back and try again";} 
else { 
if($name == '') {print "You have not entered a name, please go back and try again";} 
else { 
$send = mail("t***@t**.com", $subject, $body, $headers); 
$send2 = mail($from, $subject2, $autoreply, $headers2); 
if($send) 
{header( "Location: http://www.**t.com/thank-you.html" );} 
else 
{print "We encountered an error sending your mail, please try again"; } 
}
}
?>

Problem With Select Boxes

Similar Tutorials

Hey guys, My problem is, iam loading with mysql_fetch_array a table from my database and draw it into my website page. The table is a user table which has an id, user, password and rights(Admin, Mod , User). Only the rights are given out as <select> </select> boxes with the 3 options(Admin, Mod , User). And i also have 1 more column which has for each row a href to a new site with the id of the array_index as paramter. My Problem is i want to know which select box was changed and which option is selected so i can change the rights in my database of this user with the right id. At the moment i cant post the code in here cause i have a problem with my laptop now. I hope you can help me, Thank you
Edited by Kandey, 30 October 2014 - 02:28 PM.

Popup Div

Similar Tutorials

i have a div with an iframe in it that when i click on a link it pops up but what i am trying to do is add ?old=$folderName to the link but when i do the popup is blank. so does anyone know something i can try. (i am using facebox to create the popup)

Code: [Select]
this is the link for the popup
<a href='#Rename' rel='facebox'>Rename</a>

this is with ?old=$folderName added this displays the blank popup
<a href='#Rename?old=$folderName' rel='facebox'>Rename</a>

this is the div with iframe
Code: [Select]
<div id="Rename" style="display:none"><iframe src="form.php?old=<?php echo $old=$_GET['old'] ?>" frameborder="0">
</iframe></div>

Mysql Update With Check Boxes

Similar Tutorials

im developing a voting system where you can vote for multiple choices using checkboxes..
upon submitting the vote form, votecounts must automatically be updated.. values for votecount will come from the checkbox value 1.

ive been having a hard time trying to figure out hot to update multiple rows with checkbox values..any help would be appreciated..thanks in advance!

here's the code:

Code: [Select]
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form_vote"))
$i=1;{
while ($i<= $totalRows_rs_candi) {
$updateSQL = "UPDATE tbl_candidates SET votecount={$_POST['votecount']} WHERE user_id={$_POST['candi']}";

mysql_select_db($database_organizazone_db, $organizazone_db);
$Result1 = mysql_query($updateSQL, $organizazone_db) or die(mysql_error());

$i++;
}

if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo = "vote_success.php";
}
header(sprintf("Location: %s", $updateGoTo));
}

Code: [Select]
<form id="form_vote" name="form_vote" method="POST" action="<?php echo $editFormAction; ?>">
<table border="1">
<tr>
<td> </td>
<td>user_id</td>
<td>l_name</td>
<td>course_id</td>
<td>yearlevel</td>
<td>about</td>
</tr>
<?php $i=1; do { ?>
<tr>
<td><span id="sprycheckbox1">
<input name="votecount[<?php echo $i ?>]" type="checkbox" id="votecount" value="1" />
<span class="checkboxMinSelectionsMsg">Minimum number of selections not met.</span></span>
<label for="votecount[]"></label></td>
<td><label for="candi"></label>
<input name="candi" type="text" disabled="disabled" id="candi" value="<?php echo $row_rs_candi['user_id']; ?>" readonly="readonly" /></td>
<td><?php echo $row_rs_candi['l_name'].' ,'.$row_rs_candi['f_name'].' '.$row_rs_candi['m_name']; ?></td>
<td><?php echo $row_rs_candi['course_id']; ?></td>
<td><?php echo $row_rs_candi['yearlevel']; ?></td>
<td><?php echo $row_rs_candi['about_me']; ?></td>
</tr>
<?php $i++; ?>
<?php } while ($row_rs_candi = mysql_fetch_assoc($rs_candi)); ?>
</table>

Tick Boxes And Database Question

Similar Tutorials

hello.

i have a question for you.

say i have a group of tick boxes and i select a couple.

would i put them in to the database as varchar ?
like this:

id varchar
1 1, 2, 3

or

id varchar
1 '1', '2', '3'

then my next question is how would i use them.
i guess i would explode them or something.

the thing is, i have some code that currently pull 1 item from the database (using varchar) and echos it fine but when i add more i get nothing back.

thanks
rick

Populate Check Boxes From A Database.

Similar Tutorials

I have a set of 26 checkboxes that are stored in an array. The below code dumps the comma separated array values into a single record column.

Code: [Select]
// dumping the type of job checkboxes

$type = $_POST['type'];
var_dump($type);

// Setting up a blank variable to be used in the coming loop.
$allStyles = "";

// For every checkbox value sent to the form.
foreach ($type as $style) {
// Append the string with the current array element, and then add a comma and a space at the end.
$allTypes .= $style . ", ";
}

// Delete the last two characters from the string.
$allTypes = substr($allTypes, 0, -2);

// end dumping the type of job checkboxes

This works great! But my needs go past this. The record can be edited. So I need to get the values back out of the database and populate the correct check boxes for editing.

The checkboxes are generated by this code.

Code: [Select]
<div class="text">Job Type (<a class="editlist" href="javascript:editlist('listedit.php?edit=typelist',700,400);">edit list</a>):</div>
<div class="field">

<?PHP

$connection=mysql_connect ("localhost", "name", "pass") or die ("I cannot connect to the database.");
$db=mysql_select_db ("database", $connection) or die (mysql_error());
$query = "SELECT type FROM typelist ORDER BY type ASC";
$sql_result = mysql_query($query, $connection) or die (mysql_error());
$i=1;
echo '<table valign="top"><tr><td>';
while ($row = mysql_fetch_array($sql_result)) {
$type = $row["type"];
if ($i > 1 && $i % 26 == 0)
echo '</td><td>';
else if ($i)
echo '';
++$i;
echo "<input style='font-size:10px;' name='type[]' type='checkbox' value='$type'><span style='color:#000;'>$type</span></input><br/>";
}
echo '</td></tr></table>';

?>

</div>

I am having a problem getting these checkboxes repopulated. I think that a way to do this is to:

Get the values out of the database in a array
Compare the values the list of all possible values.
Check the boxes of the values confirmed to be there.

I didn't build the application so I need help to work through this problem.

Need Help With Check Boxes, Validation And Sessions

Similar Tutorials

Hey guy, I have a form where I want to validate if the check boxes have been checked or not and store that in a session. If a box is not selected I want an error message to echo. With what I've done so far, if a box is selected the form works but if one is not selected my error message does not show and I get an undefined Index Notice. Can anyone tell me where I'm going wrong.

Page 1- form
<form action="processPage7.php" method="post">
<br />
<p>Check the times you are most likely to have available:</p>
   <input type="checkbox" name="days[]" value="Evenings" <?php if(isset($_POST['days']) == 'Evenings') echo 'checked' ?>> Weekday evenings<br />
   <input type="checkbox" name="days[]" value="Weekdays" <?php if(isset($_POST['days']) == 'Weekdays') echo 'checked' ?>> Week Days<br />
   <input type="checkbox" name="days[]" value="Weekends" <?php if(isset($_POST['days']) == 'Weekends') echo 'checked' ?>> Weekend Days<br />
</div><br /><br />
<p><input type="submit" value="Next Page" /></p><input type="reset" value="Reset" />
</form>

Page 2-
<?php
session_start();

if($_SERVER['REQUEST_METHOD']== 'POST'){
$valid_form = TRUE; // NO PROBLEMS

if(!isset($_POST['days'])){
   echo "Error, no time selected. Please go back and select a time.";
}else{
   $_SESSION['days'] = $_POST['days'];
}
if($valid_form == TRUE){
   header('Location: FormProcess.php');
}
}
?>
And Page 3
<?php
session_start();

   $days = $_SESSION['days'];

   $chkResults = $days;
   for ($i = 0;$i<=count($chkResults)-1;$i++){
      echo "<p>". $days[$i];

   }
?>
Thanks in advance.

Cure For Long Drop Down Boxes

Similar Tutorials

I have a shopping cart in the backend there is drop down for navigating through the categories and sub categories, but I'm looking for a better way as I have over 3 thousand categories! and I need a better and faster way to navigate the categories. Any ideas?