PHP - Create Id In <a> Link With An If Statement ?

Hi,

Just looking how to create a link to download a file located on the server, it will be files like .doc etc.

Cant seem to find anything on the net so i think i need php but may be html.

Can anyone point me in the right direction?

Thanks

p.s. it will be used for more than one file so im looking for a small ish amount of code.

Hello All   From the begin i have the following code.

<?php
$sql = "SELECT id,phonemodel FROM iphone";
$rows = $conn->sqlExec($sql);

$nr_row = $conn->num_rows;
$meniu ='<ul>';
if($nr_row>=0) {
  foreach($rows as $row) {
     $meniu .= '<li><a href="iphone.php?id='.$row['id'].'">'.$row['phonemodel'].'</a></li>';
	 }
  }
  $meniu .= '</ul>';
  
  echo $meniu;
	 
	 if(isset($_GET['id'])) {
	    $id =  (int)$_GET['id'];
		$sql = "SELECT * FROM iphone WHERE  id = $id";
$rows = $conn->sqlExec($sql);

$nr_rows = $conn->num_rows;
if($nr_rows>0) {
  foreach($rows as $row){
   echo 'Name Tel: '.$row["phonemodel"].' Title : '.$row["titlereparation"].' 
   Pret : '.$row["price"].' Message : '.$row["msj"].' ID : '.$row["id"].'<br />';
   }
  }
  else {
  echo '0 Results';
  }
}
?> 

Basicaly i have a website for phone repairs.And i want to create in iphone.php a menu from DB and when i acces the menu with _GET variable, when i press Iphone 5s (iphone.php?id=id page) the code have to display to me,all reparations for iphone 5s. Until now,i succssed to create the Menu but the code keep add same line in the menu when i add for example a second reparation for 5s.And i don't know how to select all reparation for 5s and display them in a single link like above Iphone 5s (iphone.php?id=id page). Now the script working like this.Create a menu with all phone names. Iphone 5s Iphone 3 Iphone 3s Iphone 4 Iphone 5s Iphone 5s Shoud be like Iphone 5s Iphone 3 Iphone 3s Iphone 4 Other new devices.. And display the reparation in every link from list By ID.i try it to select by phone names,not working. Any body with any ideea please? Thx so much

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>";

?>

I know with a submit button I can have a new record created when clicking it, but is it possible to do with a text link?

  Hello and looking for some help please..

I have already read this : http://www.phpfreaks.com/forums/index.php?topic=120619.0

  What I am after to do, is to after a successful Paypal payment from paypal, generate a link in a wordpress site (or external even) that will expire after 3 days to a video.

  I hope that makes sense please?

Thanks in advance,

Jim

Hi guys.. 1st post here.  I'm pretty new to php.. just a few weeks in.  I've gotten pretty decent at making mysql connections and extracting data, but now I'm wanting to take one of my urls that I echo to my page and create a new page.  Hoping someone can help...  Here's the pictu

MY MySQL Setup:
I have 1 table called table1. It has 2 columns which a 'Title' & 'Description'

My Index.php Page:
I connect to mysql. I pull the 'Title' from MySQL and loop it to produce 100 rows of data that fill my index page, as expected.

My Problem:
I now want to be able to click one of those rows and dynamically create a new page (description.php) that includes the 'Title' & 'Description'.

My Progress:
I've managed to click a row and create a hyperlink to mysite.com/$title (where 'title' is pulling the 'title' from the mysql db) but I all I get is page not found.

My Question:
How do I tell description.php to pull the 'Title' and 'Description' and link to it from index.php?

My Gratitude:
Thanks in advance!

I was wondering if there was any way in which I could create a link which would direct to a paypal payment page and the amount to be paid could be specifed in the URL (GET method) as I have multiple products at differnt prices and would like to redirect the user to a page with a price I specify to be paid.
 
Anyone have ideas?
 
Hope someone can respond soon - thanks in advance for any help!
 
Jake

I'm having issues with the following:

Code: [Select]
<?php
session_start();
$_SESSION['username']=$_POST['username'];
$_SESSION['password']=$_POST['password'];
if($_SESSION['username']=="username" && $_SESSION['password']=="password"){
if($_GET['product']=="add"){
$content.='
<p><label>Product Name:</label> <input type="text" name="product_name" size="30" />
<label>Product Price:</label> <input type="text" name="product_price" size="5" />
</p>
<p><label>Product Category:</label> <input type="text" name="product_category" size="30" /></p>
<p><label>Product Link:</label> <input type="text" name="product_link" size="30" /></p>
<p><label>Product Image:</label> <input type="text" name="product_image" size="30" /></p>
<p><label>Product Tag:</label> <input type="text" name="product_tag" size="30" /></p>
<p><label>Product Keywords:</label> <input type="text" name="keyword" size="30" /></p>
<p><label>Product Features:</label><br />
<textarea name="product_features" rows="10" cols="60"></textarea>
</p>
<p><label>Product Pros:</label><br />
<textarea name="product_pros" rows="5" cols="30"></textarea>
</p>
<p><label>Product Cons:</label><br />
<textarea name="product_cons" rows="5" cols="30"></textarea>
</p>
<p><label>Product Description:</label><br />
<textarea name="product_description" rows="10" cols="60"></textarea>
</p>
<p><label>Product Notes:</label><br />
<textarea name="product_notes" rows="5" cols="30"></textarea>
</p>
';
$logout='<div><a href="./acp_admincp.php?log-out">Log-Out</a></div>';
}
elseif($_GET['product']=="view"){
}
else{
$content.='
<a href="./admincp.php?product=add">Add New Product</a>
<br />
<a href="./admincp.php?product=view">View Products</a>
';
}
}
elseif(isset($_GET['log-out'])){
session_start();
session_unset();
session_destroy();
header("Location: ./admincp.php");
}
else{
$content='
<form action="./admincp.php" method="post">
<p><label>Username:</label> <input type="text" name="username" size="30" />';
$content.='</p>
<p><label>Password:</label> <input type="password" name="password" /></p>';
$content.='<p><input type="submit" value="Submit" name="Submit" /></p>
</form>';
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<base href="http://ghosthuntersportal.com/" />
<title>Ghost Hunter's Portal - Admin Control Panel</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="verify-v1" content="" />
<meta name="keywords" content="ghost, hunters, hunter, ghosts, spirit, spirits, paranormal, investigation, investigator, investigators, k2, emf, meter, kii" />
<meta name="description" content="Ghost Hunters Potal. Parnormal research equipment store." />
<meta name="author" content="Andrew McCarrick" />
<meta name="robots" content="index, follow"
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<img src="./logo.png" alt="Ghost Hunter's Portal Admin Control Panel" />
<br />
<div style="color: #AA44AA; font-size: 26px; margin-top: -30px; margin-left: 125px;">Admin Control Panel</div>
<?php
echo $logout;
echo $content;
?>
</body>
</html>

I can log-in, and get to the page with the two links on it. However, once I click one of the links it falls back to the log-in page, and it ends up being a never ending loop.

It's doing this:
Log-In --> Page with links ---> Log-In page again

Should be doing this:
Log-In --> Page with links --> Add Product page or View Products page

I can never get into the the actual sub page.

Just to be clear, the address bar actually shows product=add or product=view, but it still shows the log-in page.

Hello Everyone,
I have to change the if statements to a switch statement, in this game. Can anyone help? Thanks.

var checkKeyPressed = function (e) {
// Press key A or key D to make dog run to the left or right
// The running speed is specified by the step variable, 10 by default.
// If you replace 10 with a larger integer, the dog will run faster.

    //press A, dog runs left
    if (e.keyCode == "65") {
        if (prex[0] > 5) {
            prex[0] = prex[0] - step;
        }
    }
    //press D, dog runs right
    if (e.keyCode == "68") {
        if (prex[0] < right) {
            prex[0] = prex[0] + step;
        }
    }
};

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

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";
?>

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?

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!