Problem of redirect to a page

mark103

Hi guys,

I have a problem with my php script. I am trying to print out the data from the mysql database and input the data in the page source that come with html tags without print it out and I am also trying to redirect to a page like google. However the data have been print out on my php page which I only want to print the data from mysql to input them in the page source without print in the page and redirect to a page like google.

here's the code:

<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypassword');
    define('DB_DATABASE', 'mydbname');

$errmsg_arr = array();
$errflag = false;

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

$db = mysql_select_db(DB_DATABASE);
if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }

$encryption = clean($_GET['strings1']);
if($strings1 == 'sgdsgdsgsgd') {
  $query  = "SELECT strings FROM table1";
  $result=mysql_query($query) or die('Error:<br />' . $qry . '<br />' . mysql_error());
 while ($row = mysql_fetch_array($result)) { 
  echo "<p id='strings1'>";
  echo $row['strings1'] . "</p>";
   }
  }
   else {
  $qrytable1="SELECT name FROM members";
  $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());


while ($row = mysql_fetch_array($result1)) {
  echo "<p id='mydata'>";
  echo $row['mydata'] . "</p>";
 }
  $URL="http://www.google.com";
  header ("Location: $URL");
    }
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
}
?>

Any advice would much appreciate.

Thanks,
Mark

djjjozsi

Any advice would much appreciate.

Try to ask this question again, and be more specific.
Clean your code, indent it and apply comments for better understanding..

In the first look, in your "if else" case where the $string is not 'sgdsgdsgsgd'
you list all the members, but you query down only the name field.

In you rest code you're trying to access the "mydata" field (you have not selected before!!).

For the test you should use "select * from members" sql query instead.

If you redirect a page in server side , the previously displayed contents may cause an error message! "header already sent..."

djjjozsi

to input them in the page source without print in the page

use htmlspecialchars() on the inputs if you need to visible them on the page.

page and redirect to a page like google.

google uses <a href></a> to 'redirect' you a specified page.

mark103

djjjozsi;10974748 wrote:
use htmlspecialchars() on the inputs if you need to visible them on the page.

please could you post an example code please?

djjjozsi

while ($row = mysql_fetch_array($result1)) {
  echo htmlspecialchars($row['mydata']) . "</p>";
}

If you have HTML codes in the mydata field, the codes will be displayed and not embedded/processed in the HTML file.

mark103

djjjozsi;10974793 wrote:
while ($row = mysql_fetch_array($result1)) {
  echo htmlspecialchars($row['mydata']) . "</p>";
}
If you have HTML codes in the mydata field, the codes will be displayed and not embedded/processed in the HTML file.

Thanks, but the data have been print on my php page which I want to set them to be visible so no one would be able to see it. I want to extract the data from mysql database and input them in the page source only, not print on php page.

Any idea in what situation that I should use?

djjjozsi

then ask this question again, and go into the details what do you want to make, forget the original codes you have!

so?

mark103

djjjozsi;10974812 wrote:
then ask this question again, and go into the details what do you want to make, forget the original codes you have!

so?

wtf...you should go and read my post again, even noobie is too lazy and cant be arsed to read what I have asked for!

READ THIS AGAIN!
I want to extract the data from the database and input them in the page source to be visible, so no one would be able to see it. Then redirect to a site like google.com.

djjjozsi

Its is just a simple question:
-How google redirects you?
It is using an URL? Then you should make an URL...
Why is good for you to display data on a page and redirect to google?

noobie is too lazy and cant be arsed to read what I have asked for!

maybe i'm the only lazy noobie who may help you.

instead of this line:

header ("Location: $URL");

Use a HTML meta redirect with countdown:

<meta HTTP-EQUIV="REFRESH" content="5; url=<?php echo $URL ?>">

mark103

djjjozsi;10974831 wrote:
Its is just a simple question:
-How google redirects you?
It is using an URL? Then you should make an URL...
Why is good for you to display data on a page and redirect to google?

maybe i'm the only lazy noobie who may help you.

instead of this line:
header ("Location: $URL"); 
Use a HTML meta redirect with countdown:
<meta HTTP-EQUIV="REFRESH" content="5; url=<?php echo $URL ?>">

Thanks, I have changed from this:

header ("Location: $URL");

To this:

<meta HTTP-EQUIV="REFRESH" content="5; url=<?php echo $URL ?>">

I have got a blank page. I don't know what the problem is?

And do you know how to set the data to be visible in the php when I extract from the database?

djjjozsi

try to add a value into the $URL variable before the meta refresh line.

$URL="http://google.com";

data to be visible in the php when I extract from the database?

You have an echo inside the while cycle, this can ember the content from the sql field into your page. Just show the source code, you should see the contents.

If its not a secret, you can post a link where we can see the results.

If you explain your aim i might suggest you a more efficient way to do it.

mark103

djjjozsi;10974838 wrote:
try to add a value into the $URL variable before the meta refresh line.

$URL="http://google.com";

Still the same, I still have got a blank page. Any idea?

djjjozsi;10974838 wrote:
You have an echo inside the while cycle, this can ember the content from the sql field into your page. Just show the source code, you should see the contents.

If its not a secret, you can post a link where we can see the results.

If you explain your aim i might suggest you a more efficient way to do it.

Well I don't want to echo the data from mysql database to input in my php page, I want to hide the data without using echo, but the data can be found through the source code.

Just like this?

<php>
"<p id='mydata'>";
  $row['mydata'] . "</p>";
</php>

Hope you get this what I am trying to do?

djjjozsi

take the content between

Or you should use hidden divs...

<div style="visibility:hidden">   echo here the contents.. </div>

mark103

don't work. any idea?

djjjozsi

mark103;10974844 wrote:
don't work. any idea?

i cannot do anything till you don't show source codes, test url...

"don't work" is a sentence which makes the programmers frustrated! Be more specific please.

bradgrafelman

mark103 wrote:
want to hide the data without using echo, but the data can be found through the source code.

That doesn't make any sense. All the PHP code does is output data that is sent to the client's browser.

If you want to output data to the client's browser, then do so. If you don't want it to be rendered on the screen, then hide the content somehow.... CSS, HTML comments, etc.