Jump to content

phpMyedit - on click, pass ProductID to other php file for sql statement?

coogie

By coogie
in PHP Coding Help

Recommended Posts

coogie Newbie

coogie

Posted
Posted

Hello, i have a phpmyedit file which loads this table below:

 

Email, Product_name, shape, freebie, colour, texture, shape, smoothness, preference_name

 

I then have a seperate PHP file, which displays data from this table, and data from other tables with a mysql 'where' statement

 

I'd like to make it so when i click on the 'product_name" in my phpmyedit table, it will then opens my php (shown below) and gives values in the mysql statement, where i have the fields 'email', 'product_name' and 'preference_name'

 

How can i achieve this? My php experience is very poor and i'm trying to learn

 

Regards,

 

coogie

 

 

This is my separate php file where i would like to update the mysql statement according to what product the user clicks on:

<?php require_once('Connections/main.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $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;
}
}

mysql_select_db($database_main, $main);
$query_Recordset1 = "SELECT * FROM preferences WHERE email = ***email*** AND preferences_name = ***preference_name***";
$Recordset1 = mysql_query($query_Recordset1, $main) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

mysql_select_db($database_main, $main);
$query_products_tbls = "SELECT * FROM products_tbl INNER JOIN ordered_products ON products_tbl.product_name=ordered_products.product_name WHERE products_tbl.product_name = ****Product_name****";
$products_tbls = mysql_query($query_products_tbls, $main) or die(mysql_error());
$row_products_tbls = mysql_fetch_assoc($products_tbls);
$totalRows_products_tbls = mysql_num_rows($products_tbls);
?><!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>orders</title>
</head>

<body>
product order form
<table height="169" border="1">
  <tr>
    <td><table border="1">
      <tr>
        <td>length</td>
        <td><?php echo $row_Recordset1['length_inch']; ?></td>
      </tr>
      <tr>
        <td>height</td>
        <td><?php echo $row_Recordset1['height_inch']; ?></td>
      </tr>
      <tr>
        <td>width</td>
        <td><?php echo $row_Recordset1['width_inch']; ?></td>
      </tr>
      <tr>
        <td colspan="2"> </td>
      </tr>
    </table></td>
    <td><table border="1">
        <tr>
          <td>Order:</td>
          <td><?php echo $row_products_tbls['orderid']; ?></td>
        </tr>
        <tr>
          <td>product:</td>
          <td><?php echo $row_products_tbls['product_name']; ?></td>
        </tr>
        <tr>
          <td>shape:</td>
          <td><?php echo $row_products_tbls['shape']; ?></td>
        </tr>
        <tr>
          <td>freebie:</td>
          <td><?php echo $row_products_tbls['freebie']; ?></td>
        </tr>
        <tr>
          <td> </td>
          <td> </td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td colspan="2"><table width="490" border="1">
      <tr>
        <td width="153"><?php echo $row_products_tbls['colour']; ?></td>
        <td width="315"><?php echo $row_products_tbls['shape']; ?></td>
      </tr>
      <tr>
        <td><?php echo $row_products_tbls['texture']; ?></td>
        <td><?php echo $row_products_tbls['smoothness']; ?></td>
      </tr>
    </table></td>
  </tr>
</table>
<p> </p>
<p> </p>
<p> </p>
</body>
</html>
<?php
mysql_free_result($Recordset1);

mysql_free_result($products_tbls);
?>

 

coogie Newbie

coogie

Posted
  • Author
Posted

I have found out how i can pass one value of the table row into another php.

but after lots of searching, i cannot find a way to pass 3 values from the row. This is how my code looks, which successfully passed one Value


$fdd['product_name']['URL'] = 'http://localhost/phpMyEdit-5.1/orders.php?id=$value'; 
//$fdd["product_name"] = array(
//	'name'=>'Shirt name',
//	'select'=>'T',
//	'type'=>'int',
//	'maxlen'=>8,
//	'nowrap'=>false,
//	'required'=>true,
//	'sort'=>true
//);

 

 

But i want to do something exactly like this (this does not work)

$fdd['product_name']['URL'] = 'http://localhost/phpMyEdit-5.1/orders.php?id=$value&email=$field1&profile=$profile';

 

is this possible? If it is, i can complete my code ! :)

 

 

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.