PHP - How To Output The Db Data To Turn Into Hyperlinks?

Hey Guys,

I'm struggling with some logic of how to do something wondering if anyone can point me in the right direction.

Details:
I am making a PHP/MySQL game to learn more PHP, I've got my login/logout system created. However I am planning on the game been map based on a 100x100 grid. I have two tables:

USERS
Username, Password, x, y
Test, Test, 1, 1


MAP
X, Y, type
0,1,1
0,2,1
0,3,2
0,4,3
0,5,2
etc

I am stuck on how to get the user's logged in X and Y coordinates and then compare them with the map table X and Y, to see what type of field to show, 1,2 or 3.

Is there a name for this type of function so I can do some research on it? Or could someone give me an example? Would be fantastic if anyone has any advice.

Thanks in advance
NewcastleFan

trying to create a simpleprogram that will read a text file and output information and calculations using the data in the text file. I have 4 radio buttons which represent an item Number. when one is selected the output form should print to a table the ID,Part,Count, Price, and the inventory Value= ($count * $price), can anyone tell me what i am doing wrong?
This is what the .txt file looks like:

AC1000:Hammers:122:12.50
AC1001:Wrenches:5:5.00
AC1002:Handsaws:10:10.00
AC1003:Screwdrivers:222:3.00

Here's what i have so far:
Code: [Select]
<?php
$inf = 'infile.txt';
$FILEH = fopen($inf, 'r') or die ("Cannot open $inf");
$inline = fgets($FILEH,4096);
$found = 0;
//$ptno = 
//if (isset($_POST['AC1000']) || isset($_POST['AC1000']) || isset($_POST['AC1000']) || isset($_POST['AC1000'])) {
while (!feof($FILEH) && !($found)){
list($ptno,$ptname,$num,$price) = split (':', $inline);
if ($ptno == $id) {
print '<table border=1>';
print '<th> ID <th> Part <th> Count <th> Price';
print "<tr><td> $ptno </td><td>$ptname</td>";
print "<td> $num </td><td> \$price</td><tr>";
print '</table>';
$found = 1;
}
$inline = fgets($FILEH,4096);
}
if ($found !=1) {
print "Error: PartNo=$id not found";
}
fclose ($FILEH);
?>

Hi guys, is there anyway to process this $result from a mysql query inside PHP so that the data below will be formatted to a pivot-like table? The number of rows and columns of the output 'table' will be indefinite. Thanks so much!

Data:
ID   Row   Col   Name
1   1   A   A1
2   2   A   A2
3   3   A   A3
4   1   B   B1
5   2   B   B2
6   3   B   B3
7   1   C   C1
8   2   C   C2
9   3   C   C3


Results:
A1(1)   A2(2)   A3(3)
B1(4)   B2(5)   B3(6)
C1(7)   C2(   C3(9)

Well I have a script that executes a scan on a system set to run infinitely, and I need it to echo out a message each time it loops through, but I don't want it to echo out the message with the next loop message below it, and the next one below that etc... I've tried using the flush(); function and been messing around with that with no luck. For security reasons I don't want to release any of the processing code, but here is the basic construction of the script:

<?PHP
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
$RepeatIt = -1;
for($g=1; $g!=$RepeatIt+1; $g++)
{
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***

$ScanMessage = ":.:.: SCANNING THE HITLIST FOR MOBSTER: ".$MobName." (SCAN #$g) :.:.:"."<br/><br/>";
echo $ScanMessage;

***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
***PROCESSING AND SCAN CODE***
}
?>

At the moment it's returning:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #1) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #2) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #3) :.:.:

:.:.: SCANNING THE HITLIST FOR MOBSTER: DEUS EX DESTROYER (SCAN #4) :.:.:

So what I want it to do is just delete the scanning message and replace it with the next scan message so while running this script you would see just the number increment on the same line.

Any suggestions?

Thanks.

Hello.  I'm having trouble with using hyperlinks in PHP.  I've found several things online about using the print or echo command but for some reason it only gives the link as text and not an actual link.  I'm very new to PHP so please be gentle

<?php
$con = mysql_connect("localhost","xxxxx","xxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("addresses", $con);

$sql="INSERT INTO addresses (first_name, last_name, extra_info, address, city, state, zip)
VALUES
('$_POST[first_name]','$_POST[last_name]','$_POST[extra_info]','$_POST[address]','$_POST[city]','$_POST[state]','$_POST[zip]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";
echo "<a ref="http://localhost/index.html">Click here to enter another record</a>";
mysql_close($con)
?>

Hi.

I have made profile pages available for users.. How do I turn off <?php ?> for those pages?  I would like javascript enabled however. All suggestions are welcome!!

Thanks

How to turn off notices in PHP 5.3.

Is it possible to turn it off in php.ini?

Hello all,

I currently have some php code which upon a user clicking a search button connects to a back end posgresql database and outputs the users search results in the form of:

Hostname       IP Address        Operating System
--------------------------------------------------------------
HOSTA             1.1.1.1               Windows
HOSTB             2.2.2.2                Linux

With this i have no problem and it works fine. What i would like to do though is as i have each hostname outputted as a hyperlink, i want to be able  to then allow the user upon clicking the hyper link of any given hostname to be presented with a more detailed overview of the information associated with that host, i.e. the page reloads upon the user clicking the hyper link but instead of the previous search results the user is now presented with another HTML form populated by all the information stored in the database specific to that host.

I am just a bit confused as to how to track the hostname ect from a user clicking the hyperlink, I realise it is likely to be passed via a session variable but how do i set that from a click event of the hyperlink?

Thanks for taking the time to read this, any advice is appreciated.

Hi,

How would I do this, I'm trying to create a function to turn the octal (not sure whats its called exactly) input into its numberic representation, like so:

<?php
function octal_to_number($input) {
//do something...
return $number;
}

//would turn 0x17c into 380...
echo octal_to_number('0x17c');
?>

I've tried to find an answer in the forum and although there have been posts similar I am unable to covert the answer to fit what I've got (mostly because I know very very little about php - sorry).
What I need is one of the results to be added to the end of a url in order to create a link. Basically I have a storefront (www.storefront.com/) and the result NAME can be added onto the end of our url to create a link to the product page. (www.storefront.com/NAME)

Code: [Select]
<?php
$dbhost = "";
$dbuser = "";
$dbpass = "";
$dbname = "";
//Connect to MySQL Server
mysql_connect($dbhost, $dbuser, $dbpass);
//Select Database
mysql_select_db($dbname) or die(mysql_error());
// Retrieve data from Query String
$price = $_GET['price'];
$taxable = $_GET['taxable'];
$weight = $_GET['weight'];
// Escape User Input to help prevent SQL Injection
$age = mysql_real_escape_string($price);
$sex = mysql_real_escape_string($taxable);
$wpm = mysql_real_escape_string($weight);
//build query
$query = "SELECT * FROM Products WHERE taxable = '$taxable'";
if(is_numeric($price))
$query .= " AND price <= $price";
if(is_numeric($weight))
$query .= " AND weight <= $weight";
//Execute query
$qry_result = mysql_query($query) or die(mysql_error());

//Build Result String
$display_string = "<table>";
$display_string .= "<tr>";
$display_string .= "<th>Name</th>";
$display_string .= "<th>Price</th>";
$display_string .= "<th>Taxable</th>";
$display_string .= "<th>Weight</th>";
$display_string .= "</tr>";

// Insert a new row in the table for each person returned
while($row = mysql_fetch_array($qry_result)){
$display_string .= "<tr>";
$display_string .= "<td>'<a href="www.storefront.com/">' . $row[name] . ' </a>'/td>";
$display_string .= "<td>$row[price]</td>";
$display_string .= "<td>$row[taxable]</td>";
$display_string .= "<td>$row[weight]</td>";
$display_string .= "</tr>";

}
echo "Query: " . $query . "<br />";
$display_string .= "</table>";
echo $display_string;
?>
I know the way it is setup in the code is wrong. Can anyone help me out?
Would really appreciate it.

Thanks - and again, sorry for my lack of php knowledge.

Hi,

I have the below code which pulls pet types from the database, and when you pick the particular type by selecting a radio button amd press 'Select Pet Type' you are brought to a page listing all examples of that pet. Is there any way of changing this so the pet types are listed as hyperlinks instead and when you click each particular hyperlink you are brought to a page where that pet type is listed?

<?php
  /* Program: PetCatalog.php
   * Desc:    Displays a list of pet categories from the
              PetType table. Includes descriptions.
   *          Displays radio buttons for user to check.
   */
?>
<html>
<head><title>Pet Types</title></head>
<body>
<?php
  include("misc.inc");                                 #12

  $cxn = mysqli_connect($host,$user,$password,$dbname)   #14
         or die ("couldn't connect to server");

  /* Select all categories from PetType table */
  $query = "SELECT * FROM pettype ORDER BY petType";   #18
  $result = mysqli_query($cxn,$query)
            or die ("Couldn't execute query.");        #20

  /* Display text before form */
  echo "<div style='margin-left: .1in'>\n
  <h1 style='text-align: center'>Pet Catalog</h1>\n
  <h2 style='text-align: center'>The following animal 
      friends are waiting for you.</h2>\n
  <p style='text-align: center'>Find just what you want
      and hurry in to the store to pick up your 
      new friend.</p>
  <h3>Which pet are you interested in?</h3>\n";

  /* Create form containing selection list */
  echo "<form action='ShowPets.php' method='POST'>\n"; #33
  echo "<table cellpadding='5' border='1'>";
  $counter=1;                                          #35
  while($row = mysqli_fetch_assoc($result))            #36
  {
     extract($row);                                    #38
     echo "<tr><td valign='top' width='15%' 
                   style='font-weight: bold; 
                   font-size: 1.2em'\n";
     echo "<input type='radio' name='interest' 
                  value='$petType'\n";                 #43
     if( $counter == 1 )                               #44
     {
         echo "checked";
     }
     echo ">$petType</td>";                            #48
     echo "<td>$typeDescription</td></tr>";            #49
     $counter++;                                       #50
  }
  echo "</table>";
  echo "<p><input type='submit' value='Select Pet Type'>  
        </form></p>\n";                                #54
?>
</div>
</body></html>

How do I turn a checkbox on or off programatically?

My form has several checkboxes that are grouped together and I want them to be turned on initially when the user first sees the form.I can do that very easily by just including "checked" in the HTML for the checkbox. But if the user turns off the checkbox before he presses Submit, I want to make sure I show the ones that are off as off when I redisplay the form as a result of errors in other fields, like textareas.

How do I turn the checkbox off or on within my PHP code?

Edited June 9, 2019 by HenryCan

I've tried to use this http://www.bambalam.se/bamcompile/ .. but I cant get curl to work using the option to set the extension.. I need it to be able to sign into myspace or facebook with curl when it is in an exe.. everything else works fine with bambalam, everything but curl and connecting to an mysql db, I dont need to have mysql support, only curl.. what would be the easiest way to make this happen?

btw the exe should just open a CLI and run the script, thanks

Hello All,

I'm trying to put a lot of what I do into function calls now to make my code a bit tidier and consise.  Take this simple if statement:


if ($_GET['thedate'] =='') {
 $var = date('l, jS F, Y',time());
} else {
 $var = date('l, jS F, Y', strtotime($_GET['thedate']));
}


How could I put this into a function and in some kind of switch statement?

Thanks

 i have apache 2.2 and php 5.0 installed on my pc, i have a html page and i need to turn it into php and also i need to include a header and a footer, i tryed doing it but the webpage won't display, what am i doing wrong?

here is my page which i tryed turning into php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<!--index.html is basically an introductory page to this website, this page introduce us to this website. This page tell us, this page is called index.html because that's the name of the first page on any website, this page tell us wat type of website this is, name of this website, name of the person(in this case that's me) who made it, a light description of what type of contents we will find inside this website etc. This page tell us the name of this lab assignment which is " -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>INTN2201 - Lab 1</title><!--title of this page -->
<link href="./css/intn2201.css" rel="stylesheet" type="text/css" /></head>

<body>
<table border="1" >
<tr>
<td class="navmenu"><img src="images/my_logo.jpg" alt="My Logo" /></td>
<td class="page_header"><h1>INTN 2201: Lab Assignment 1: HTML Pages</h1></td>
</tr>
<tr>

    <td valign="top"> <a href="index.html" >MY HOME PAGE</a>
<br />
    <a href="lab1.html" >LAB 1:HTML Intro</a>
<br />
    <a href="lab2.html" >LAB 2:HTML Tables</a>
<br />
    <a href="lab3.html" >LAB 3:CSS Styles</a>
    </td>

<td class="main_body"><h2> Purpose of this website</h2>
<p class="p1"> This website was created for first lab assignment of <a href="http://opentech.durhamcollege.ca/~pufferd/intn2201">INTN2201</a>, <a href="http://opentech.durhamcollege.ca/~pufferd/intn2201">INTN2201</a>
 is the course code for "INTERNET DEVELOPMENT I" course, at <a href="http://www.durhamcollege.ca">Durham College</a> every first year student<br/>
of Computer System Technology program(3 years) have to take this course, main purpose of this site is to get a first feel for creating a basic html website<br/>

but also to get a feel of how to use it in website creation, during the creation of this page i get to know programs like notepad++,<br/>
WINSCP, learned how to login to course webserver(opentech.durhamcollege.ca), another purpose for this site is to test webpage creator's( in this case that's me)<br/>
knowledle about HTML tags, XHTML, W3C validator, HTML stands for Hyper Text,it is not a programming language it is a Markup Language,<br/>
I(creater of this website) wanted to learn about differen't html tags and one of the best ways to learn about html tags is to try create<br/>
a html webpage. </p>
<hr/>
<h2>ol {
margin-left : 200px;
}
</h2>
<p class="p2"> in this style tag i used Margine properties to define a list in lab2.html, bottom of the page u will see lists, so margine basically sets all the margin properties in one declaration.</p>
<hr/>

<a href="http://www.durhamcollege.ca/"> <img width="300" src="images/durham_college_logo.jpg" alt="My Logo" /></a>
<hr/>

</td>
</tr>
<tr>
<td class="navmenu" colspan="2" align="right"> &copy;2011

<p>

                                <a href="http://validator.w3.org/check?uri=referer">

                                <img style="width:88px;

                                               height:31px;

                                               position:fixed;

                                               bottom: 81px;

                                               left:50px;"

                                       src="http://www.w3.org/Icons/valid-xhtml10"

                                       alt="Valid XHTML 1.0 Transitional" />

                        </a>

                        </p>

                <p>

                        <a href="http://jigsaw.w3.org/css-validator/check/referer">

                               <img style="width:88px;

                                               height:31px;

                                               position:fixed;

                                               bottom: 45px;

                                               left:50px;

                                               "

                                       src="http://jigsaw.w3.org/css-validator/images/vcss"

                                               alt="Valid CSS!" />

                                </a>

                </p></td>
       
</tr>
</table>
</body>
</html>


how do i turn this into php page and what goes in the header and footer?