[Resolved] those php?foo=1 pages..need help

kicktd

ok ok yes I know its been posted before and I read it..well I am just new to MySql and PHP so please forgive me 🙂 ok I read that you have to get it from the mysql database and all that but not too sure how exactly to stick something into the database. Also does it support html coding? MySql that is. And how exactly would the php code look? 😕 I am just wondering cause my website will have pages with 1 2 3 etc and I want to save on actual pages on the site. so can anyone help? Thanks!!

planetsim

Are you wanting to know how to put html code in the database.. ..

If so the same as you would with normal text.. However you will need to addslashes to all "

kicktd

yes like is there any special way you have to inject it? and by slashes to " what do you mean? sorry for being so new but been trying to learn 3 other programming languages at the same time and my mind is just about fried 🙁 I think once I learn that I can use the other code I seen to get the content. I just dont want to mess up MySql lol
EDIT: when I tried with a simple test message in the mysql databse I used the script from one of the posts

<?php if (! isset($_GET['section']))
  {
  $section =1 ;
  }
else
  {
  $section = $_GET['section'];
  }
   $query = mysql_query("SELECT * from table where section = $section");
?>

I got a couldnt access database using password:NO error. And I am not sure I set it up right. I replace table of course with the correct one. so can anyone help? this is really starting to confuse me 😕

kicktd

ok I fixed the connection problome that was easy and I added the link to page.php?page=2 and the page refreshes but all it shows is the content from the page.php. someone please tell me what I am doing wrong

scoppc

you should use the name "section" instead of "page" in page.php?page=2

zmola

Hi. Gurus, please correct the following if needed.

If get_magic_quotes_gpc() == 1, then there's no need to do addslashes() for GPC data.

If get_magic_quotes_runtime() == 0, then do addslashes() for runtime data if slashed data is wanted.

If retrieving data from a MySQL DB, where slashed data was inserted, there's no need to do stripslashes().

If slashed data is to be echoed onscreen, no MySQL DB involved, then do stripslashes() if wanted.

Some MySQL DB administration tools may, for example, show " unslashed but \ and ' as slashed, when viewing slashed data.

The actual slashes should not be seen in your MySQL DB, when viewing slashed data via SSH.

Cheers.

kicktd

ok doing as you guys suggested didnt work either. nothing is getting pulled from the mysql and displayed on the page. the only thing that is shown on the page is page 1's content. the page refreshs but thats it. sorry to bug you guys but this is just really irritating me as I like things to work 😉 I guess I will have to go pick up a PHP programming book next month (plan on it anyways). but if anyone can help in the meantime many thanks.

scoppc

Ok, try this one instead...

<?php 
if (empty($_GET['section'])) { 
  $section =1 ; 
}else{ 
  $section = $_GET['section']; 
} 
$query = mysql_query("SELECT * from table where section = $section"); 
?>

laserlight

especially since you're just starting out, it might be better to re-implement scoppc's suggestion as:

<?php
if (empty($_GET['section'])) {
	$section = 1 ; 
} else {
	$section = $_GET['section'];
}
$query = mysql_query("SELECT * from table where section='$section'")
	OR die("Couldnt select section from table: " . mysql_error());
?>

kicktd

thank you tons laserlight! that code helped me find the problome! I will be able to get it to work from here 😃

kicktd

ok..just before this gets burried and closed forever can someone check to see if this is correct:

<?php 
$con = mysql_connect("localhost","myusername","mypass"); 

$selectdb = mysql_select_db("mydb",$con);

if (empty($_GET['section'])) {
    $section = 1 ; 
} 
else 
{
    $section = $_GET['section'];
}
$query = mysql_query("SELECT * from test2 where test = '$section' ")
    OR die("Couldnt select section from table: " . mysql_error());
?>

I am just wondering cause no errors or anything just the refresh with same content as page.php problome. anyways sorry for any annoyingness 🙁