PHP - Dynamic Url Variables From Database Fields

Hi there,   I have a table in a MySQL database where I keep a list of user privileges. I am trying to create variables where the name of variable matches the privileges in the table.   This is also known as variable variables (I think).   EDIT (17/07/2014 04:02 PM): This might be a better way to describe what I'd like, so if the value from the table is admin_panel I'd like to dynamically create a variable with that name.   I have created a code so far, but all I seem to be getting is a list of Notice errors telling me that the variable is undefined. (I have supplied a list of errors a bit further down the post).   Here is the code:

<?php
$host = "localhost";
$account = "***";
$password = "****";
$dbname = "****";

$connect = mysql_connect($host,$account,$password) or die("Unable To Connect");
$db = mysql_select_db($dbname,$connect) or die("Unable To Select DB");

$perm_query = "SELECT * FROM `privileges`";
$permission_query = mysql_query($perm_query);

while($row = mysql_fetch_array($permission_query))
{
$rows[] = $row;
}

foreach($rows as $row)
{
${$row['privilege']};
}
?>

The list of errors:   Notice: Undefined variable: admin_panel in C:\xampp\htdocs\DynamicVariables.php on line 20
Notice: Undefined variable: create_user in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: edit_user in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: delete_user in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: create_group in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: edit_group in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: delete_group in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: view_log in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: log_settings in C:\xampp\htdocs\DynamicVariables.php on line 20

Notice: Undefined variable: password_change in C:\xampp\htdocs\DynamicVariables.php on line 20   Thanks
Edited by chrisrulez001, 17 July 2014 - 10:05 AM.

Hi can anybody help I need to export and download tables from a database into a excel sheet. I have this code and it works what I need is to export specific fields and not just the whole table can anyone help modifying the code to export certain fields within the table please? Here is the code...
Code: [Select]
<?php
$host = 'localhost';
$user = 'user';
$pass = 'password';
$db = 'qdbname';
$table = 'tablename';
$file = 'export';

$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect.");

$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field']."; ";
$i++;
}
}
$csv_output .= "\n";

$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j]."; ";
}
$csv_output .= "\n";
}

$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;
?>

I am quite new to PHP and MySQL. I am trying to figure out what datatypes to use for different fields in a Database. For ID (Identification) I use INT, for  name I use VARCHAR and for people to write text messages, I use LONGTEXT. For date and time I use DATETIME.   What I am unsure about, however, is what type to use for an email adress and for an IP address? I have been watching videos at Youtube about the Datatype for IP addresses, but they don't seem always to agree. I hope someone can put me in the right direction on those two.   Regards,   Erik

I wrote a piece of code that lists images that don't have a match in the database:

Code: [Select]
$dir_path = '../images/productImages';
$images = scandir($dir_path);

$query = "SELECT image FROM Database_table ORDER BY name DESC";

$results = mysql_query($query);

$output  = "<h1>Missing Images</h1>";
$output .= "<div class=\"missingImages\">";
$output .= "<p>The following data was found in the Database_table.images field but not in /images/productImages:</p>";
$output .= "<div class=\"missingImg\">";
$output .= "<p class=\"fieldName\">Database_table.images:</p>";

while ($fetch = mysql_fetch_array($results)) {

$clean_fetch = str_replace("productImages/", "", $fetch);
$diff = array_diff($clean_fetch, $images);
foreach (array_unique($diff) as $key => $value) {

$output .= $value . "<br />";
}
}

$output  .= "</div>";
$output  .= "</div>";

echo $output;
Works.

Now I would like to check whether there are any files in the folder that are not in the database table.

I thought it would be as easy as swapping the array_diff parameters around but it's not.

When i swap the parameters like so - array_diff($images, $clean_fetch) it gives me a list of ALMOST all the images in the image folder, which i don't understand.

Why does it not give me only the images that are present in the folder but not in the database?

Hi all,
I'm brand new to php / mysql and I'm trying to modify this script which currently runs a search on two fields "product_number" and "product_name". I also want the search to consider a third field "product_type". When I remove either product_name or product number from the following part of the code, it removes that field from being considered in the search: Code: [Select]
$search_map = array($orderby, 'product_number','product_name',);
So shouldn't I be able to just add the third field's name to this array and have it be considered too? I'm a complete beginner so I'm hoping this is a simple fix and I just dont get it.

Here's the rest of what I think is the relevant code:
Code: [Select]
function load_all_products()
{
    global $AppUI;
    global $sorted_item_list;
    global $additional_pfilter;
    load_type_list();
    $orderby = 'product_id';
    $search_map = array($orderby, 'product_number','product_name',);
    $where = $AppUI->getState( 'QuoteIdxWhere' ) ? $AppUI->getState( 'QuoteIdxWhere' ) : '*';
    $not =" ";
    $op =  " OR";
    $check = substr(trim($where),0,4);
    if(stristr($check,"NOT")){
        $op ="AND";
        $not = " NOT ";
        $where = substr(trim($where),4);
        $where = trim($where);
    }

    // assemble the sql statement
    $q = new DBQuery;
    $q->addTable('products');
    $q->addJoin('companies', 'com', 'products.product_company_id = com.company_id');
    $q->addJoin('users', 'u', 'products.product_owner = u.user_id');
    $q->addQuery('products.*, com.company_name, u.user_username');
    $where_filter = " ";
    foreach($search_map as $search_name)
        $where_filter .=" $op $search_name $not REGEXP '$where'";
    $where_filter = substr($where_filter, 5);
 //   echo $where_filter;
    if($where != "*")
       $q->addWhere("($where_filter)");
    $q->addOrder('product_id');

    $sql = $q->prepare();
    $q->clear();
    $sql_list = db_exec( $sql );
    if ($sql_list)
  $rn = db_num_rows( $sql_list );
    else {
   echo db_error();
   $rn = 0;
    }

$product_list = array();
    foreach ($sql_list as $item)
{

$product_list[ $item[ 'product_id' ] ] = $item;

}

// sort the list

global $sort_state;
if ( !isset( $sort_state ) ) $sort_state = getProductSortState();

if ( isset( $sort_state[ 'sort_item1' ] ) )
{
if ( isset( $sort_state[ 'sort_item2' ] ) )
{
$sorted_item_list = array_csort2( $product_list, $sort_state['sort_item1'], intval( $sort_state['sort_order1'] )
, $sort_state[ 'sort_item2' ], intval( $sort_state['sort_order2'] ) );
}
else
{
$sorted_item_list = array_csort2( $product_list, $sort_state['sort_item1'], intval($sort_state['sort_order1']) );
}
}
else $sorted_item_list = array_csort2( $product_list, 'product_id' );

}
Thanks!

hi every body. i want a loop that takes and shows more than one record from database. and then i want to show these to user by ajax.   indeed i made an html page that when user arrives at end it must do this.   first i made loop that took one record from database and it worked fine.   but for taking several records it went wrong.   this is my html file that has interact by user  webgoo-ajax.html   4.36KB   2 downloads   and this is my php file that interacts by database  ajax-get.php   1012bytes   3 downloads   when user arrives at end of page naturally ajax must be run and show several records to user.but it does'nt. first it stays idle for 3 minutes and then loads my first record extremely.   and a point: if these pages does'nt work on IE it will work on Firefox because it did'nt worked in IE for me too.   i just want a for loop that work correctly for my need.   thank you for everything                                       

I have a relational table call sales with prodcut_id and custmer_id tables. I also have a product and customer tables. products table with product_id as an auto increment and customer with custumer_id I want to join through the sales tables all t he fields of row 1 from tables customer and products and pull it at once.


This is a member login script and I want to display the products by members.

So far I have this query to display the products once the member is login in. $userid is the id of the customer coming from the $userid= $_SESSION['customer_id'];


$mysqlSales="SELECT products.* FROM products JOIN sales ON (products.product_id = procuct_id ) WHERE sales.customer_id = '$userid'";


so far that statement is not working where should I have some type of incoherance with the english statement above expressing what I want the query to do.

This topic has been moved to Ajax Help.

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

I'm using PHP and MySQL. I have an application where I'd like to keep certain database (character) fields encrypted when added to the database and stored, but when I need to display them at the appropriate time, I can call a function and quickly decrypt them for display.

Does anyone know of a simple way to do this?

Thanks!

Hi,

I'm learning php and I'm trying to get to grips with dynamic xml and php coming from a database.  The trouble I am having is I can't get my code to give any output.  I don't get an error I message, I just can't get the xml to display.  If anyone can give me any pointers as to what I'm doing wrong that would be great...

Here's the code I have.
Code: [Select]
<?php 

DEFINE ('DB_USER', 'root');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'flashphpbible');

$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$query = "SELECT * FROM dynamicxml WHERE id=1";
$result = mysqli_query($link, $query);

$xmlData .= " ";
$xmlData .= "<store>\n";


while($row = mysqli_fetch_array($result));
{
$xmlData .= " <item>\n";
$xmlData .= "  <name>".$row['name']."</name>\n";
$xmlData .= "  <section>".$row['section']."</section>\n";
$xmlData .= "  <price>".$row['price']."</price>\n";
$xmlData .= "  <inStock>".$row['instock']."</inStock>\n";
$xmlData .= " </item>\n";

}

$xmlData .= "</store>\n";

echo "response=".$xmlData;
?>

Thanks for any help offered. 
Ben.

Hey,

I'm currently planning on how i will code some breadcrumbs for a shopping site where the admin can add more options/levels to the database which in turn store products. I understand how to get the url of the previous options/level but am stuck on retrieving the name of the level and can only imagine retrieving it from the database. Though Its possible to do so is there any other method as relying on the database for crumbs seems like a easy way out or am i just picky?

the typical url is like so:  website.com/shop.php?cat_id=1004, so i cant retrieve the name from it unless i cross reference it to its database name and dont know how to retreive from their <a href> tag.

On a side note is there a graph that can show a general outline of how many db queries a server can make per second etc depending on its hardware?

Thanks.

I'm praying there's a function somewhere out there that:

generates a html form based on the fields of a particular table within a DB (namely mySQL) generates the appropriate form input based on the fields type or notes (ie. for field: avatar_img, it knows to generate a file input) uses the POST method to submit generates and submits SQL insert query to database
In addition to that, a similar function that generates a form that allows the editing of records.

It doesn't take too long to write these each time myself, but if there's a function that you provide the formname, database driver, table name, whether your form is to insert or edit, that would be quite nifty i think. 

ie.  generateForm(addUser, mySQL, tUsers, insert)

Seen any such thing?
Many thanks.

I have created a PHP form which includes validation, however.. everytime  the validation passes, php redirects the form to another page where mysql code is to insert the variables... for some reason the variables are not being sent at all.

Any suggestions.

page 1

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1); ?>
<?php
function VerifyForm(&$values, &$errors) {
   // Do all necessary form verification
   // Validate Model Number
   if (strlen($values['model']) < 4) {
      $errors['model'] = 'Model Number too short';
   } elseif( strlen($values['model']) > 20) {
         $errors['model'] = 'Model Number too long';}
         // Validate Price
         if (is_numeric($values['price']) == 0){
            $errors['price'] = 'No Price has been entered';}
            // Validate Product
            if(($values['product']) == 0){
               $errors['product'] = 'No Product has been selected';}
               // Validate Image
        $imageinfo = getimagesize($_FILES['photo']['tmp_name']);
if($imageinfo['mime'] != 'image/gif' && $imageinfo['mime'] != 'image/jpeg' && isset($imageinfo)){
               $errors['photo'] = 'Image format must be either JPEG or GIF';}
                  // Validate Description
                  if (strlen($values['description']) == 0){
                     $errors['description'] = 'Description is too short';}
                     return (count($errors) == 0);
}
function DisplayForm($values, $errors)
{
?>
<!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>Test Area</title>
<link rel="stylesheet" href="test.css" type="text/css" media="screen" />
</head>

<body>
<div id="container">
<h1>Add a Product</h1>
<form method="post" id="customForm" action="" enctype="multipart/form-data">
<table>
<tr>
<td>Model Number:</td>
<td><input id="model" type="text" size="30" name="model" value="<?php echo htmlentities($values['model']); ?>"/></td>
<td class="error"><p style="color:#FF0000"><?php echo isset($errors['model']) ? $errors['model'] : ''; ?></p></td>
</tr>
<tr>
<td>Choose a Product:</td>
<td>
<select class="product" name="product">
<option value="0">Please select an option below</option>
<option value="19lcdtv">19" LCD TV</option>
<option value="22lcdtv">22" LCD TV</option>
<option value="26lcdtv">26" LCD TV</option>
<option value="32lcdtv">32" LCD TV</option>
<option value="37lcdtv">37" LCD TV</option>
<option value="37plasmatv">37" Plasma TV</option>
<option value="3D">3D Technology</option>
<option value="42lcdtv">42" LCD TV</option>
<option value="42plasmatv">42" Plasma TV</option>
<option value="46plasmatv">46" Plasma TV</option>
<option value="50plasmatv">50" Plasma TV</option>
<option value="54plasmatv">54" Plasma TV</option>
<option value="58plasmatv">58" Plasma TV</option>
<option value="65plasmatv">65" Plasma TV</option>
<option value="bluraydiscs">Bluray Discs</option>
<option value="blurayhomecinema">Bluray Home Cinema System</option>
<option value="blurayplayer">Bluray Player</option>
<option value="blurayportable">Bluray Portable</option>
<option value="blurayrecorder">Bluray Recorder</option>
<option value="breadmaker">Breadmakers</option>
<option value="cdradio">CD, Radio and Cassette Players</option>
<option value="convectorheater">Convector Heaters</option>
<option value="cylindercleaner">Cylinder Cleaner</option>
<option value="answerphone">DECT Answer Phone</option>
<option value="phone">DECT Phone</option>
<option value="fire">Dimplex Fires</option>
<option value="dishwasher">Dishwashers</option>
<option value="dvddiscs">DVD Discs</option>
<option value="dvdplayer">DVD Player</option>
<option value="dvdportable">DVD Portable</option>
<option value="dvdrecorder">DVD Recorder</option>
<option value="epilator">Epilators</option>
<option value="fanheater">Fan Heaters</option>
<option value="freezers">Freezers</option>
<option value="fridgefreezer">Fridge-Freezers</option>
<option value="hdcamcorder">HD Camcorders</option>
<option value="hddcamcorder">HDD Camcorders</option>
<option value="homecinema">Home Cinema System</option>
<option value="iron">Irons</option>
<option value="kettle">Kettles</option>
<option value="beauty">Ladies Shavers/Beauty</option>
<option value="leads">Leads</option>
<option value="shaver">Mens Shavers/Grooming</option>
<option value="microsystem">Microsystems</option>
<option value="microwavegrill">Microwave (Grill)</option>
<option value="microwavesolo">Microwave (Solo)</option>
<option value="microwavecombi">Microwave Combination</option>
<option value="dvtapes">Mini DV Tapes</option>
<option value="minisystems">Minisystems</option>
<option value="pvr">Personal Video Recorder (PVR)</option>
<option value="projector">Projector</option>
<option value="pure">Pure Radios</option>
<option value="fridges">Refridgerators</option>
<option value="sdcamcorder">SD Camcorders</option>
<option value="sdcards">SD/SDHC/SDXC Cards</option>
<option value="straighteners">Straighteners</option>
<option value="stylishcamera">Stylish Cameras</option>
<option value="superzoomcamera">Super Zoom Cameras</option>
<option value="toaster">Toasters</option>
<option value="tumbledryer">Tumble Dryers</option>
<option value="uprightcleaner">Upright Cleaner</option>
<option value="brackets">Wall Bracket</option>
<option value="washingmachine">Washing Machine</option>
</select>
</td>
<td class="error"><p style="color:#FF0000"><?php echo isset($errors['product']) ? $errors['product'] : ''; ?></p></td>
</tr>
<tr>
<td>Price:</td>
<td><input id="price" type="text" size="30" name="price" value="<?php echo isset($values['price']) ? $values['price'] : htmlentities($values['price']) ; '';?>"/></td>
<td class="error"><p style="color:#FF0000"><?php echo isset($errors['price']) ? $errors['price'] : ''; ?></p></td>
</tr>
<tr>
<td>Please upload an Image:</td>
<td><input id="photo" type="file" size="30" name="photo" value="<?php echo isset($values['photo']) ? htmlentities($values['photo']) : ''; ?>"/></td>
<td class="error"><p style="color:#FF0000"><?php echo isset($errors['photo']) ? $errors['photo'] : ''; ?></p></td>
</tr>
<tr>
<td valign="top">Description:</td>
<td>
<textarea id="description" name="description" cols="" rows=""><?php echo isset($values['description']) ? htmlentities($values['description']) : ''; ?></textarea>
</td>
<td class="error"><p style="color:#FF0000"><?php echo isset($errors['description']) ? $errors['description'] : ''; ?></p></td>
</tr>
<tr>
<td><input id="submit" name="submit" type="submit" value="Submit" /></td>
</tr>
</table>
</form>
</div>
</body>
</html>
<?php
}
function ProcessForm($values)
{
   //INSERT VARIABLES FROM INSERT_ADD.PHP
   // Replace with actual page or redirect :P
   header ("Location: http://www.example.com");
}
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
   $formValues = $_POST;
   $formErrors = array();
   if (!VerifyForm($formValues, $formErrors))
   DisplayForm($formValues, $formErrors);
   else
   ProcessForm($formValues);
}
else
DisplayForm(null, null);
?>



This is the page which includes database details and insert commands


<?php

$host=""; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

//This is the directory where images will be saved 
$target = "images/"; 
$target = $target . basename( $_FILES['photo']['name']); 

// Get values from form
$model=$_POST['model'];
$product=$_POST['product'];
$description=$_POST['description'];
$price=$_POST['price'];
$photo=($_FILES['photo']['name']); 


// Insert data into mysql
$sql="INSERT INTO $tbl_name(model, product, description, price, photo)VALUES('$model', '$product', '$description', '$price', '$photo')";
$result=mysql_query($sql);

if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) 
 { 
 //Tells you if its all ok 
 echo "<center>The file " . basename($_FILES['photo']['name']) . " has been uploaded, and your information has been added to the directory</center>"; 
 } 

 else { 
 //Gives and error if its not 
 echo "Sorry, There was a problem Uploading your Details."; 
 } 

// close connection
mysql_close();
?>

Hi everyone, I'm trying to get my head around blending in and out of php and html.  I've seen some simple examples which work great but now I have this variable that comes from the database and I would like to style the variable in-line with html markup.   Here's what I'm trying to do:   <?php    echo "Price : ",'<Font size="100"> $tournament["pricePerPlayer"] </font>'; ....more of the same code goes here...   ?>   I can't get $tournament["pricePerPlayer"] to be controlled by the font tag.  How do I do this? Any help would be greatly appreciated.   Thanks,

im making a game and i need to show a users money but i dont know how help?