How to set Dynamic WHERE showing customer rows depend on customer_ID using PHP?

132 100+

Hi all once again!!

I have two tables in MYSQL, tblLogin and tblCustomers with the following Columns: tblLogin{LoginID as Primary_Key, UserName, Password} and tblCustomer{Customer_ID as Primary_Key, Customer_FullName, OrderID, OrderDetails, submission_date, Customer_LoginID as Foreign_key}.
What I want is to let customers to view their own records only due to their login information.
To accomplish this I set two forms namely Login_Form.php and Results.php where after pressing SUBMIT BUTTON of Login_Form.php the user should be able to see his own records displayed on Results.php form dynamically.
Here is my code for these forms!
1. Login_form.php

Expand|Select|Wrap|Line Numbers

 
<html>

<head>

  <meta content="text/html; charset=ISO-8859-1"

 http-equiv="content-type">

  <title></title>

</head>

<body>

<form target="_self" enctype="text/plain" method="post"

 action="Results.php" name="Login_Form"><label>User

name</label> &nbsp; 

<label>Password<br> <br> </label><input name="UserName" value="User Name">

&nbsp;<input name="Password" value="Password"

 type="password"><br>

  <br>

&nbsp; 

&nbsp; &nbsp; <input name="Submit" value="submit"

 type="submit"><br>

  <br>

</form>

</body>

</html>

2. Results.php

Expand|Select|Wrap|Line Numbers

 
<?php

$dbhost = 'localhost:3306';

$dbuser = 'root';

$dbpass = 'rootpassword';

$conn = mysql_connect($dbhost, $dbuser, $dbpass);

if(! $conn )

{

  die('Could not connect: ' . mysql_error());

}

$sql = 'Customer_ID, Customer_FullName, OrderID, OrderDetails,submission_date, Customer_LoginID WHERE .....?';
 
mysql_select_db('tblCustomers');

$retval = mysql_query( $sql, $conn );

if(! $retval )

{

  die('Could not get data: ' . mysql_error());

}

while($row = mysql_fetch_array($retval, MYSQL_ASSOC))

{

    echo "Customer_ID :{$row['Customer_ID']}  <br> ".

         "Full Name: {$row['Customer_FullName']} <br> ".

         "Order Details: {$row['OrderDetails']} <br> ".

         "Date : {$row['submission_date']} <br> ".

         "--------------------------------<br>";

} 

echo "Fetched data successfully\n";

mysql_close($conn);

?>

Now how to fetch specific data due to specific customer? Any hint would be highly appreciated
Please!!!!

Mar 10 '13 #1

Subscribe Post Reply

1953

Rabbit

12,516

Expert Mod 8TB

You can use the where condition in your select query to filter for the results you're looking for.

Mar 10 '13 #2

Mr Key

132

100+

Is better you leave the question unanswered rather than typing one line blablaaa.
I know very well how to write WHERE CONDITION, the issue is to capture the input from one login form to SQL!
Please the other time read first before u respond

Mar 12 '13 #3

r035198x

13,262

8TB

It's more of a PHP question than a MYSQL one then. I would suggest putting the userId in the session when the user logs in though rather than submitting with every request to your results page. Then you look it up from the session using $_SESSION['userId'] syntax and append it to the where clause if your table structure supports that.
That way you can always filter anything from anywhere based on that userId.
You can read more about session variables here: http://www.w3schools.com/php/php_sessions.asp

Mar 12 '13 #4

Similar topics

Dataset Now showing updated Rows.

by: archana | last post by:

Hi all, I am having one dataset in which i am taking data from database. Then in my application i am creating one new column into datatable of that dataset and assigned one default value for...

C# / C Sharp

Dynamic and Unique rows

by: Nazish | last post by:

I want to create a dynamic rows , set rowid as first cell value then traverse all rows generated if row exists update dat row othewise craete new row

Javascript

Not showing the rows which is having the digits < 6 !!!

by: girishlc | last post by:

Hi All, Can anybody look into this below query? I’m running these below queries on Oracle SQL developer. SELECT * FROM BATCH.ITEM@SCPOREADDB WHERE ITEM LIKE '%82128%' ...

PostgreSQL Database

showing deleted rows in DataGridView

by: ZSvedic | last post by:

Hi all, I need to display DataRows with RowState.Deleted inside DataGridView, in a way that such rows have strikethrough font. Here is the screenshot how it should look like:...

C# / C Sharp

Problem with dynamic addition of rows

by: aashishn86 | last post by:

i am using this function to add rows dynamically function addRow() { var tbl = document.getElementById('applications'); var lastRow = tbl.rows.length; // if there's no header row in...

Javascript

Dynamic Deletions of Rows and Columns

by: ebernon | last post by:

The Dynamic deletion of Rows and Columns within a program is frequently desired but often hard to obtain. The Help files for VB-6 contained within Excel 2002 (XP) don’t always provide the help you...

Visual Basic 4 / 5 / 6

how to insert multiple rows in excel using vba

by: ronakinuk | last post by:

how to insert multiple rows in excel using vba how to insert multiple rows in excel using vba how to insert multiple rows in excel using vba

Visual Basic 4 / 5 / 6

How to validate excel data rows and columns using php script?

by: santhanalakshmi | last post by:

Hi, I uploaded the excel and the data is successfully inserted to the database, by submitting the "submit button" using php script. There is an final stage for me to do is the validation of...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++