getting data from db to appear on a new page

[SimplyHiredGuy]

can someone give me some ideas on how to get the data i am retrieving from the db to appear on a new page. i know php can only communicate with the server and not the client. would javascript be the easiest way? thanks.

[m_tt]

oh my, you have much to learn young one

www.php.net

[thorpe]

what do you mean 'on a new page'? how do you plan on getting to this 'new page'?

just make a link to the page (this is a new page) containing your script to display from the db.

[SimplyHiredGuy]

"just make a link to the page (this is a new page) containing your script to display from the db."

that doesn't really make any sense to me. how do i get the data to appear on the same page, but clear the page so it is blank before the data from the db appears? the script is on the same page, not another page.

[thorpe]

have you got any code? maybe something like...?

if (!isset($_GET['view'])) {
  // default page with a link to view the database
  echo '<a href="'.$_SERVER['PHP_SELF'].'?view=db">view database</a>';

} elseif ($_GET['view'] == 'db') {
  // retrieve and display db records

}

is this something like what you mean?

[jonabomer]

where is your select information coming from?

is it a form?

if it is you can make the "form.php" file its own action!

Ex:
<form action="form.php" method="your_choice(I like POST)">...</form>

send your search $vars to the sql statement - make the statement a $var

Ex:

$sql_var = "SELECT $_POST[form_element_value] FROM $_POST[form_element_value] WHERE $_POST[form_element_value] = $_POST[form_element_value];

from there if you execute something like this

/////////////make connection
mysql_connect(your_host, your_user_name, your_pass );

////////////select db
mysql_select_db(your_db );

/////////////store query in $var
$query=mysql_query($sql_var);

////////////while loop prints till SELECT results have been depleated

while($row=mysql_fetch_array($query, MYSQL_ASSOC){
echo"$row<br/>";//I think this should print each entire row result - when I used this method I accessed the array elements like this -> echo"$row[element_I_wanted_by_field_name]";
}

hope this helps you forward with things ;o)

[SimplyHiredGuy]

here is what i have so far. when i execute the code, nothing happens. i have data on this page so i either need to clear the page or open up a new page to view the new data from the db.

if($rawJobs2Host == "PRODUCTIONRAWJOBS")
{

			//user wants to browse, get browsable fields list
			$browseFields = $_POST['browseFields'];

			//create SQL query for browsing
			$browseQuery = "SELECT ";

			for($i = 0; $i < count($browseFields); $i++)
						{
							if($i == (count($browseFields) - 1))
							{
								if($browseFields[$i] == "detail_page_html")
									$browseQuery .= "SUBSTRING(detail_page_html, 0, 10)";
								else
									$browseQuery .= $browseFields[$i];
							}
							else
							{
								if($browseFields[$i] == "detail_page_html")
									$browseQuery .= "SUBSTRING(detail_page_html, 0, 10),";
								else
									$browseQuery .= $browseFields[$i].",";
							}
						}

				$dbConnection = DB::connect("mysql://$rawJobs2User:$rawJobs2Pass@$rawJobs2Host/$rawJobs2Db");
			 	$resultSet = $dbConnection->query($browseQuery);


			 	if(DB::isError($resultSet))
								{
									$dbConnection->disconnect();
									echo "The following error occured while trying to query the database: <br>";
									die($resultSet->getUserInfo());
								}


								while($row = mysql_fetch_row($resultSet))
										{

											if(DB::isError($row))
											{
												$dbConnection->disconnect();
												echo "The following error occured while trying to fetch site records from the database: <br>";
												die($row->getUserInfo());
											}
												echo "$row <br>";

										}

			}

[SimplyHiredGuy]

does anyone wanna comment on my code? it would be greatly appreciated.

[bradgrafelman]

I only see text, no code. Wrap your 'code' in

 tags, and it'll be much easier to spot simple errors, along with some aesthetically pleasing colors :)

Also, good coding styles like indents and such help a bunch too.

Other than that, what are we commenting on?

[SimplyHiredGuy]

i did indent the code, it didn't show up correctly though. i am trying to get some data i requeted from the db to appear on the page, but i dont know how to get it on a new page or clear the current page so i can display the data there.

if($rawJobs2Host == "PRODUCTIONRAWJOBS")

[SimplyHiredGuy]

<?php

if($rawJobs2Host == "PRODUCTIONRAWJOBS")
{

//user wants to browse, get browsable fields list
$browseFields = $_POST['browseFields'];

//create SQL query for browsing
$browseQuery = "SELECT ";

for($i = 0; $i < count($browseFields); $i++)
{
if($i == (count($browseFields) - 1))
{
if($browseFields[$i] == "detail_page_html")
$browseQuery .= "SUBSTRING(detail_page_html, 0, 10)";
else
$browseQuery .= $browseFields[$i];
}
else
{
if($browseFields[$i] == "detail_page_html")
$browseQuery .= "SUBSTRING(detail_page_html, 0, 10),";
else
$browseQuery .= $browseFields[$i].",";
}
}

$dbConnection = DB::connect("mysql://$rawJobs2User:$rawJobs2Pass@$rawJobs2Host/$rawJobs2Db");
$resultSet = $dbConnection->query($browseQuery);

if(DB::isError($resultSet))
{
$dbConnection->disconnect();
echo "The following error occured while trying to query the database: <br>";
die($resultSet->getUserInfo());
}

while($row = mysql_fetch_row($resultSet))
{

if(DB::isError($row))
{
$dbConnection->disconnect();
echo "The following error occured while trying to fetch site records from the database: <br>";
die($row->getUserInfo());
}
echo "$row <br>";

}

}

?>

[jonabomer]

ok your code is a little difficult to read because its not "php formatted" and I think I may be seeing thimgs that are wrong or I've just never seen before (I dont know) but to help you on the new page part there is something I left out before (sorry bout that) that I can share.

to get a "clear page" by submitting the form to itself as its own action all you have to do is give your submit button a name (like name="submit") as well as a value (like value="GO!")

then youll put the form code in an if clause and the processing in its else clause as such...

if(!isset($_POST['submit']){
//put your entire form here
}else{
//put all of your processing of $_POST[] vars here
}

in the mean time the rest is pretty confusing to me - I've never seen DB::connect(); before are you using MySQL or something else because to do this I use mysql_connect();

a couple of other things $browsefields starts out as an item in your POST array but later you treat it as an array itself, it it a list of radio buttins or something, it doesnt feel right looking at this code, also lastly your loop are you looping up or down because you have the breaking condition of the loop as $i<count($browseFields) but then you increment $i with i++

$i will never be less then if your adding to it but the loop may never start if $i is less then count($browsefields) to begin with.

maybe it would help if you could edit your post (right above the new thread/new post buttons on the bottom right of your post) and add the php tags around your code

like this

PHP
your code
/PHP

the tags use [] not <> but I cant put the PHP and /PHP inside because it thinks I'm actually tryingt to write code - but I hope you get the idea

[bradgrafelman]

For the sake of everyone reading this thread, below is the same code as posted by SimplyHiredGuy, the only change is using the forum's PHP tags and indentions using tabs - the line numbers are the SAME.

<?php 

if($rawJobs2Host == "PRODUCTIONRAWJOBS") 
{ 

//user wants to browse, get browsable fields list 
$browseFields = $_POST['browseFields']; 

//create SQL query for browsing 
$browseQuery = "SELECT "; 

for($i = 0; $i < count($browseFields); $i++) 
{ 
	if($i == (count($browseFields) - 1)) 
	{ 
		if($browseFields[$i] == "detail_page_html") 
			$browseQuery .= "SUBSTRING(detail_page_html, 0, 10)"; 
		else 
			$browseQuery .= $browseFields[$i]; 
	} 
	else 
	{ 
		if($browseFields[$i] == "detail_page_html") 
			$browseQuery .= "SUBSTRING(detail_page_html, 0, 10),"; 
		else 
			$browseQuery .= $browseFields[$i].","; 
	} 
} 

$dbConnection = DB::connect("mysql://$rawJobs2User:$rawJobs2Pass@$rawJobs2Host/$rawJobs2Db"); 
$resultSet = $dbConnection->query($browseQuery); 


if(DB::isError($resultSet)) 
{ 
	$dbConnection->disconnect(); 
	echo "The following error occured while trying to query the database: <br>"; 
	die($resultSet->getUserInfo()); 
}


while($row = mysql_fetch_row($resultSet)) 
{ 

	if(DB::isError($row)) 
	{ 
		$dbConnection->disconnect(); 
		echo "The following error occured while trying to fetch site records from the database: <br>"; 
		die($row->getUserInfo()); 
	} 
echo "$row <br>"; 

} 

} 

?>

I believe jonabomer's post might have some misleading points in it, let me share what I know:

in the mean time the rest is pretty confusing to me - I've never seen DB::connect(); before are you using MySQL or something else because to do this I use mysql_connect();

PEAR :: Manual :: DB::connect()

a couple of other things $browsefields starts out as an item in your POST array but later you treat it as an array itself, it it a list of radio buttins or something, it doesnt feel right looking at this code

If you'll note this line:

$browseFields = $_POST['browseFields']; 

you can see he defines the variable and fills in the value with the POST'd value. It's easier to type "browseFields" than "_POST['browseFields']" !

also lastly your loop are you looping up or down because you have the breaking condition of the loop as $i<count($browseFields) but then you increment $i with i++

Either you aren't familiar with for() loops, or you misinterpreted his code. To me, the for() loop looks fine. $i starts out as 0, and as long as it is less than the number of fields contained in the array 'browseFields' it will work fine. I would agree with you, however, that it seems strange to treat the POST element as an array. Though there are certain ways that this situation can happen, I think SimplyHiredGuy needs to clarify and tell us exactly what is the 'browseFields' POST'd element.