Hi i hope I may be able to get some more advice on creating my suggestion form, or a point to any tutorials they may help creat a table form mysql where the html file and php file are seperate.
i have two files one containing only html and another with only php.
in my html file i have a table and i wish to pass into this table the values from a mysql query that is contained within the php file.
all the examples i have looked at have used both html and php in the one file.
at the moment im trying to pass the values using,"<?php echo $name; ?>" but this doesn't seem to be working.
HTML file
<?php include("SubmittedSuggestions.php"); ?>
<div class="container" style="background-image:url('//www.worldmarkacademy.com/OurWorld/EditorBG.png');
-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;
background-size:repeat;padding-bottom: 5px;">
<br />
<div class="mainbody" style="background-image:url('//www.worldmarkacademy.com/Test/Notepad.png');
background-repeat:no-repeat;margin-left:auto;margin-right:auto;margin-bottom:10px;
width:646px;height:800px!important;min-height:100%;overflow:hidden;">
<div class="main-form" style="margin-top:280px;margin-left:15px;">
<table>
<thead>
<tr>
<th>Name</th>
<th>Site</th>
<th>Status</th>
<th>Date</th>
</tr>
</thead>
<tbody>
<tr>
<td> <?php echo $name; ?> </td>
<td> <?php echo $site; ?> </td>
<td> <?php echo $status; ?> </td>
<td> <?php echo $date; ?> </td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
PHP Superglobal - $_POST
Super global variables are built-in variables that are always available in all scopes.
PHP $_POST is a PHP super global variable which is used to collect form data after submitting an HTML form with method="post". $_POST is also widely used to pass variables.
The example below shows a form with an input field and a submit button. When a user submits the data by clicking on "Submit", the form data is sent to the file specified in the action attribute of the <form> tag. In this example, we point to the file itself for processing form data. If you wish to use another PHP file to process form data, replace that with the filename of your choice. Then, we can use the super global variable $_POST to collect the value of the input field:
Example
<html>
<body>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
Name: <input type="text"
name="fname">
<input type="submit">
</form>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
// collect value of input field
$name = $_POST['fname'];
if (empty($name)) {
echo "Name is empty";
} else {
echo $name;
}
}
?>
</body>
</html>
Try it Yourself »
Tip: You will learn more about $_POST in the PHP Forms chapter.
- Easy to save the URL or bookmark it for frequent use.
- Copy the URL and send it to a friend to refer.
Here one main concern is the data gets exposed in address bar of the browser and can be easily accessible by using browser history. So it is not a good idea to pass sensitive data like password through the URL to different pages or different sites.
Passing variable with data to different pages
Here is an example of passing data through URL within a site.
<a href='page2.php?id=2489&user=tom'>link to page2</a> When the above link is clicked, page2.php gets the variables id and user with data 2489 and tom respectively. Here is the code to collect data in PHP. echo $_GET['id']; // output 2489echo $_GET['user']; // output tom
The address of page2.php can be replaced with any site name and the same data can be passed to another site running in any server. Like this
Passing data outside
<a href=//www.sitename.com/index.php?id=2489&user=tom>Link to another site</a> Demo of passing data through a formYou can see in the above case the values can be posted to another site. Note that after the page name we are using question mark ( ? ) to start the variable data pair and we are separating each variable data pair with one ampersand ( & ) mark.
Submitting form values through GET method
A web form when the method is set to GET method, it submits the values through URL. So we can use one form to generate an URL with variables and data by taking inputs from the users. The form will send the data to a page within the site or outside the site by formatting a query string. <form method=GET action='//www.anysite.com/index.php'>Submitting a form through POST method
By post method of form submission we can send more number or length of data. Sensitive information like password does not get exposed in URL by POST method, so our login forms we should use POST method to submit data. This is how we collect data submitted by POST method in PHP $id=$_POST['id']; $password=$_POST['password']; Difference between GET and POSTBrowser History | Data remain in Browser History | Data Not available in Browser History |
Bookmark | URL with Data can be bookmarked | No data is available in URL to bookmark the page |
Data Length Restriction | The restriction (of URL ) is applicable | No Restriction |
cached | Can be cached | No meaningful caching |
Sensitive Data | Data like password , pin etc. are exposed through URL so they should not be passed using GET method | Better than GET method as data is not exposed through URL |
Read more on difference between GET and POST method of form submission
Collecting data submitted by either GET or POST method
If a page is receiving a data which can come in any one of the method GET or POST then how to collect it ? Here we are not sure how to collect the data. So we will use like this. $id=$_REQUEST['id']; $password=$_REQUEST['password'];Every scripting language pages has its own way of receiving the data from the URL
While receiving the data based on the server settings the values will be available to the pages. Here in a server running PHP will have to see the global settings of the server on how to collect the data. $id=$_GET['id']; $user=$_GET['user']; Same way in ASP environment running VB script the data can be collected and assigned like this Id = Request.QueryString("id") User = Request.QueryString('user')Passing data within the site using URL
The same principle is used like above to send the data within the site using URL. A query sting can be formatted with a link or a form can be used with get method to pass variables between pages.Passing the data between the site through URL
Like above data can be passed to different pages of sites using URL . The best use is directly linking to a page dip inside another site by formatting a query sting. Like this <a href=//www.sitename.com/viewtopic.php?id=5248>Linking to a topic</a>Passing variables through query string
In many applications we need to pass variables through query string. For example we want to display the product details where product ID is to be passed in query string through a variable. The product ID can be collected from a table so we don't know what is the value but we can use the variable which stores the product ID.For example let us say we have collected product id from the product table. Read the tutorial on how to collect data from table. Our link with query string will have something like this.
$pid=$nt[product_id]; echo "<a href=product-detail.php?product_id=$pid>Product Details</a>"; You can directly display like this also. echo "<a href='product-detail.php?product_id=$nt[product_id]'>Product Details</a>";Chang of data while passing through URL
There is a problem in sending data other than plain text through browser. Empty space and some characters like & if present in the data , will create problem. To maintain the data integrity we have to encode the data before sending them though URL and then decode them again to get back the original data. In PHP encode command is used and in ASP VBScript the command is Server.URLEncode(string)Security issues while posting data through URL
The most common type of security problem in using data from URL is injection attack. We must sanitize the date before using inside our script or generating any query to manage database.Declaring variables Cookies to store Information