PHP - Dynamic <select>

Hi,

I had a form which contains, 8 select boxes. In those 8 select boxes, 3 of the boxes are interlinked, like, I am able to generate data in other 2 select boxes, if one box is been selected. i.e. based upon selection of one select box, and i am able to generate data in other select box. So, 3 select boxes are interlinked. And remaining 5 selects are optional, if the user selects, then we need to generate data based upon selection of the user.

Here the main issue is how to grab data in the post back form, like, how to capture the number of selects boxes selected and what are those selected, and based upon that we need to generate data.

Here one more important thing is that, in the report generation form(postback form), I need to show the data in a table. So , in table I had 9 columns and these would be common to whatever the selection made, but, only the requeired data would be changed based upon the selection of the remaining 5 optional boxes.

Hope you got me!!!!

Folks,

I need help (Php code ) to generate a Dynamic Text on a Base Image. What i want to do is, to make this Image as header on my Site and to make this Header Specific to a Site, i want to Add the Domain Name on the Lower Left of the Image.

Got the Idea?

Here is the Image link:

Quote

http://img27.imageshack.us/i/shoppingheader1.jpg/


PHP Variable that holds the Domain name is:  $domain 

All i need the Dynamic PHP Codes that i can put on all my sites to generate this Text on Image (Header) Dynamically...

May Anyone Help me with this Please?

Cheers
Natasha T.

Hi all

I need to combine these two scripts:

Firstly, the following decides which out of the following list is selected based on its value in the mySQL table:

<select name="pack_choice">
<option value="Meters / Pack"<?php echo (($result['pack_choice']=="Meters / Pack") ? ' selected="selected"':'') ?>>Meters / Pack (m2)</option>
<option value="m3"<?php echo (($result['pack_choice']=="m3") ? ' selected="selected"':'') ?>>Meters / Pack (m3)</option>
<option value="Quantity"<?php echo (($result['pack_choice']=="Quantity") ? ' selected="selected"':'') ?>>Quantity</option>
</select>

Although this works OK, I need it also to show dynamic values like this:

select name="category">
<?php
$listCategories=mysql_query("SELECT * FROM `product_categories` ORDER BY id ASC");
while($categoryReturned=mysql_fetch_array($listCategories)) {
echo "<option value=\"".$categoryReturned['name']."\">".$categoryReturned['name']."</option>";
}
?>
</select>

I'm not sure if this is possible?

Many thanks for your help.

Pete

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

I have 2 queries that I want to join together to make one row  

Dear All,

I wish to have 2 drop down boxes, Country Select Box and Locality Select Box. The locality select box will be affected by the value chosen in the country select box.

All is working fine except that the locality select box is not being populated.
I know that the problem is in the sql statement

WHERE country_id='$co'

because i am having an error that $co is an undefined variable.

All the rest works fine because i have replaced the $co variable directly with a number (say 98) for a particular country id and it worked fine. In what way can i define this variable $co so that it is accepted by my sql statement?

Thank you for your help in advance.

MySQL Tables indicated below:

CREATE TABLE countries(
country_id INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
country_name VARCHAR(30) NOT NULL,
PRIMARY KEY(country_id),
UNIQUE KEY(country_name),
INDEX(country_id),
INDEX(country_name))
ENGINE=MyISAM;

CREATE TABLE localities(
locality_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
country_id INT(3) UNSIGNED NOT NULL,
locality_name VARCHAR(50),
PRIMARY KEY (locality_id),
INDEX (country_id),
INDEX (locality_name))
ENGINE=MyISAM;

Extract PHP script included below:

// connect to database
require_once(MYSQL);

if(isset($_POST['submitted']))

{

// trim the incoming data

/* this line runs every element in $_POST through the trim() function, and assigns the returned result to the new $trimmed array */
$trimmed=array_map('trim',$_POST);

// clean the data

$co=mysqli_real_escape_string($dbc,$trimmed['country']);

$lc=mysqli_real_escape_string($dbc,$trimmed['locality']);

}

?>

<form action="form.php" method="post">

<p>Country
<select name="country">
<option>Select Country</option>

<?php

$q="SELECT country_id, country_name
FROM countries";

$r=mysqli_query($dbc,$q) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($r))

{

$country_id=$row[0];
$country_name=$row[1];
echo '<option value="' . $country_id . '"';
if(isset($trimmed['country']) && ($trimmed['country']==$country_id))
echo 'selected="selected"';
echo '>' . $country_name . '</option>\n';

}

?>

</select>
</p>

<p>Locality
<select name="locality">
<option>Select Locality</option>

<?php

$ql="SELECT locality_id, country_id, locality_name
FROM localities
WHERE country_id='$co'
ORDER BY locality_name";

$rl=mysqli_query($dbc,$ql) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($rl))

{

$locality_id=$row[0];
$country_id=$row[1];
$locality_name=$row[2];
echo '<option value="' . $locality_id . '"';
if(isset($trimmed['locality']) && ($trimmed['locality']==$locality_id))
echo 'selected="selected"';
echo '>' . $locality_name . '</option>\n';

}

// close database connection
mysqli_close($dbc);

?>

</select>
</p>

<p><input type="submit" name="submit" value="Submit" /></p>

<input type="hidden" name="submitted" value="TRUE" />

</form>

Hello!

If you search Google, you'll notice the URL: http://www.google.com/webhp?hl=en#hl=en&source=hp&q=php+freaks&aq=f&aqi=g10&aql=&oq=&gs_rfai=CtdaTdtdRTNnPD5HuzASZtMWiCgAAAKoEBU_Q0ZT5&pbx=1&fp=19d754eee0b4f223

You can copy that URL anywhere you like... and the user will still see the same results.

So basically the URL dynamically does an action, and accesses the database.

How on do I make a URL like this? Meaning when you change the URL parameter values, it request a slightly different database query?

Does that make sense? Similarly with NexTag.com: http://www.nextag.com/serv/main/buyer/ProductCompare.jsp?search=camera&page=0&node=500001&psort=%2FDigital-Cameras--zzcameraz500001zB6z5---html&zipcode=&cptitle=657166355&cptitle=656751324&cptitle=620051906&cptitle=705150048

That was a Dynamically made URL (I selected from check boxes which products to compare) and it makes that URL so anyone can see those products.

Any ideas on how to do this?


More examples on the URL: http://www.cars.com/go/compare/modelCompare.jsp?myids=9721,11439  (i select the cars, it generates that URL. Notice the IDs 9721,11439)
 

hi all, im looking at a countdown timer and when a user places a bid it resets the timer, exactly like the one used at madbid.com, is this a mixture of javascript and php or just php?

if you could point me in the right direction of what to look into that would be very helpful

Lee

Hi all, completely new at this and have got myself stuck!

I am trying to display a thumbnail image by connecting to my database and retrieving the URL that points to the image.

I know that the connection is working but I can't seem to get it to point to the image. Probably something really simple. Here's my code:

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=iso-8859-1" />
<title>Image Swap Using CSS</title>
<style type="text/css">

body {
margin: 0;
padding: 0;
background-color:#000000;
}

img {
margin: 0;
padding: 0;
border: none;
}

.test {
margin: 0;
padding: 0;
width: 99px;
height: 130px;
}

.test a:hover img {
visibility:hidden;
}

</style>
</head>

<body>
<?php
// connect to the database
mysql_connect("********", "****") or die(mysql_error()); 
mysql_select_db("eliteescorting") or die(mysql_error());
$start=0;

// expand on the searches
$data=mysql_query("SELECT * FROM escorts WHERE base = 'manchester' ORDER BY RAND()");
$num_results=@mysql_num_rows($data);

for($ii = $start;$ii < $num_results; $ii++){
?>
<div class="test"><a href="#"><img src="<?php echo $data[$ii]['thumb'];?>" /></a></div>
<?php } ?>
</body>

</html>

In my mySQL field 'thumb' contains the full URL of the image ie http://www............

This is just for testing, I'll get round to sorting out security issues later.

Your help will be greatly appreciated!

Regards,
Nortski.

I know this topic is everywhere but I cant find a solution to my particular problem.  I have been using a download center script for about a year. http://download.redgalaxy.net/ However, the title is static, keeping with the predefined one.  I am trying to get the title to change so it matches the file name shown on the display page "index.php/?nav=display&file=25". I have spent days trying to figure something out with absolutely no luck. Does anyone have an idea how to get the title to change when dynamically? Out of desperation i used an onload javascript but it doesnt work with crawlers. Thank you in advanced.

Index.php
<?php
/*
    PHP Download Center
    Copyright (C) 2007  Chris LaPointe

    This program is free softwa  you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/

//error_reporting(E_ERROR);
define("PHP_DOWNLOADCENTER", 1);
include_once('settings.php');

//Include all files in 'inc' directory
$path = 'inc/';
$handle = opendir($path);
while (false !== ($file = readdir($handle))) {
if (substr($file, 0, 1) != '.')
include($path.$file);
}
closedir($handle); 


//Start session for me!
session_start();
if (mysql_connect($mysql_host, $mysql_username, $mysql_password) == FALSE){
if (file_exists("install.php")){
echo '<HTML><HEAD><meta http-equiv="refresh" content="0;url=install.php"></HEAD></HTML>';
exit;
}else{
die("Fatal error.  Unable to access database.  In addition, unable to go to install.php to setup access!");
}
}
if (mysql_select_db($mysql_database) == FALSE){
if (file_exists("install.php")){
echo '<HTML><HEAD><meta http-equiv="refresh" content="0;url=install.php"></HEAD></HTML>';
exit;
}else{
die("Fatal error.  Unable to access database.  In addition, unable to go to install.php to setup access!");
}
}

//because of the way it is handled, there should never be any HTML passed via arguments
//do a check here
foreach ($_GET as $key => $value){
$_GET[$key] = strip_tags(html_entity_decode($value, ENT_NOQUOTES), '<i><b>');
}

//Run the now (Just code, ie login code)
if ( isset($_GET['now']) ){
$nowfile = "pages/".$_GET['now'].'.now.php';
if (file_exists($nowfile)){
include($nowfile);
}else{
echo "<b>Warning:</b> Now file '$nowfile' doesn't exist";
}
}

?>


<HTML>
<HEAD>
<TITLE><?php echo $page_title; ?></TITLE>
<link rel="stylesheet" type="text/css" href="style.css">
</HEAD>


<BODY>


<!--TOP SECTION (banner)-->
<table width=100% border=0 cellspacing=2 cellpadding=0>
<TR>
<TD valign="top"><img src="theme/page/banner.gif"></TD>
<TD valign="middle"><div align="right"><?php include('ads/ad_top.php'); ?></div></TD>
</TR>
</TABLE>

<!--MIDDLE SECTION-->
<table width=100% border=0 cellspacing=2 cellpadding=0>
<TR>
<TD width=150px valign="top"><?php require('left.php'); ?></TD>
<TD valign="top">
<table width=100% border=0 cellspacing=2 cellpadding=0>
<TR><TD><?php include('nav.php'); ?></TD></TR>
<TR><TD><?php include('body.php'); ?></TD></TR>
</table>
</TD>
</TR>
</table>

<BR>
<div align="center"><font size="1">
This page is under the <a href="http://gplv3.fsf.org/">GPLv3</a> by <a href="http://www.redgalaxy.net" target="_blank">Red Galaxy</a>.  Each file is copyrighted by its respective owner.<BR>
This page is not to be held responsible for any uploaded files.  It is each user's responsibility to check the legality of files they upload.<BR>
Please contact <i><?php echo $info_name; ?></i> at <?php echo str_replace('@', "'AT'", str_replace('.', "'DOT'", $info_email)); ?> with any questions.<BR>
<?php echo $info_misc; ?></font>
</div>

</BODY>
</HTML>

<?php
mysql_close();
?>

nav.php
<?php
if (!defined('PHP_DOWNLOADCENTER'))
exit;
?>

<table width=100% border=0 cellspacing=0 cellpadding=0>
<TR>
<TD>
<a href="?nav=home">Home</a> | <a href="?nav=recent">Recent Files</a>
</TD>
<TD align="right">
<form action="?nav=search_results" method="post"><INPUT type="text" size="20" name="search"><INPUT type="submit" value="Search"></form>
</TD>
</table>

body.php
<?php
if (!defined('PHP_DOWNLOADCENTER'))
exit;

if (!isset($_GET['nav'])){
$location = 'pages/home.php';
}else{
$location = 'pages/'.$_GET['nav'].'.php';
}

if (isset($_GET['message'])){
echo '<div align="center">';
echo BeginBorder("Message", "50%");
echo stripslashes(urldecode($_GET['message']));
echo EndBorder();
echo '</div>';
}

if (file_exists($location))
include($location);
else
include("pages/404.php");


?>


display.php
<?php

$fid = $_GET['file'];
$results = mysql_query("SELECT * FROM files WHERE id=$fid LIMIT 1");
if (mysql_numrows($results) == 0){
echo "File not found.  It may have been removed.";
return;
}

$who = getUserNameById(mysql_result($results,0,"uid"));

echo BeginBorder(mysql_result($results, 0, "title"), "90%");

?>
<TABLE width=100% border=0 cellspacing=0 cellpadding=0>
<TR><TD width=50% valign="top">
<TABLE width=100% border=0 cellspacing=1 cellpadding=2>
<TR bgcolor=#F0F0F0>
<TD width=50%>Name:</TD>
<TD><?php echo mysql_result($results, 0, "title"); ?></TD>
</TR>
<TR bgcolor=#F0F0F0>
<TD>File:</TD>
<TD><?php echo mysql_result($results, 0, "filename"); ?></TD>
</TR>
<TR bgcolor=#F0F0F0>
<TD>Size:</TD>
<TD><?php echo round( mysql_result($results, 0, "filesize")/1024/1024,2).'MB'; ?></TD>
</TR>
<TR bgcolor=#F0F0F0>
<TD>Extension:</TD>
<TD><?php echo mysql_result($results, 0, "filetype"); ?></TD>
</TR>
<TR bgcolor=#F0F0F0>
<TD>Category:</TD>
<TD><?php echo mysql_result($results, 0, "category"); ?></TD>
</TR>
<TR bgcolor=#F0F0F0>
<TD>User:</TD>
<TD><?php echo $who; ?></TD>
</TR>
<TR bgcolor=#F0F0F0>
<TD>Date Uploaded:</TD>
<TD><?php echo mysql_result($results, 0, "date"); ?></TD>
</TR>
<TR bgcolor=#F0F0F0>
<TD>Download Count:</TD>
<TD><?php echo mysql_result($results, 0, "dcount"); ?></TD>
</TR>
<TR bgcolor=#F0F0F0>
<TD>Downloads This Month</TD>
<TD><?php echo mysql_result($results, 0, "dmonth"); ?></TD>
</TR>
</TABLE>
</TD>
<TD valign="top">
<center>
<a href="<?php echo '?nav=download&file='.$fid; ?>"><img src="theme/download.png" border=0></a>
<?php
if (mysql_result($results, 0, 'private') == '1')
echo "<br>You must be logged in to download this file.</b>";
?>
</center><BR><BR>
<?php
//PREVIEW IMAGE IF EXISTS
$realname = mysql_result($results, 0, "filename");
$small_preview = 'images/'.$realname.'.small.jpg';
$large_preview = 'images/'.$realname.'.large.jpg';
if (file_exists($small_preview)){
echo "<div align='center'><a href='$large_preview' target='_blank'><img src='$small_preview' border='0'></a></div><BR>";
}


//ADMIN CONTROLS
if (isUserAdmin()){
echo '<b>Admin:</b> <a href="?nav=delete&file='.$fid.'">Delete This File</a> | <a href="?nav=edit&file='.$fid.'">Edit</a><BR>';
}
?>
</TD></TR>

</TABLE>

<HR>
<b>Description:</b><BR>
<?php echo mysql_result($results, 0, "description"); ?>


<?php
echo EndBorder();
?>

I've been working on this for the last few hours and haven't had much luck. Basically, every time you visit the index of my site a random image is shown. The images are stored in a directory, and i use a table to hold the id, name, and url of each image. When the index page is loaded a random int is chosen, and the id equal to the int prints the corresponding url for the image.

Now i'm trying to add the id into the url, "domain.com?img=1". I also need this url to always refer to the image in row 1.

My table is called uploaded_images and the columns are id(primary key), name, url.

I'm pretty lost, any help is greatly appreciated.

I'm trying to figure out for the months I can get it to display the last 5 months including the current month. The reason for this is I"m going to get the total number of hits for my website  for each month as well as the number of successful logins for my CMS script. Any thoughts?

Code: [Select]
<table class="visualize_dashboard">
<caption>
Dashboard Chart Example
</caption>
<thead>
<tr>
<td></td>
<th scope="col">March</th>
<th scope="col">April</th>
<th scope="col">May</th>
<th scope="col">June</th>
<th scope="col">July</th>
</tr>
</thead>
<tbody>
<tr>
<th scope="row">Visits</th>
<td>175</td>
<td>145</td>
<td>212</td>
<td>175</td>
<td>182</td>
</tr>
<tr>
<th scope="row">Logins</th>
<td>94</td>
<td>53</td>
<td>124</td>
<td>92</td>
<td>105</td>
</tr>
</tbody>
</table>

I want to get the ibase_blob_echo function and I was told I need to uncomment the extension=php_interbase.dll
 in my php.ini.

So I did and now I get the message:
Unable to Load Dynamic Library
in a pop-up window.

I'm lost and don't know how to solve this

Let's see if I can explain this ok.. Basically I have a site and the page product categories use dynamically created URL's. I want to use these URL's to put on my products so I can list all the categories each product is in. But, as these URL's are not stored anywhere I'm not sure how to go about calling them. Is the best way going to be to modify the site to store the page URL's in MySQL? Or could they be stored within variables in PHP? A little guidance would be great! Thanks in advance 

Hey guys does anyone know of a good dynamic directory solution? What i mean by this is when i am creating an application and i use


require_once 'includes/config.php';


and then i create a class that needs the config file so i include it into the class like so:


require_once '../include/config.php';


then i make a new folder named member then i have to require this class (created above) and it fails to find the directory.

What would be a good solution for this?

Thanks guys!!