PHP - Link Table

In this output table, I would like to be able to click on any number in the ama row, add .html to that value and then execute the link.

Example: If the ama number in row 3 is 890543, add .html to the number = 890543.html, then click on it to link to that web page.


<?php // Connect to database =========================================

include("connect_db.php");
$table1='passwords';
$table2='airplanes';

// send query ===================================================

$result = mysql_query("SELECT * FROM $table2") or die(mysql_error());  

if (!$result) {
    die("Query to show fields from table failed");
}

echo "<table border='10' cellpadding='3' cellspacing='2'>";
echo "<p>View All Airplanes</p>";

echo "<tr> <th>ID</th> <th>AMA #</th> <th>Model Name</th> <th>Model MFG</th><th>Wingspan</th><th>Engine</th><th>Decibels</th></tr>";

// keeps getting the next row until there are no more to get ================

while($row = mysql_fetch_array( $result )) {

// Print out the contents of each row into a table ==========================

echo "<tr><td>";

echo $row['id'];

echo "</td><td>"; 

echo $row['ama']; // Append .html to this number

echo "</td><td>"; 

echo $row['model_name'];

echo "</td><td>"; 

echo $row['model_mfg'];

echo "</td><td>"; 

echo $row['wingspan'];

echo "</td><td>"; 

echo $row['engine'];

echo "</td><td>"; 

echo $row['decibels'];

echo "</td></tr>"; 
} 

echo "</table>";

?>

Hi

I've got this database I created with fields

ProductId   ProductName  Image

I've managed to get it to list the ID,productname, and Image urls
in a list.

My next step is to have the image field actually display
an image and make it clickable:

heres what I've done so far:

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

mysql_select_db("productfeed", $con);

$result = mysql_query("SELECT * FROM productfeeds");

echo 
"<table border='0'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>Image</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['ProductID'] . "</td>";
  echo "<td>" . $row['ProductName'] . "</td>";
  echo "<td>" . $row['ImageURL'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
Heres what I want to do:

Code: [Select]
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['ProductID'] . "</td>";
  echo "<td>" . $row['ProductName'] . "</td>";

 // my changes beneath
  echo "<td>" . <a href="<?php echo $row['ImageURL'];?>"> <img src="<?php echo $row['LinkURL']; ?>"> </a>. "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
Can you guys point me in the right direction?

Many thanks

Hello. I have a bit of a problem. When I fetch the link field from the database.i don't see an actual link on the page.  One more thing, what type of field should I use to store the link in the database? Probably there is where I went wrong. All help is 

Hi Support,

I have a form, where it collects user description input. I can collect the inputs and store it with newline. The issue is - how to collect the http link to actual hyperlink ref during display.  The following is my code:

<textarea name="description" cols="50" rows="10" id="description"><?php echo str_replace("<br>", "\n", $description);?></textarea></td>

For example, User input:

Hi, Check it out - http://www.google.com/

I would like to display google link as href so that Viewers can click the link and go to the page. Right now, it is not href and user need to copy the link to new tabs or pages and then it can come.

Thanks for your help.
Regards,
Ahsan

here's my code that i've used to send an email.

Code: [Select]
$link = "<a href=\"http://www.example.com/" . $num . "\">" . $num . "</a>";

$query = "SELECT content FROM emails";
$result = mysql_query($query) or die();
$email_content = mysql_result($result, 0);
$email = sprintf($email_content, $first, $name, $from, $link, $record, $rec, $inc, $max);
$email_body = stripslashes(htmlentities($email, ENT_QUOTES, 'UTF-8'));

// this is sent to another php script via post....

$subject = $_POST['subject'];
$message = nl2br(html_entity_decode($_POST['email_body']));
$to = "me@whatever.com";
$charset='UTF-8';
$encoded_subject="=?$charset?B?" . base64_encode($subject) . "?=\n";
$headers="From: " . $userEmail . "\n"
. "Content-Type: text/html; charset=$charset; format=flowed\n"
. "MIME-Version: 1.0\n"
. "Content-Transfer-Encoding: 8bit\n"
. "X-Mailer: PHP\n";
mail($to,$encoded_subject,$message,$headers);
   

in the db, emails.content is of the text type and contains several lines of text with %4$s which inserts the value of $link into the body.  when the email arrives, there is a link and it appears fine, with the value of $num hyperlinked.  however when you click on it it doesn't go anywhere.  when copying the link location from the email it gives me

x-msg://87/%22http://www.example.com/16

what is x-msg?  how can i get this to work properly?

hi hope you all are fine.

i have been working on a Email Form (like user fills up the form which send the information to our email)
but i was having problem with (URL field i created)

link of form is (http://services.shadowaura.com/allquotations/static.php)
field which is not working is "Inspirational Website:"

when i submit the form it says (Forbidden

You don't have permission to access /allquotations/staticworking.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.)

Can some one help me out ?????????????

code behind this form is:

Code: [Select]
<?php

/* Email Variables */

$emailSubject = 'Shadow Aura Contact Info!';
$webMaster = '*****@shadowaura.com';


/* Data Variables */

$Name = $_POST['Name'];
$email = $_POST['email'];
$Cell = $_POST['Cell'];
$Phone = $_POST['Phone'];
$CompanyName = $_POST['CompanyName'];
$TypeOfBusiness = $_POST['TypeOfBusiness'];
$Address = $_POST['Address'];
$YourBudget = $_POST['YourBudget'];
$HaveDomain = $_POST['HaveDomain'];
$RunningWeb = $_POST['RunningWeb'];
$WebLink = $_POST['WebLink'];
$Inspiration1 = $_POST['Inspiration1'];
$Inspiration2 = $_POST['Inspiration2'];
$NumberPages = $_POST['NumberPages'];
$UseFlash = $_POST['UseFlash'];
$TimeFrame = $_POST['TimeFrame'];
$Provided = $_POST['Provided'];
$Comments = $_POST['Comments'];


$body = <<<EOD

<h1> Static Website Quotation </h1> <br>
<b>Name of Client:</b>$Name<br>
<b>Your Email:</b>$email<br>
<b>Cell Number:</b>$Cell<br>
<b>Line Phone Number:</b>$Phone<br>
<b>Company Name:</b>$CompanyName<br>
<b>Type of Business:</b>$TypeOfBusiness<br>
<b>Address:</b>$Address<br>
<b>Your Budget:</b>$YourBudget <br>
<b>Do you have Domain:</b>$HaveDomain<br>
<b>Your Site is Running:</b>$RunningWeb <br>
<b>Website Link:</b><a href="$WebLink">$WebLink</a><br>
<b>Inspiration:</b>$Inspiration1<br>
<b>2nd Inspiration:</b>$Inspiration2<br>
<b>Number of Pages:</b>$NumberPages<br>
<b>Use Flash:</b>$UseFlash <br>
<b>Time Frame:</b>$TimeFrame<br>
<b>You will provide:</b>$Provided<br>
<b>Comments:</b>$Comments<br>



EOD;

$headers = "From: $email\r\n";
$headers .= "Content-type: text/html\r\n";
$success = mail($webMaster, $emailSubject, $body,
$headers);


/* Results rendered as HTML */

$theResults = <<<EOD
<html>
<head>
<title>sent message</title>
<meta http-equiv="refresh" content="3;URL=http://services.shadowaura.com/">
<style type="text/css">
<!--
body {
background-color: #8CC640;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 20px;
font-style: normal;
line-height: normal;
font-weight: normal;
color: #fec001;
text-decoration: none;
padding-top: 200px;
margin-left: 150px;
width: 800px;
}

-->
</style>
</head>
<div align="center">Your email will be answered soon as possible!
You will return to <b>Shadow Aura Services</b> in a few seconds !</div>
</div>
</body>
</html>
EOD;
echo "$theResults";
?>

I have a line like this it prints text link but I prefer image link how should i edit it I would appreciate some feedback
Code: [Select]
$templates['etiket'] = array('name' => t('ETİKET'), 'module' => 'uc_invoice_pdf', 'path' => $templates_uc_invoice_pdf_path, 'pdf_settings' => $pdf_settings);

Hi guys,

I'm using a twitter script that grabs the title and publishings it like so:

"Title - Read More at..."

I was wondering how i would be able to post the direct link into twitter.. like news.php?id=1 for example.

Code: [Select]
$tweet->post('statuses/update', array('status' => ''.$_POST[title].' - more at MY URL'));

This part is in the script to publish automatically when the users adds to the news database.

How am i able to get the ID just after the posting of the news?

Thanks!

Hi All, I want to copy into a table values from another table that partially match a given value, case-insensitively. So far I do as follows but I wonder whether there is a quicker way.

$input_table=array('1'=>'toto','2'=>'tota','3'=>'hello','4'=>'TOTO','5'=>'toto');
$input_table_2 = array_map('strtolower', $input_table);
$value_to_look_for='Tot';
$value_to_look_for_2=strtolower($value_to_look_for);
$output_table=array();
foreach ($input_table_2 as $k=>$v)
  {
  if(false !== strpos($v, $value_to_look_for_2))
    {
    $output_table[]=$input_table[$k];
    }
}

One drawback is that $input_table_2 is 'foreached' whereas there might be no occurrences, which would lead to a loss of time/resources for big arrays.   Thanks.

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?



Thanks in advance,
Vero

hi...

i have a table ...

i add and remove data in the table...when i add new record , information add to center of the table ! whats problem?   i want add data in first of table.   please guide me.thanks

 

 

Hi I am very new to PHP & Mysql. I am trying to insert values into two tables at the same time. One table will insert a single row and the other table will insert multiple records based on user insertion. Everything is working well, but in my second table, 1st Table ID simply insert one time and rest of the values are inserting from 2nd table itself. Now I want to insert the first table's ID Field value (auto-incrementing) to a specific column in the second table (only all last inserted rows).   Ripon.   Below is my Code:

<?php



$con = mysql_connect("localhost","root","aaa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("ccc", $con);


$PI_No = $_POST['PI_No'];
$PO_No = $_POST['PO_No'];


$qry = "INSERT INTO wm_order_entry (
Order_No,
PI_No,
PO_No) 


VALUES(
NULL,
  '$PI_No',
 '$PO_No')";
$result = @mysql_query($qry);




$val1=$_POST['Size'];
$val2=$_POST['Style'];
$val3=$_POST['Colour'];
$val4=$_POST['Season_Code'];
$val5=$_POST['Dept'];
$val6=$_POST['Sub_Item'];
$val7=$_POST['Item_Desc'];
$val8=$_POST['UPC'];
$val9=$_POST['Qty'];
$N = count($val1);
for($i=0; $i < $N; $i++)
{


$profile_query = "INSERT INTO order_entry(Size,
Style,
Colour,
Season_Code,
Dept,
Sub_Item,
Item_Desc,
UPC,
Qty,
Order_No
) VALUES( '$val1[$i]','$val2[$i]','$val3[$i]','$val4[$i]','$val5[$i]','$val6[$i]','$val7[$i]','$val8[$i]','$val9[$i]',LAST_INSERT_ID())";
$t_query=mysql_query($profile_query);
}
header("location: WMView.php");
mysql_close($con);
?>

Output is attached.

Hi All ,   I have a small table with 4 fields namely Day_ID, Dues, Last_Visit, Points. where Day_ID is an auto-increment field. The table would be as follows:   Day_ID -- Dues ---  Last_Visit ---  Points. 1  --------- 900 -------- 1/12  --------   6      2  --------- 700 -------- 4/12  --------   7 3  --------- 600 -------- 7/12  --------   5 4  --------- 600 -------- 9/12  --------   6 5  --------- 600 -------- 10/12 -------   6 6  --------- 600 -------- 14/12 -------   6   So this is the record of a person's visit to say a club. The last row indicates the last date of his visit to the club. His points on this date are 6. Based on this point value of 6 in the last row I want to retrieve all the previous BUT adjoining all records that have the same Points i.e. 6.    So my query should retrieve for me, based on the column value of Points of the last row (i.e. Day_ID - 6 ), as follows:   4  --------- 600 -------- 9/12  --------   6 5  --------- 600 -------- 10/12 -------   6 6  --------- 600 -------- 14/12 -------   6   This problem stated above had been completely resolved, thanks to a lot of help from Guru Barand by this following query :-

$query = "SELECT cv.day_id, cv.dues, cv.last_visit, cv.points
FROM clubvisit cv
WHERE last_visit >=
(
SELECT MAX(last_visit) FROM clubvisit
WHERE points <>
(
SELECT points as lastpoints
FROM clubvisit
JOIN
(
SELECT MAX(last_visit) as last_visit
FROM clubvisit
) as latest USING (last_visit)
)
)";

I am using this and it works perfectly except that now there is a slight change in the table because the criteria for points is now dependent on more than one column cv.points and is more like cv.points1, cv.points2, cv.points3 etc. So now I need to make a selection based on each of these cv.points columns.   As of now I can still get the results by running the query multiple times for each of the cv.points columns ( seperately for cv.points1, cv.points2, cv.points3) and it works correctly. However I am wondering if there is a better way to do this in just one go. This not only makes the code repetitive but also since the queries are interconnected, involves the use of transactions which I wish to avoid if possible.    The values that I require for each of the cv.point columns is  1. day_id of the previous / old day on which the cv.points value changed from the current day value, and  2. cv.points on that old/ previous day.    So for  example if the table is as below:   Day_ID -- Dues ---  Last_Visit ---  Points1 --- Points2. 1  --------- 900 -------- 1/12  -----------   9  ------------ 5    2  --------- 600 -------- 4/12  -----------   6  ------------ 6 3  --------- 400 -------- 7/12  -----------   4  ------------ 7 4  --------- 500 -------- 9/12  -----------   5  ------------ 8 5  --------- 600 -------- 10/12 ----------   6  ------------ 8 6  --------- 600 -------- 11/12 ----------   6  ------------ 8 7  --------- 600 -------- 13/12 ----------   6  ------------ 7 8  --------- 500 -------- 15/12 ----------   5  ------------ 7 9  --------- 500 -------- 19/12 ----------   5  ------------ 7   Then I need the following set of values : 1. day_id1 -- Day 7,      points1 ---- 6,          days_diff1 -- (9-7 = 2)  . // Difference between the latest day and day_id1 2. day_id2 -- Day 6,      points2 ---- 8,          days_diff2  -- (9-6 = 3) 3. day_id3 -- ....   and so on for other points.    Thanks all !

Hello everyone.

I need help with the following PHP APP. I am running on (Version PHP 7.2.10) I am trying to have a page table form on table.php pass the input variable of “5-Numbers” to another page called table_results.php

I want that variable string of “5-Numbers” to be compared against 4 arrays and output any duplicates found within each of those 4 lists. If nothing is found, I still want some visual output that reads “None found”.

 

Lets pretend I have the following example ..

On table.php, I typed inside my table form the 5-Numbers ..

INPUT:  2,15,37,13,28

On table_results.php, the 4 arrays to be compared against my input numbers “ 2,15,37,13,28” are ..

 

$array_A = array(2,6,8,11,14,18,24); 

$array_B = array(1,2,9,10,13,14,25,28,);  

$array_C = array(1,3,7,9,13,15,20,21,24); 

$array_D = array(4,5,12,22,23,27,28,29); 

 

So my output should read as follows below ..

OUTPUT: 

 

TABLE

COLUMN 1   COLUMN 2

ROW 1 Matches Found Results ..

ROW 2 GROUP A:            2 

ROW 3 GROUP B:             2,13,28

ROW 4 GROUP ?            13,15

ROW 5 GROUP ?            28

ROW 6 5#s Input:              2,15,37,13,28

 

Please let me know if anyone has any suggestions on how to go about it. 

Thanks.

Edited January 1, 2019 by Jayfromsandiego
Wanted to include image example

I know I'm doing it something right, but can someone tell me why only one table is showing up? Can you help me fix the issue?

Heres my code:


function showcoords()
{
echo"J3st3r's CoordVision";
$result=dbquery("SELECT alliance, region, coordx, coordy FROM ".DB_COORDFUSION."");
dbarray($result);
$fields_num = mysql_num_fields($result);

echo "<table border='1'>";
// printing table headers


    echo "<td>Alliance</td>";
    echo "<td>Region</td>";
    echo "<td>Coord</td>";


// printing table rows
while($row = mysql_fetch_array($result))
{
    

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row AS $Cell)
     echo "<tr>";     
     echo "<td>".$row['alliance']."</td>\n";
     echo "<td>".$row['region']."</td>\n";
     echo "<td>".$row['coordx'].",".$row['coordy']."</td>\n";
     echo "</tr>\n";
    
}
echo "</table>";
mysql_free_result($result);

}



I have 2 rows inserted into my coords table. Just frustrated and ignorant to php.