Grab info from url?

lancey10

Ok, i would like to insert information from a Row, lets say row 1 ( SELECT * FROM table WHERE id = '1' ) and insert the data in a template, and it will have a url that will be something like index.php?page=1. How do i go by doing that?
and how would i go by doing that with every row that is created?

Megahertza

index.php?page=1

<?php 
$page = $_GET[page]; // Grabs variable from url
// Setup mysql connection 
$mysql_query = "SELECT * FROM 'table' WHERE 'id' = '$page' ";
$mysql_result = mysql_fetch_array($mysql_query);
// Then display the result as you wish
?>

lancey10

dont understand how will that work?

Megahertza

<?php
$page = $_GET[page]; /* Grabs variable from url */
/* Setup your mysql connection */
/* The next query will sellect the row where the 'id' colunm is equal to the $page variable */
$mysql_query = "SELECT * FROM 'table' WHERE 'id' = '$page' ";
$mysql_result = mysql_fetch_array($mysql_query);
/* Then display the result as you wish by ^ echo $mysql_result[id]." ".$mysql_result[column] */
?>

If you have a table colunm out of your db that is unique then use that other then createing a ID colunm

lancey10

also how do i go by creating a entire different page with the content that u filled out on a form and you click submit?

Megahertza

So you want a page where you select what "row" you want

lancey10

let me explain further on what i meant:
creating a entire different page with the content that u filled out on a form and you click submit, the form works as a submitter to database and created a new php page that will display all the info on there (basically from the row) and also will create a url for it too like untop

Megahertza

What you can do is build a page that displays all the rows in a list( just a example ). In this list for each row just display all the the information about each row.

$mysql_query = "SELECT * FROM 'table'";
while($mysql_result = mysql_fetch_array($mysql_query)){
// echo out all the array variables with a link (below)
}

And a link to each row. ( example :<a href="index.php?page=$mysql_result[id]"><? $mysql_result[id] ?></a>; )

lancey10

ok i understand that part! but how will that add a template page for each url? and when u lci on the url, u will go to that page?

Megahertza

Just create a form to collect all the information, have the <form method="post" action="phppage.php">

in the phppage.php use this code to exstract the variables from url

<?php
$variable1 = $_POST[variable1];
$variable2 = $_POST[variable2];
$variable3 = $_POST[variable3];
?>

then insert those variable into the database

lancey10

explain the purpose of $variable again please, SORRY?

Megahertza

<?php
$page = $_POST[page];
if ($page >= 1) {
$mysql_query = "SELECT * FROM 'table' WHERE 'id' = '$page' ";
$mysql_result = mysql_fetch_array($mysql_query); 
// Then echo out the results
}
?>

lancey10

ok, where does "variable" come from........... sorry man for taking up ur time

Megahertza

When a form is submited, the form data is sent to the php page. then name of the input boxes and text field and other fields is sent asswell. so if we want to find out what a particular textbox data is we use $_POST[the name of the form object]

to get the info from this textfield.

$variable = $_POST[mytextfield];

now $variable = what ever was in the textfield

Megahertza

With forms you can use POST or GET as a method. GET will put the infomation into the url where POST send the information secretly.

lancey10

ahh ok and the

  $mysql_query = "SELECT * FROM 'table'";
while($mysql_result = mysql_fetch_array($mysql_query)){
// echo out all the array variables with a link (below)
}

doesnt work, let me show u my entire submit script:

<html>
<head>
<title>Submit a Review</title><basefont face="Arial">
</head>
<body>

<?php

if (!isset($_POST['submit'])) {
// form not submitted
?>

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">

  <div align="center"><br>
  <table width="513" height="403" border="0" cellpadding="4" cellspacing="1" bgcolor="#CCCCCC">

<tr>
  <td width="127">Title: </td>
  <td width="367"><input type="text" name="title" size="40" /></td></tr>
<tr>
  <td width="127">Category: </td>
  <td><label>
    <select name="category">
      <option>Games</option>
      <option>Movies</option>
      <option>Anime</option>
    </select>
  </label></td>
</tr><tr>
  <td>Posted By : </td><td><input type="text" name="posted" size="40" /></td></tr>
<tr>
  <td valign="top">Story: </td><td><textarea name="story" cols="55" rows="8"></textarea>
  </textarea></td></tr>
<tr>
  <td>Picture Url: </td>
  <td><span>
    <input type="text" name="picturepath" size="40" />
    </span></td>
</tr>
<tr>
  <td>Picture Quality: </td>
  <td><label>
    <select name="quality">
      <option>1</option>
      <option>2</option>
      <option>3</option>
      <option>4</option>
      <option>5</option>
    </select>
  </label></td>
</tr>
<tr>
  <td>Effects:</td>
  <td><select name="effect">
    <option>1</option>
    <option>2</option>
    <option>3</option>
    <option>4</option>
    <option>5</option>
  </select></td>
</tr>
<tr>
  <td>Overall:</td>
  <td><select name="overall">
    <option>1</option>
    <option>2</option>
    <option>3</option>
    <option>4</option>
    <option>5</option>
  </select></td>
</tr>
<tr>
  <td>&nbsp;</td>
  <td><input type="submit" name="submit"/></td>
</tr>
  </table>
  <br />
  <br />
  </div>
</form>

<?php
}
else {
// form submitted
// set server access variables
$host = "db304.perfora.net";
$user = "BLOCKED";
$pass = "Q439a.gw";
$db = "db154983898";


// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// create query
$query = "INSERT INTO reviews (title, posted, story, picturepath, quality, effect, overall, category) VALUES ('$title', '$posted', '$story', '$picturepath', '$quality', '$effect', '$overall', '$category')";

// execute query
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

// print message with ID of inserted record
echo "Review Submit is complete";
echo "<br><a href='index.php'>Click Here to Return </a>";
// close connection
mysql_close($connection);
}
?>

</body>
</html>

lancey10

sow how would i submit to mysql and post to php file?

lancey10

also, the php file will have to have the same name as the id # how do that?

Megahertza

This is your code, i've changed to work with the form. It should work as is now.

<html>
<head>
<title>Submit a Review</title><basefont face="Arial">
</head>
<body>

<?php

if (!isset($_POST['submit'])) {
// form not submitted
?>

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post">

  <div align="center"><br>
  <table width="513" height="403" border="0" cellpadding="4" cellspacing="1" bgcolor="#CCCCCC">

<tr>
  <td width="127">Title: </td>
  <td width="367"><input type="text" name="title" size="40" /></td></tr>
<tr>
  <td width="127">Category: </td>
  <td><label>
    <select name="category">
      <option>Games</option>
      <option>Movies</option>
      <option>Anime</option>
    </select>
  </label></td>
</tr><tr>
  <td>Posted By : </td><td><input type="text" name="posted" size="40" /></td></tr>
<tr>
  <td valign="top">Story: </td><td><textarea name="story" cols="55" rows="8"></textarea>
  </textarea></td></tr>
<tr>
  <td>Picture Url: </td>
  <td><span>
    <input type="text" name="picturepath" size="40" />
    </span></td>
</tr>
<tr>
  <td>Picture Quality: </td>
  <td><label>
    <select name="quality">
      <option>1</option>
      <option>2</option>
      <option>3</option>
      <option>4</option>
      <option>5</option>
    </select>
  </label></td>
</tr>
<tr>
  <td>Effects:</td>
  <td><select name="effect">
    <option>1</option>
    <option>2</option>
    <option>3</option>
    <option>4</option>
    <option>5</option>
  </select></td>
</tr>
<tr>
  <td>Overall:</td>
  <td><select name="overall">
    <option>1</option>
    <option>2</option>
    <option>3</option>
    <option>4</option>
    <option>5</option>
  </select></td>
</tr>
<tr>
  <td>&nbsp;</td>
  <td><input type="submit" name="submit"/></td>
</tr>
  </table>
  <br />
  <br />
  </div>
</form>

<?php
}
else {
// form submitted

// set post variables
$title = $_POST[title];
$posted = $_POST[posted];
$story = $_POST[story];
$picturepath = $_POST[picturepath];
$quality = $_POST[quality];
$effect = $_POST[effect];
$overall = $_POST[overall];
$categor = $_POST[categor];

// set server access variables
$host = "db304.perfora.net";
$user = "BLOCKED";
$pass = "Q439a.gw";
$db = "db154983898";


// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// create query
$query = "INSERT INTO reviews (title, posted, story, picturepath, quality, effect, overall, category) VALUES ('$title', '$posted', '$story', '$picturepath', '$quality', '$effect', '$overall', '$category')";

// execute query
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

// print message with ID of inserted record
echo "Review Submit is complete";
echo "<br><a href='index.php'>Click Here to Return </a>";
// close connection
mysql_close($connection);
}
?>

</body>
</html>

lancey10

thanks, but how will this connect to a php file that uses the url?