Learn VBA & Macros in 1 Week!

PHP - Select Multiple Values From Mysql Between Intervals

Full Excel VBA Course - Beginner to Expert

Select Multiple Values From Mysql Between Intervals	View Content

hi all

please help...

i would like to get datas between certain intervals.
please have a look @ db_table.jpg, it's the db structure. the red highlighted part is the value i need.

condition is select values when both device one & device two are off.

db_table_report.jpg is the resulting report format. It contains start time & end time and the duration..

please help, i know it's a bit complicated, but it's urgent.

Full Excel VBA Course - Beginner to Expert

How To Get Multiple Select Values Through Post On Php.

Similar Tutorials

View Content

Hi guys, I am trying to create a script that gets a multiple select form selections and assign them to variables with php via the POST method.

This is my code:

Code: [Select]
<select name="search_commodity[]" multiple="multiple" size="3" style="position:absolute; top:80px; left:414px; " >
<option value="all">All</option>
<option value="none">None</option>
<option value="some">Some</option>
</select>

Then after the form gets submited then it should go to this php page and the first value of the chosen options has to be assigned to the variable called commo. The problem is that is is not assigning anything.
Code: [Select]

<?php $commo = $_POST['search_commodity[0]']; ?>

Can someone help please? I can't figure it out.

Php Mysql Time Intervals

Similar Tutorials

View Content

Hello guys. I am creating a PHP/mySQL based RPG. I have implemented training feature in it. So i want to make training possible every 15 minutes or so. Can you give me an advice how to achieve that? Thank you!

Inserting Multiple Values Into Mysql

Similar Tutorials

View Content

Hi People

i'm a newb at this so bare with me but i currently have a php file called Newkpi.php which has a select statement in. this selects data from a table called "StaffList".
this then populates the page with a html table with 14 records (this will increase/decrease over time) i then have some extra text boxes to enter more detail into like service amaount service date and so on.
when i click the submit button i want it to cycle through each row and insert the data into a separate table called "Services". however i cannot for the life of me get this to work and need some help with it. people find attached the code for Newkpi and see if you can help me with this.

in total i want it to take the names from stafflist and populate Services with the names and the extra detail which is entered on the page

Much Thanx in advance

SLOWIE

Updating Multiple Values Mysql Table

Similar Tutorials

View Content

Apologies... I'm a noob trying to reverse engineer code.

I have a script that can retrieve values from a MySQL database (based on a session login that recognizes which user you are) and places those values into the text fields of a form, pre-populating the form.

Code: [Select]
<?php
mysql_connect('localhost', 'db', 'password');
mysql_select_db('users');

$id     =  mysql_real_escape_string($_SESSION['userid']);
$select =  "SELECT * FROM user_info WHERE md5(Member_No) = '$id';";
$query  =  mysql_query($select);
if ($row = mysql_fetch_array($query)) {
?>
<form>
FIRST name: <input type="text" name="First" value="<?php echo stripslashes($row['First']); ?>"
LAST name: <input type="text" name="Last" value="<?php echo stripslashes($row['Last']); ?>" >
Birthday: <input type="text" name="Birthday" value="<?php echo stripslashes($row['Birthday']); ?>"
<input type="submit" value="Submit">
</form>
<?php
}
?>

I want to be able to connect to that same database and update ALL the values (3 in the example above) with the single click of the form button. I think I was told some time ago that it's not possible to update all the values at once?

Thanks,

~Wayne

Inserting Multiple Values Into The Same Mysql Column

Similar Tutorials

View Content

Inserting Multiple Checkbox Values Into Mysql

Similar Tutorials

View Content

So first of all, I have a confession, I used Dreamweaver to take care of all my database work. Pheww. Now that I got that of my chest, I am having problems, not only with my lack of experience working with databases, but with my script also. I need to insert multiple checkbox values into my database into the same cell. So I have searched around and I thought I had found a fairly good approach, but with Dw's hodgepodge of overcomplicated mess, I am finding problems integrating it. The error I am getting post submission is "Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in C:\wamp\www\gov\ballot.php on line 10
Column 'involvement' cannot be null" So if you would, could you debug my script and give me some instruction along to way so that I can learn a little something too? Here is my script:

<?php require_once('Connections/ballot.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

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

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "Ballot")) {
  $insertSQL = sprintf("INSERT INTO votes (`first`, `last`, gender, grade, involvement, schedule, party, `time`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['first'], "text"),
                       GetSQLValueString($_POST['last'], "text"),
                       GetSQLValueString($_POST['gender'], "text"),
                       GetSQLValueString($_POST['grade'], "text"),
                       GetSQLValueString($_POST['involvement'], "text"),
                       GetSQLValueString($_POST['schedule'], "text"),
                       GetSQLValueString($_POST['party'], "text"),
                       GetSQLValueString($_POST['time'], "text"));

  mysql_select_db($database_ballot, $ballot);
  $Result1 = mysql_query($insertSQL, $ballot) or die(mysql_error());

  $insertGoTo = "thanks.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_ballot, $ballot);
$query_Recordset1 = "SELECT * FROM votes";
$Recordset1 = mysql_query($query_Recordset1, $ballot) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Please Place your Vote Below</title>
</head>

<body style="background-image:url(images/bg.jpg); background-repeat:repeat-x; background-color:#000000;">
<table align="center" bgcolor="#FFFFFF" cellpadding="0" cellspacing="0" border="0">
<tr><td>
<div style="border:thin; border-color:000000; border-style:groove; width:700px; background-color:ffffff;">
<div align="center"><a href="index.php"><img src="images/header.jpg" alt="Mock Elections 2010" /></a></div>
<div style="margin:10px; margin-top:30px;">
Before continuing to vote, in order to count your vote, we ask that you please ensure you are adhereing to the following guidelines:
</div>
<div style="margin:30px">
  <p>- When putting your name, remember to put your full legal name. NO nicknames.<br />
    - Be sure that all your information is valid otherwise your vote will not be counted.
    <br />
  </p>
</div>
<div style="margin-left:150px; margin-right:150px; margin-top:50px;">
<form action="<?php echo $editFormAction; ?>" method="POST" name="Ballot">
First Name:  <input type="text" name="first" /><br />
Last Name:  <input type="text" name="last" /><br />
<div>Gender: 
<label>
Male <input type="radio" value="Male" name="gender" /></label>
<label>Female <input type="radio" value="Female" name="gender" /></label>
</div>
Grade: 
<select name="grade">
  <option selected="selected"> </option>
  <option value="7">7</option>
  <option value="8">8</option>
  <option value="9">9</option>
  <option value="10">10</option>
  <option value="11">11</option>
  <option value="12">12</option>
  <option value="Teacher">Teacher</option>
  <option value="Staff">Staff</option>
</select><br />
<div>Involvement: 
  <label>
    <input type="checkbox" name="involvement[]" value="Athletics" id="involvement_0" />
    Athletics</label>
  <label>
    <input type="checkbox" name="involvement[]" value="Co-Curricular" id="involvement_1" />
    Co-Curricular</label>
  <label>
    <input type="checkbox" name="involvement[]" value="Clubs" id="involvement_2" />
    Clubs</label>
</div>
<div>Schedule: 
<label><input type="radio" value="C4" name="schedule" />C4</label>
<label><input type="radio" value="All Day" name="schedule" />All Day Hauser Student</label>
</div>
<div>Party: 
<label><input type="radio" value="PokePartay" name="party" />PokePartay</label>
<label><input type="radio" value="Equilibrium" name="party" />Equilibrium Party</label>
</div>
<br />
<input type="Submit" value="Submit" />
<input type="hidden" value="<?php
$tz =  new DateTimeZone('America/Indianapolis');
$date = new DateTime('now', $tz);
echo $date->format('m-d-Y h:i:s') . "\n";
?>" name="time" />
<?php
if (isset($_POST['submit'])) {
   $involvements = $_POST['involvement'];

   foreach($involvements as $involvement) {
      $query2 = "INSERT INTO votes (involvement) VALUES ('$involvement')";
      $result2 = mysql_query($ballot, $query2) or die(mysql_error());
   }
}
?>
<input type="hidden" name="MM_insert" value="Ballot" />
</form>
</div>
<br />
<br />
<br />
<br />
</div>

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

</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

Thanks,
Philip Ulrich

Moved: Adding Multiple Values From Mysql Columns

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=313325.0

Multiple Selections From Drop Down Lists To Create A Mysql Select Command

Similar Tutorials

View Content

Hi I have tried the mysql forum but have had no joy with an answer to my problem so wondered if php would be better.

I want my users to be able to select from 5 different drop down lists where they can chose any combination from 1 up to all 5, I have attached the front end. These lists are being populated from mysql tables.

Code for the drop down lists is as follows
Code: [Select]
<form action="horse-events-devon.php?url_countyid=<?php echo  urlencode ($url_countyid ['url_countyid'])  ; ?>&go" method="POST">
<table id="searchtable">
<tr>
<th>Find By Discipline</th>
<th>Find By Venue</th>
<th>Find By Championship</th>
<th>Find By Organiser</th>
<th>Equine Association</th>
<th>Submit Your Selections</th>
</tr>
<tr>
<td><select name="dis_id">
<?php
                                        $upcomingdis = upcomingdis($url_countyid);
                                        $upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis);
                                    ?>
<?php
                                    do {
       ?> <option value="<?php echo $upcoming_dis_bycounty ['dis_id']; ?>" >
<?php echo $upcoming_dis_bycounty ['dis_description']; ?></option>
<?php
                                    } while ($upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis));
                                    ?></select></td>
<td><select name="ven_id">
<?php
                                        $upvenbycounty_set = upcoming_venevents_bycounty($url_countyid);
                                        $upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set);
                                    ?>
<?php
                                    do {
       ?> <option value="<?php echo $upcoming_ven_bycounty ['ven_id']; ?>" >
<?php echo $upcoming_ven_bycounty ['ven_name']; ?></option>
<?php
                                    } while ($upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set));
                                    ?></select></td>
<td><select name="champ_id">
<?php
                                        $championship_set = findchampionships();
                                        $champlist = mysql_fetch_assoc ($championship_set);
                                    ?>
<?php
do {
?> <option value="<?php echo $champlist ['champ_id']; ?>" >
<?php echo $champlist ['champ_description']; ?></option>
<?php
} while ($champlist = mysql_fetch_assoc ($championship_set));
?></select></td>
<td>
<select name="org_id">
<?php
                            $uporgbycounty_set = upcoming_organevents_bycounty($url_countyid);
                            $upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set);
                        ?>
<?php
                        do {
                        ?> <option value="<?php echo $upcoming_org_bycounty ['org_id']; ?>" ><?php echo $upcoming_org_bycounty ['org_name']; ?></option>
<?php
                        } while ($upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set));
                        ?></select>

</td>
<td><select name="ass_id">
<?php
                                        $upassbycounty_set = upcoming_assevents_bycounty($url_countyid);
                                        $upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set);
                                    ?>
<?php
                                    do {
                                    ?> <option value="<?php echo $upcoming_assbycounty ['ass_id']; ?>" >
<?php echo $upcoming_assbycounty ['ass_description']; ?></option>
<?php
                                    } while ($upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set));
                                    ?></select></td>
<td><input name="submit" type="submit" /><input name="countyid" type="hidden" value="<?php echo $url_countyid ['url_countyid']; ?>" /></td>
</tr>
</table>
</form>
My search processing is as follows

Code: [Select]
<?php
if (isset($_POST['submit'])){
if (isset($_GET['go'])){
$countyid = $_POST['countyid'];
$ven_id = $_POST['ven_id'];
$dis_id = $_POST['dis_id'];
$champ_id = $_POST['champ_id'];
$org_id = $_POST['org_id'];
$event_id = $row['event_id'];

$sql = "SELECT DATE_FORMAT (events.startdate, '%a, %d, %b')
   AS stdate, events.event_id, events.title, events.ven_id, events.org_id,
   venue.county_id, venue.ven_id, eventdisciplines.event_id, eventdisciplines.dis_id, county.county_id, discipline.dis_id \n"
. "FROM events \n"
. "LEFT OUTER JOIN eventdisciplines \n"
. "ON events.event_id = eventdisciplines.event_id \n"
. "LEFT OUTER JOIN discipline \n"
. "ON eventdisciplines.dis_id = discipline.dis_id \n"
. "LEFT OUTER JOIN venue \n"
. "ON events.ven_id = venue.ven_id \n"
. "LEFT OUTER JOIN county \n"
. "ON venue.county_id = county.county_id \n"
. "WHERE events.ven_id = ({$ven_id} OR events.org_id = {$org_id})\n"
. "AND events.startdate > NOW()\n"
. "AND venue.county_id = {$countyid}  \n"
. "ORDER BY startdate ASC";

$result = mysql_query ($sql, $connection);
?>
How am I best to do this please? my OR within the mysql does not work, should I not be doing this with php in the search processing? someones help would really be appreciated, just to point me in the right direction.

[attachment deleted by admin]

Table Issue - Multiple Location Values For User Pushes Values Out Of Row Instead Of Wrapping In Cell

Similar Tutorials

View Content

Hi,

My company has 240+ locations and as such some users (general managers) cover multiple sites. When I run a query to pull user information, when the user has multiple sites to his or her name, its adds the second / third sites to the next columns, rather than wrapping it inside the same table cell. It also works the opposite way, if a piece of data is missing in the database and is blank, its pull the following columns in. Both cases mess up the table and formatting. I'm extremely new to any kind of programming and maybe this isn't the forum for this question but figured I'd give it a chance since I'm stuck.

The HTML/PHP code is below:

<thead>

<tr>

<th>FirstName</th>

<th>LastName</th>

<th>Username</th>

<th>Phone #</th>

<th>Location</th>

<th>Title</th>

<th>Actions</th>

</tr>

</thead>

<tbody>

<?php

//QUERY TO SELECT ALL USERS FROM DATABASE

$query = "SELECT * FROM users";

$select_users = mysqli_query($connection,$query);

// SET VARIABLE TO ARRAY FROM QUERY

while($row = mysqli_fetch_assoc($select_users)) {

$user_id = $row['user_id'];

$user_firstname = $row['user_firstname'];

$user_lastname = $row['user_lastname'];

$username = $row['username'];

$user_phone = $row['user_phone'];

$user_image = $row['user_image'];

$user_title_id = $row['user_title_id'];

$user_role_id = $row['user_role_id'];

// POPULATES DATA INTO THE TABLE

echo "<tr>";

echo "<td>{$user_id}</td>";

echo "<td>{$user_firstname}</td>";

echo "<td>{$user_lastname}</td>";

echo "<td>{$username}</td>";

echo "<td>{$user_phone}</td>";

//PULL SITE STATUS BASED ON SITE STATUS ID

$query = "SELECT * FROM sites WHERE site_manager_id = {$user_id} ";

$select_site = mysqli_query($connection, $query);

while($row = mysqli_fetch_assoc($select_site)) {

$site_name = $row['site_name'];

echo "<td>{$site_name}</td>";

}

echo "<td>{$user_title_id}</td>";

echo "<td>{$user_role_id}</td>";

echo "<td class='table-action'>

</td>";

//echo "<td><a href='users.php?source=edit_user&p_id={$user_id}'>Edit</a></td>";

echo "</tr>";

}

<tr>

<td>FirstName</td>

<td>LastName</td>

<td>Username</td>

<td>Phone #</td>

<td>Location</td>

<td>Title</td>

</td>

</tr>

</tbody>

<tfoot>

<tr>

<th>FirstName</th>

<th>LastName</th>

<th>Username</th>

<th>Phone #</th>

<th>Location</th>

<th>Title</th>

</tr>

</tfoot>

</table>

New Problem Using Select - Select Multiple Colums From Join Tables

Similar Tutorials

View Content

hirealimo.com.au/code1.php

this works as i want it:
Quote

SELECT * FROM price INNER JOIN vehicle USING (vehicleID) WHERE vehicle.passengers >= 1 AND price.townID = 1 AND price.eventID = 1

but apparelty selecting * is not a good thing????

but if I do this:
Quote

SELECT priceID, price FROM price INNER JOIN vehicle....etc

it works but i lose the info from the vehicle table.

but how do i make this work:
Quote

SELECT priceID, price, type, description, passengers FROM price INNER JOIN vehicle....etc

so that i am specifiying which colums from which tables to query??

thanks

Multiple Select Options In A Multiple Page Form

Similar Tutorials

View Content

This seems to be a bit of a challenge but I am creating a multiple page form and on one of the pages I have a select field. I would like the user to have the ability to select multiple options but I am using some functions to move the data in hidden fields from page to page. I don't think my functions are jiving with my my foreach loop cause I keep getting an invalid argument error.

Thanks in advance for any help.

Here is my function:

function setSelected($fieldName, $fieldValue) {
if(isset($_POST[$fieldName]) && $_POST[$fieldName] == $fieldValue) {
echo 'selected="selected"';
}
}

And here is my loop:

$selections = "";

if(isset($_POST["selections"])) {
foreach ($_POST["selections"] as $selection) {
$selections .= $selection . ", ";
}
}

Mysql Values Clause, Variable Values From File

Similar Tutorials

View Content

Hi all,

Just curious why this works:

Code: [Select]
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')";
}
And this does not:

$headdata_1 = "'$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]'";
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values($headdata_1)";
}it puts $data[#'s] in the database fields instead of the actual data that '$data[0]','$data[1]'... relates to.

I wrote a script to create the values in $headdata_1 based on the number of headers in $csvheaders1 but can't seem to get it working in the sql statement.

Thanks

Loop To Insert Multiple Rows (multiple Mysql Connections??) Help Please!

Similar Tutorials

View Content

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work?
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:

$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) {

$username = $dp['username'];
$nickname = $dp['nickname'];
$pwd1 = $dp['password'];
$mail = $dp['email'];
$ip_add = $dp['ip'];
$wsID = $dp['userID'];
$registerdate = $dp['registerdate'];
$birthday = $dp['birthday'];
$avatar = $dp['avatar'];
$icq = $dp['icq'];
$hp = $dp['homepage'];

echo $username." = 1 username only? :(";


// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');

include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";

       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');

       }

So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

Select Different Srts Of Values

Similar Tutorials

View Content

Hi all i have 2 small questions and maybe someone could help me out.
Say I have a database with a table 'users'.
This table has fields: email, name and year.

What I want to do is show at the front-end all users, by selecting them from the table, and arrange them by year in column 1 and show them as individuals in column 2. But here is the thing; if someone selects for instance year 1970 and also someone from 1970 individually, someone will be selected twice. (edit:As a side note the selecting is aimed and emailing the users, that's why selecting someone twice is not good
First question is: does anyone know how to remove doubles (maybe even triples if there is a select all button, maybe turn this around and say select only 1 instance of a user).

Second question: is this a wise way to let someone select. Right now all users are fetched, and if the table users grows this could be tricky because of the large number of users.

If someone could point me in the right direction of thinking I would be very happy, been thinking about this and scalability for quite a while now

Put Select Values Into Array?

Similar Tutorials

View Content

I have a Prepared Statement that runs a SELECT statement and returns 2 records, and I would like to store the Field Value for each Record into an Array.

Here is the code I usually use for queries that return just a single value...

// ******************
// Populate Form. *
// ******************

// Build query.
$q2 = "SELECT response
FROM bio_answer
WHERE member_id=?";

// Prepare statement.
$stmt2 = mysqli_prepare($dbc, $q2);

// Bind variable to query.
mysqli_stmt_bind_param($stmt2, 'i', $memberID);

// Execute query.
mysqli_stmt_execute($stmt2);

// Store results.
mysqli_stmt_store_result($stmt2);

// Check # of Records Returned.
if (mysqli_stmt_num_rows($stmt2)>0){
// Details Found.

// Bind result-set to variable.
mysqli_stmt_bind_result($stmt2, $response);

// Fetch record.
mysqli_stmt_fetch($stmt2);

// Close prepared statement.
mysqli_stmt_close($stmt2);

}else{
// Details Not Found.
$_SESSION['resultsCode'] = 'DETAILS_NOT_FOUND_2133';

// Close prepared statement.
mysqli_stmt_close($stmt2);

// Set Error Source.
$_SESSION['errorPage'] = $_SERVER['SCRIPT_NAME'];

// Redirect to Display Outcome.
header("Location: " . BASE_URL . "/members/results.php");

// End script.
exit();
}//End of POPULATE FORM

Can someone help me out with the syntax so that I get an end result like this...

$answerArray[0] = 'I want to be my own boss!!'
$answerArray[1] = 'Don't waste your time trying to do your own Taxes!'

Thanks,

Debbie

Check Select Values - Jquery?

Similar Tutorials

View Content

hi

people can vote 3 times with 3 select menus
but i want them not to be able to choose 3x the same select option

the options in the select menus come out of the database

this is how i let them vote

Code: [Select]
<?php

include("./includes/egl_inc.php");
$secure = new secure();
$secure->secureGlobals();
session_start();

if (isset ($_GET['match']))
{

$matchid = (int)$_GET['match'];
$_SESSION['matchid'] = $matchid;
$matchmaps = mysql_fetch_array(mysql_query("SELECT maps,game FROM ffa_matches WHERE id=$matchid"));
$matchmapschecker = $matchmaps[maps];
$matchgamechecker = $matchmaps[game];

$maps=mysql_query("SELECT id,map FROM ffa_maplists where gameid = $matchgamechecker");
while(list($id,$map)=mysql_fetch_row($maps))
{
$maplist.="<option value='$id'>$map</option>\n";

}

  $out[body].="<table width='98%' border='0' cellspacing='0' cellpadding='0' style='border:1px solid black'>
   <tr style='color:#cccccc; background-color:black;'>
<td valign='middle' background='$config[bg2]' align='center' colspan='10'>

<br/>Choose Maps<br/>
</td>
   </tr></table><table width='98%' border='0' cellspacing='0' cellpadding='0' style='border:1px solid black'>
<tr style='background-color:black;'>
<td>
<form action='ffainsertmapvote.php' method='post'>
<select name='map1'>$maplist</select>
<select name='map2'>$maplist</select>
<select name='map3'>$maplist</select>
<input type='hidden' name='match' value='$matchid' />
<input type='submit' value='Vote' />
</form> </td>
</tr></table>";

}

include("$config[html]");
?>

do i need jquery to fix this? i dont want the user to be able to go to a next screen without having max 2 the same options selected

thanks in advance !

How To Update Values Database Using Select Box

Similar Tutorials

View Content

Hi guys,

Im developing a stock system and so far new stock and can be added with the quantity, however im trying to update the stock by using a select box and selecting the type of stock and inputting a new qty.

the form and everything is set up and i can select files from the database, however i dont know how to update files from a select box

The code i got so far is

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>stock manager</title>
</head>

<body>
<?php
$stockqty =&$_POST['stock_qty1'];
?>
<center>
<table>
<td>
<table>
<td>
<form action='stockview.php' method='POST'>
Please Enter a Stock Name and Stock Value

<table>
<tr>
<td>
Stock Name:
</td>
<td>
<input name="stock_name" type="text" /><BR />
</td>
</tr>
<tr>
<td>
Stock Qty:
</td>
<td>
<input name="stock_qty" type="text" />
</td>
</tr>

</table>
<input name="submit" type="submit" value="Add New Stock Items" />
</form>
</td>
</table>
</td>

<td>

<table>
<td>
<form action='stockmanager.php' method='POST' enctype="multipart/form-data">
Please Select from the list the item you wish to update
<table>
<tr>
<td>
Stock Name:
</td>
<td>

<?php
$connect = mysql_connect("localhost","root", "") or die ("Couldn't Connect!");
mysql_select_db("stock", $connect) or die("Couldn't find db"); // select database

$query=("SELECT id, stockname FROM stocks");
$result = mysql_query ($query);
echo "<select name=stock value=''>Edit Stock QTY</option>";

while($nt=mysql_fetch_array($result))
{ //Array or records stored in $nt
echo "<option value=$nt[id]>$nt[stockname]</option>";
/* Option values are added by looping through the array */
}

$queryreg = mysql_query("SELECT * FROM stocks WHERE stockqty='$stockqty'");
$numrows = mysql_num_rows($queryreg);

$update = mysql_query("UPDATE stocks SET stockqty='$stockqty' WHERE stockname = '$stockname'");
echo("Its updated");
?>

</td>
</tr>
<tr>
<td>
Stock Qty:
</td>
<td>
<input name="stock_qty1" type="text" />
</td>
</tr>
</table>
<input name="submit" type="submit" value="Update stock items" />
</form>
</td>
</table>
</td>
</table>

</center>

</body>
</html>

Any help would be greatly appreciated.

Thanks

Lance

No Values Shown In <select> Aft Using Php Code

Similar Tutorials

View Content

Hi all,

Currently my dob_day is not showing any value, even though there is a value in the database, it seems like it is unable to retrieve the value.

No value was shown in the <select> box. Do you guys have any idea? Thanks

Code: [Select]
<?php
$query = "SELECT name, nric, gender, picture, dob_day FROM tutor_profile WHERE tutor_id = '" . $_GET['tutor_id'] . "'";

$data = mysqli_query($dbc, $query)
or die(mysqli_error($dbc));

// The user row was found so display the user data
if (mysqli_num_rows($data) == 1) {
$row = mysqli_fetch_array($data);

    if ($row != NULL) {
      $name = $row['name'];
      $nric = $row['nric'];
      $gender = $row['gender'];
  $old_picture = $row['picture'];
  $dob_day = $row['dob_day'];
    }
    else {
      echo '<p class="error">There was a problem accessing your profile.</p>';
    }

//HTML CODING
<label for="dob" class="label">Date Of Birth</label>
<select id="dob_day" name="dob_day" value="<?php if (!empty($dob_day)) echo $dob_day; ?>">
<option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
?>

How To Make Options In A Select Box Be Values From A Table.

Similar Tutorials

View Content

I have set up a form page with a select box of colleges to select. I want the "options" in the select box to be values taken from a field called "name" in a table called "colleges" and they should be ordered alphabetically. I also want the default selected option to be "none."

I have attached a picture to describe what i want. Please be detailed with the code. I am fairly new to php and mysql. Thank you.

Php Date Intervals...

Similar Tutorials

View Content

Tried to use a datetime addition function but it gave me this error:

Quote

Fatal error: Call to undefined function date_add() in /home2/cruxispr/public_html/mysidiaadoptables/devdemo/script.php on line 3

I searched on PHP tutorials, but it says there's no need to install any of these datetime related functions since they are part of PHP core. I dont understand, why do I get a no method error like this if it is indeed already in PHP core? Please help.

Here are the links from PHP official site for references:
http://www.php.net/manual/en/datetime.installation.php
http://www.php.net/manual/en/datetime.add.php