PHP - When To Close And Open The Php Tags...

Do anyone know how i can put the html tags in the same line as the other html tags?

Here's an example:

Code: [Select]
Images | Link | Delete | Enabled

On my code, it break the tags to the new line without put on the same line as the other tags.


Here's the code:

Code: [Select]
[code]<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypass');
    define('DB_DATABASE', 'mydbtable');

    $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));
    }

    $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    if($username == '') {
  $errmsg_arr[] = 'username ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD ID missing';
  $errflag = true;
    }

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE username='$username' AND passwd='$password'";
  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());

if(mysql_num_rows($result) > 0) {
  $qrytable1="SELECT images, id, public FROM members WHERE username='$username'";
  $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());

  while ($row = mysql_fetch_array($result1)) {  
  echo '<p id="images"> <a href="images.php?id='.$row['id'].'">Images</a></td> | <a href="http://' .  $row["links"] . '">Link</a> </td> | <a href="delete.php?id='.$row['id'].'">Delete</a> </td> |  <p> <p id="test">'.$row['Public'].'</td>'';
  }
}
}
?>[/code]

Say I have the following text stored in a MySQL database...

Code: [Select]
<b>Classic Quote from movie</b>
and I retrieve it into a variable called $text, how do I properly echo that so that it keeps the bold tags and actually display the text "Classic quote from movie" in BOLD?

I'm doing something wrong somewhere along the line (simply doing "echo $text;") because it displays on the page as...

Code: [Select]
<b>Classic Quote from movie</b>

Instead of...

Classic Quote from movie

Any info on properly storing and echoing back HTML would be very appreciated.

Is this necessary?
mysql_close($link);

$query =  "SELECT * FROM db_one WHERE field1 = '".$MyVar."'";
$results = mysql_query($query);
while($line = mysql_fetch_array($results))
{
echo $line["a"].",,";
echo $line["b"].",,";
echo $line["c"].",,";
echo $line["d"].",,";
echo $line["e"].",,";
echo $line["f"].",,";
echo $line["g"].",,";
echo $line["h"].",,";
echo $line["i"].",,";
echo $line["j"].",,";
echo $line["k"].",,";
echo $line["l"].",,";
}

mysql_close($link);

I am trying to create a login menu where senior salesman get redirected to one page and salesman get redirected to another.

Hi,   Ive been trying to come up with a simple solution. I run a scheduled task every 1 minute, it checks for a certain message in a MySQL DB. If the message is there then i need to access a link such as:   https://www.somedoma...00000&body=This is the SMS to be sent&plaintext=1   This essentially sends an SMS to a user. both the recipient and the body need to be a variable.   Is there a way then to get PHP to load/run the link without actually opening a browser?   ive been trying to check out allow_url_fopen but i cant seem to find any examples of how this works. Any info or pointers would be great thanks.

Trying to figure out my game map. Here is what's going on: Any player can view themself on the map and also the user at this location: x:50, y50. For some reason the map will not show anyone else.

If you would like to see it, just go to http://www.gglegends.net/map.php and login with the credentials below (only 1 user can be logged in at a time):

Credential for Demo Account - (I have restricted areas that affect others gameplay and areas that change the demo account)
Username: demo
Password: pass

Other map locations to try out:
x:60, y:60
x:19, y:79
x:98, y:72
x:75, y:51
x:97, y:26
x:66, y:12


Here is the complete code to my map:

<?php
require 'includes/header.php';

//Check to see if user exists in the map table, if not redirect location to get coordinates
$user_map_check_results = $db->query ("SELECT * FROM map WHERE uID=".$user['uID']."");
$user_map_check = mysql_num_rows($user_map_check_results);

if ($user_map_check == 0){

echo '<META HTTP-EQUIV="Refresh" Content="0; URL=firstrun.php">';

die();
}

//Fetch the largest x coordinate in the map table.
$map_size_x_result = $db->query( "SELECT MAX(x) AS map_max_x FROM map" );
$map_size_x = $db->fetch( $map_size_x_result );

//Fetch the largest y coordinate in the map table.
$map_size_y_result = $db->query( "SELECT MAX(y) AS map_max_y FROM map" );
$map_size_y = $db->fetch( $map_size_y_result );

//Set map size. Determined by largest x and y coordinates.
$grid_x = (int)$map_size_x['map_max_x'];
$grid_y = (int)$map_size_y['map_max_y'];

//x and y rows to display at a time.
$display_rows = (int)10;

//Fetch all user locations.
$users_map_result = $db->query( "SELECT * FROM map LEFT JOIN users ON map.uID=users.uID" );
$users_map = $db->fetch( $users_map_result );

//Fetch user map location from database.
$user_location_result = $db->query( "SELECT * FROM map LEFT JOIN users ON map.uID=users.uID WHERE map.uID=".$user['uID']."" );
$user_location = $db->fetch( $user_location_result );

//default display coordinate if none specified - will be user map location.
$x = (int)$user_location['x'];
$y = (int)$user_location['y'];

$param_x = $_REQUEST["xcord"];
$param_y = $_REQUEST["ycord"];

if (isset($param_x) && isset($param_y)) {
    //validate that the parameter is a legit point.
    if (($param_x <= $grid_x) && ($param_x >= 1) && ($param_y <= $grid_y) &&($param_y >= 1)) {
        $x = (int)$param_x;
        $y = (int)$param_y;
    }
}

//set map location to the center of the map.
$display_half = round($display_rows / 2);
$other_half = $display_rows - $display_half;

//display the target in the middle.
$start_x = ($x - $display_half) +1;
$end_x = $x + $other_half;

//if the $start_x variable is less than 1 the grid would be in the negatives. so set it to 1.
if ($start_x < 1) {
    $start_x = 1;
    $end_x = $display_rows;
} else
//if $end_x is off the grid we have to compensate and add the remaining rows to the start.
if ($end_x > $grid_x) {
    $extra = $end_x - $grid_x;
    $end_x = $grid_x;
    $start_x = $start_x - $extra;
}

//same applies for the y axis.
$start_y = ($y - $display_half) +1;
$end_y = $y + $other_half;

//if the $start_y variable is less than 1 the grid would be in the negatives. so set it to 1.
if ($start_y < 1) {
    $start_y = 1;
    $end_y = $display_rows;
} else
//if $end_y is off the grid we have to compensate and add the remaining rows to the start.
if ($end_y > $grid_y) {
    $extra = $end_y - $grid_y;
    $end_y = $grid_y;
    $start_y = $start_y - $extra;
}
?>

<b><tl>World Map</tl></b><br />
<img alt="" src="images/seperator.gif" /><br />
Click anywhere on the map to begin moving around. You can click on players name's to view their profile.<br /><br />
Move to Map Location or <a href="map.php"><u>Return to base</u></a>. <?php echo "Current Map Coordinates: X $x - Y $y"; ?><br />
<!-- Search custom coordinates -->
<form action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" method="GET">
<input name="xcord" type="text" size="3" maxlength="2" onblur="if ( this.value == '' ) this.value = this.defaultValue" onfocus="if ( this.value == this.defaultValue ) this.value = ''" value="x">&nbsp;<input name="ycord" type="text" size="3" maxlength="2" onblur="if ( this.value == '' ) this.value = this.defaultValue" onfocus="if ( this.value == this.defaultValue ) this.value = ''" value="y">&nbsp;<input type="submit" value="Submit">
</form>
<br /><br />

<!-- Show map -->
<table width="750" cellspacing="0" cellpadding="1" border="0">
<?php
//these 2 for loops represent the y and x axis
//using the data collected above the loops will properly display the grid.
for ($Ty = $start_y; $Ty <= $end_y; $Ty++) {
    //start new row
    echo '<tr>';
    for ($Tx = $start_x; $Tx <= $end_x; $Tx++) {
        //show grid
        DisplayGrid($Tx,$Ty);
    }
    echo '</tr>';
}
?>
</table>


<?php
//Function to disaply the map.
function DisplayGrid($grid_x,$grid_y) {
    global $x, $y, $user_location, $users_map;
    
    $bgimg = 'grass.gif';

$building = '';

if ($grid_x == $user_location['x'] &&  $grid_y == $user_location['y']) {

$building = '<img src="images/map/building.gif" alt="" border="0" /><br />';

$user_map_name = '<br /><a href="player_profile.php?id='.$user_location['uID'].'" target="_blank"><u><b>'.$user_location['uLogin'].'</b></u></a><br />';

}

if ($grid_x == $users_map['x'] && $grid_y == $users_map['y']) {

$building = '<img src="images/map/building.gif" alt="" border="0" /><br />';

$user_map_name = '<br /><a href="player_profile.php?id='.$users_map['uID'].'" target="_blank"><u><b>'.$users_map['uLogin'].'</b></u></a><br />';

}
    
    echo "<td width=\"75\" height=\"75\" style=\"background-image: url('images/map/$bgimg');background-repeat: repeat;\" align=center valign=center onclick=\"window.location.href='map.php?xcord=$grid_x&ycord=$grid_y'\">$building $user_map_name</td>";
}

require 'includes/footer.php';
?>

I have a problem, where i need to know when user leave or close tha browser tab. I tryd to make a ajax post, after unload, make a POST into kill_browser.php and after 1 minute when session_expire, php code will be execute and save time into database. But it not seems to work :/ I'm glad if some 1 can say what im doing wrong, or is there eny better way to detect it.   @home.php   var leaved = 'leaved';
$(window).unload(
        function(){
            $.ajax({
            url: 'kill_browser.php',
            global: false,
            type: 'POST',
            data: leaved,
            async: false,
            success: function() {
            console.log('leaved');
            }
        });
    });   @kill_browser.php <?php

require('class/connection.php');
$conn = new connection();
session_cache_limiter('private');
$cache_limiter = session_cache_limiter();
session_cache_expire(1);
$cache_expire = session_cache_expire();
session_start();
$_SESSION['leaved'] = $_POST['leaved'];
if($_SESSION['leaved'] == null || $_SESSION['leaved'] == " "){
    $conn->logOut($_SESSION['userID'], $_SESSION['userIP'], $_SESSION['LAST_GENERATED_ID']);
    session_regenerate_id(true);
    unset($_SESSION);
    session_destroy();
    header('location:index.php');
}
?>

Hey there,

I currently have a banning system on my site that doesn't allow users to login with the banned account. But the cookies are set to remember them for a year. How can I destroy their cookie, so that they don't stay logged in and continue to use the site?

Hi there, I was wondering if it is possible to (on the closing of a browser to a logged in user) to automatically destroy that session. Thanks in advance.

hope i'm in the right place.

Hello,my name is carlton.
i have a html form i created in dreamweaver cs.
i have the accompanying .php script to forward
user details to the server. i fill in the form,
hit the submit button and nothing appears in
the table i created. the testing server has been
successfully configured the database "babiesnmovies"
is recognized by dreamweaver.
PLS tell me what i'm missing.

below is a copy of the form and the script.

Thank you so much.


//this is the HTML registration web form i created in dreamweaver//

  Code: [Select]
<legend>Parents Contact Information</legend>
      </h3>
      <form id="form1" name="form1" method="PUT" action="babiesnmovies.php">
        <p>
          <label for="babiesnmovies.com/register">Your First Name</label>
          <input type="text" name="yourfirstname" id="babiesnmovies.com/register" />
          <label for="babiesnmovies.com/registered">Your Last Name</label>
          <input type="text" name="yourlastname" id="babiesnmovies.com/registered" />
        </p>
        <label for="babiesnmovies.com/yourname">Your Phone Number</label>
        <input type="text" name="yourphonenumber" id="babiesnmovies.com/yourname" />
        <label for="babiesnmovies.com/email">Your E-mail</label>
        <input type="text" name="youremail" id="babiesnmovies.com/email" />
        </p>
    </form>
        <p>&nbsp;</p>
    <h3>
      <legend>Baby's Vitals</legend>
    </h3>
    <form id="form2" name="form2" method="PUT" action="babiesnmovies.php">
      <p>
        <label for="babiesnmovies.com/baby'slast">Baby's First Name</label>
        <input type="text" name="babysfirstname" id="babiesnmovies.com/baby'sfirst" />
        <label for="babiesnmovies.com/babies">Baby's Middle Name</label>
        <input type="text" name="babysmiddlename" id="babiesnmovies.com/babies" />
      </p>
      <p>
        <label for="babyslastname">Baby's Last Name</label>
        <input type="text" name="babyslastname" id="babyslastname" />
      </p>
      <p>
        <label for="babiesnmovies.com/babybday">Baby's Birthdate</label>
        <input type="text" name="babysbirthdate" id="babiesnmovies.com/babybday" />
        <label for="babiesnmovies.com/babyage">Baby's Age</label>
        <input type="text" name="babysage" id="babiesnmovies.com/babyage" />
       
      </p>
      <p>
        <label for="babiesnmovies.com/baby">Baby's Height</label>
        <input type="text" name="babysheight" id="babiesnmovies.com/baby" />
        <label for="babiesnmovies.com/babyweight">Baby's Weight</label>
        <input type="text" name="babysweight" id="babiesnmovies.com/babyweight" />
      </p>
      <p>
        <label for="babiesnmovies.com/babyeyes">Baby's Eye Color</label>
        <input type="text" name="babyseyecolor" id="babiesnmovies.com/babyeyes" />
        <label for="babiesnmovies.com/babyhair">Baby's Hair Color</label>
        <input type="text" name="babyshaircolor" id="babiesnmovies.com/babyhair" />
      </p>
      <p>
        <label for="babiesnmovies.com/babyrace">Baby's Ethnicity</label>
        <input type="text" name="babysethnicity" id="babiesnmovies.com/babyrace" />
      </p>
      <p><input name="formsubmit" type="submit" value="Submit" />
    </form>
//this is the babiesnmovies.php script//

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_babiesnmovies = "XXX";
$database_babiesnmovies = "XXX";
$username_babiesnmovies = "XXX";
$password_babiesnmovies = "XXX";
$babiesnmovies = mysql_pconnect($hostname_babiesnmovies, $username_babiesnmovies, $password_babiesnmovies) or trigger_error(mysql_error(),E_USER_ERROR); 


mysql_select_db("db337879506", $con);
 $sql="INSERT INTO register (id, YourFirstName, YourLastName, YourPhoneNumber, YourEmailAddress, BabysFirstName, BabysMiddleName,
 BabysLastName, BabysBirthdate, BabysAge, BabysHeight, BabysWeight, BabysEyeColor, BabysHairColor, BabysEthnicity) values ( 'NULL','$yourfirstname',                  '$yourlastname', '$yourphonenumber', 'youremailaddress', '$babysfirstname', '$babysmiddlename', '$babyslastname', '$babysbirthdate', '$babysage', '$babysheight', '$babysweight', '$babyseyecolor', '$babyshaircolor', '$babysethnicity')";



$yourfirstname = $_POST ['YourFirstName'];
$yourlastname = $_POST ['YourLastName'];
$yourphonenumber = $_POST ['YourPhoneNumber'];
$youremailaddress = $_POST ['YourE-mailAddress'];
$babysfirstname = $_POST ['BabysFirstName'];
$babysmiddlename = $_POST ['BabysMiddleName'];
$babyslastname = $_POST ['BabysLastName'];
$babysbirthdate = $_POST ['BabysBirthdate'];
$babysage = $_POST ['BabysAge'];
$babysheight = $_POST ['BabysHeight'];
$babysweight = $_POST ['BabysWeight'];
$babyseyecolor = $_POST ['BabysEyeColor'];
$babyshaircolor = $_POST ['BabysHairColor'];
$babysethicity = $_POST ['Babys Ethnicity'];

?>


Thank you.

hi, im trying to parse this xml  file : 
xml.gamebookers.com/sport /football.xml_attr.xml

i want to echo on my page like this :

league name 1
match 1 of league 1
odds odds odds
match 2 of league 1
odds odds odds
.
.
league name 2
match 1 of league 2
odds odds odds
match2 of league 2
odds odds odds
.
.


this is my code so far

<?php
$xml=simplexml_load_file('http://xml.gamebookers.com/sports/football.xml_attr.xml');

$league=$xml->xpath('//event/..');             // leagues refers to element<group> 
$matches=$xml->xpath('//bettype[@name="Versus (with Draw)"]/..'); // shows matches name (team versus team)
$odds=$xml->xpath('//event/bettype[@name="Versus (with Draw)"]/bet'); //odds of matches 1 x 2


$leaguecount=count($league);
$matchescount=count($matches);
$oddscount=count($odds);

$i=0;

while ($i<$leaguecount){
echo $league[$i]['name'].'<br>';
$i++;
}

echo '<br><br>';

$i=0;
while ($i<$matchescount){
echo $matches[$i]['name'].'<br>';
$i++;
}

$i=0;
while ($i<$oddscount){
echo $odds[$i]['odd'].'<br>';
$i++;
}

?>


it prints this:
http://www.mh724.com/school/xp.php

so i need something like that:
echo league[$i][mathces[$i][odds[$i]  // like arrays of array but it does not work of course

any help will highly appreciated  :shrug:

with regardS

I have a script there download a lot of images from a website it crawls, but when ever i started a crawler, it will keep downloading images.
Even if i close firefox, it will continue to download images from the site.

How can i stop it?.

I need to close a window if referer not valid, but it cannot be in HTML, needs to be php. This is what I have so far:

Code: [Select]
if (ereg("http://www.mysite.com/test.php", $_SERVER['HTTP_REFERER']) != true){
header('Location: ?????????');
exit;
} I get a header already sent message if I use a URL. I need it to close the window after 3 seconds.

Any ideas?

Hi guys,

This is very important. The supervisor of my system wants to close accounts which contain zero balances for long time periods.

There is a separate page contains ID and Account Number.This is included in a form and a "close account" button is there.

When he clicks on that button the relevant record should be deleted from all tables which include that ID.

The table structure looks like this. There are 4 account types which contain same fields.

 savings_investment(ID,account_type,full_name_balance,interest,customer_id)

I want full coding of this scenario.

Thanks,
Heshan

I think I might have already asked something similar, but...

my code has:

$ip = gethostbyaddr($_SERVER['REMOTE_ADDR']);
$host = $_SERVER['HTTP_HOST'];

my field header for "$host" is "VISITOR DOMAIN ADDRESS".  I'm not sure what I was thinking.  That's not possible to capture is it?  Last I read, and I think someone here told me, it is only possible to capture the IP and server name of the requesting computer?  the var $ip in my report, for instance, returns:

173-28-199-198.client.mchsi.com

if I visit the page, and that is the name of the server assigned to my ISP.  on PHP's doc page, there are the vars REMOTE_HOST and REMOTE_USER and I haven't tried those.  Their example does not list any return value for those vars.  what do they return?

Edited November 23, 2019 by ajetrumpet