PHP - How To Open Link In New Tab In Php?

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

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!

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

I am new to website development. I can't figure out how to open a new tab for the following javasript. I went through related questions but nothing worked for me. I want the browser to open a new tab when someone clicks on the link (example.com) below. The code target="_blank doesn't work here... What code should I add and where should I place that code?  

Hi i have been working on a cow management program PHP based.
it works beautifull but now i'm stuck , and i hope i post it in the right forum.
On demand php has to generate an export.txt file with basic cow information (tag#, transponder#, Bdate)
this will be read by the parlour computer an Eprom based computer serial connected.

I finished the script and it creates a beautifull TXt file exxept it's php
http://localhost/tmp/test.php

if i open that URL in notepad, it prints the txt file:
Quote

DH9900010090000624000900002080
VH990001 Dairy Comp 305         20100203
DN99000200312008080003000020800030000303000300035 08000300357080003001940800030003308000300036020
VN99000200001034000014010052009112620100922201102 042001111706
VN99000200001061000009420032010032820100906????????2007120101
VN99000200001083000067850032010061720100927????????2002030706
VN99000200001104000055440052009062720100817201101 032002080605
VN99000200001116000078540042010083120110207????????2002082205
VN990002000011470000816800220101226????????????????2003010806
VN99000200001153000070120032010030420100906????????2003020305



but when i enter that URL in the sync.BAT nothing happends..

my question is, doe anyone know if there is a way to fool DOS for accepting a PHP url?.
OR is there a way for Apache to treat one TXT file as an PHP file?


my script:

Code: [Select]
<?php

//request sql cow info

$db_host = 'localhost';
$db_user = '';
$db_pwd = '';
$database = 'cowdbase';
$table = 'cows';


if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// sending query
$result = mysql_query("SELECT * FROM {$table}");
if (!$result) {
    die("Query to show fields from table failed");
}

//quiery alle info
$query="SELECT * FROM {$table}";
$result=mysql_query($query);

// hoeveel rijen zijn er?
$num=mysql_numrows($result);


//Type the header from the text file


echo "DH9900010090000624000900002080" . PHP_EOL ;
echo "VH990001 Dairy Comp 305         20100203" . PHP_EOL ;
echo "DN9900020031200808000300002080003000030300030003508000300357080003001940800030003308000300036020" . PHP_EOL ;



mysql_close();
$i=0;
while ($i < $num) {

$cowtag=mysql_result($result,$i,"cowTag");
$bdate=mysql_result($result,$i,"Bdate");
$group=mysql_result($result,$i,"group");
$alpro=mysql_result($result,$i,"Alpro_trans");


// LIST ALLE KOEIEN KOE VOOR KOE
///   unknown     cowtag     unknown-0000      #### Alpro tag     00   Group     20    Fresh dateyymmdd  20  Heatdate yymmdd, Drydate YYYYMMDD, Birthdate YYYYMMDD  Lactation number ##
echo "VN9900020000" . str_pad($cowtag, 4, "0", STR_PAD_LEFT) . "0000" . str_pad($alpro, 4, "0", STR_PAD_LEFT) . "00" . "$group" . "20" . "0000" . "????????????????" . "00000000" . "01" . PHP_EOL ;
$i++;
}
echo "EN" . PHP_EOL ;
echo "ZN" . PHP_EOL ;
?>

It might be a funny question, but I hope the pro can help me.

I want to use ?id= to display the other page/url instead of showing the full address due to certain reasons.

What do I mean is like there are 2 different static page e.g. main.php and subpage.php

I would like to use id to display as the url for subpage.php  i.e. main.php?id=1 actually is displaying subpage.php

Any idea?? Help!! Thanks!

Hi,

I need to open an RTF File on client side. When user submit form, the system will write some data in database and at the end, it has to open an rtf file in order to user be able to print it. Any ideas?

Thanks

Hugo

Hi there again all
I am making a site that has a popout music player. My question is since the player is opened by javascript is there a way to let the original page know that the popout is open?

I had some errors in my script but I solved the most of them except two:

Warning: require_once(/home/a3443899/smarty/libs/Smarty.class.php) [function.require-once]: failed to open stream: No such file or directory in /home/a3443899/public_html/include/config.php on line 32

Fatal error: require_once() [function.require]: Failed opening required '/home/a3443899/smarty/libs/Smarty.class.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/a3443899/public_html/include/config.php on line 32

And I checked the map what he couldn't open the map names are just good

Here is the config.php script:
Code: [Select]
<?
$config = array();

// Begin Configuration
// This Template was Downloaded From GrabTemplates.com
$config['basedir']     =  'something';
$config['baseurl']     =  'something';

$DBTYPE = 'mysql';
$DBHOST = 'my host';
$DBUSER = 'my username';
$DBPASSWORD = 'my pass';
$DBNAME = 'my dbname';
// End Configuration

ini_set('session.save_path', $config['basedir']. '/temporary/sessions');
session_start;

$config['adminurl']      =  $config[baseurl].'/administrator';
$config['cssurl']      =  $config[baseurl].'/css';
$config['imagedir']      =  $config[basedir].'/images';
$config['imageurl']      =  $config[baseurl].'/images';
$config['picdir']      =  $config[basedir].'/pics';
$config['picurl']      =  $config[baseurl].'/pics';
$config['tpicdir']      =  $config[basedir].'/pics/thumbs';
$config['tpicurl']      =  $config[baseurl].'/pics/thumbs';
$config['membersprofilepicdir']      =  $config[imagedir].'/membersprofilepic';
$config['membersprofilepicurl']      =  $config[imageurl].'/membersprofilepic';
$config['mbgdir']      =  $config[imagedir].'/mbg';
$config['mbgurl']      =  $config[imageurl].'/mbg';

require_once($config[basedir].'/smarty/libs/Smarty.class.php');
require_once($config[basedir].'/libraries/mysmarty.class.php');
require_once($config[basedir].'/libraries/SConfig.php');
require_once($config[basedir].'/libraries/SError.php');
require_once($config[basedir].'/libraries/adodb/adodb.inc.php');
require_once($config[basedir].'/libraries/phpmailer/class.phpmailer.php');
require_once($config[basedir].'/libraries/SEmail.php');

function strip_mq_gpc($arg)
{
  if (get_magic_quotes_gpc())
  {
  $arg = str_replace('"',"'",$arg);
  $arg = stripslashes($arg);
    return $arg;
  }
  else
  {
    $arg = str_replace('"',"'",$arg);
    return $arg;
  }
}

$conn = &ADONewConnection($DBTYPE);
$conn->PConnect($DBHOST, $DBUSER, $DBPASSWORD, $DBNAME);
@mysql_query("SET NAMES 'UTF8'");
$sql = "SELECT * from config";
$rsc = $conn->Execute($sql);

if($rsc){while(!$rsc->EOF)
{
$field = $rsc->fields['setting'];
$config[$field] = $rsc->fields['value'];
STemplate::assign($field, strip_mq_gpc($config[$field]));
@$rsc->MoveNext();
}}

if ($_REQUEST['language'] != "")
{
if ($_REQUEST['language'] == "english")
{
SESSION_REGISTER("language");
$_SESSION[language] = "english";
}
elseif ($_REQUEST['language'] == "spanish")
{
SESSION_REGISTER("language");
$_SESSION[language] = "spanish";
}
elseif ($_REQUEST['language'] == "french")
{
SESSION_REGISTER("language");
$_SESSION[language] = "french";
}
}

if ($_SESSION['language'] == "")
{
SESSION_REGISTER("language");
$_SESSION[language] = "english";
}

if ($_SESSION['language'] == "english")
{
include("lang/english.php");
}
elseif ($_SESSION['language'] == "spanish")
{
include("lang/spanish.php");
}
elseif ($_SESSION['language'] == "french")
{
include("lang/french.php");
}
else
{
include("lang/english.php");
}

for ($i=0; $i<count($lang)+1; $i++)
{
STemplate::assign('lang'.$i, $lang[$i]);
}

STemplate::assign('baseurl',       $config['baseurl']);
STemplate::assign('basedir',       $config['basedir']);
STemplate::assign('adminurl',       $config['adminurl']);
STemplate::assign('cssurl',       $config['cssurl']);
STemplate::assign('imagedir',        $config['imagedir']);
STemplate::assign('imageurl',        $config['imageurl']);
STemplate::assign('picdir',        $config['picdir']);
STemplate::assign('picurl',        $config['picurl']);
STemplate::assign('tpicdir',        $config['tpicdir']);
STemplate::assign('tpicurl',        $config['tpicurl']);
STemplate::assign('membersprofilepicdir',        $config['membersprofilepicdir']);
STemplate::assign('membersprofilepicurl',        $config['membersprofilepicurl']);
STemplate::assign('mbgdir',        $config['mbgdir']);
STemplate::assign('mbgurl',        $config['mbgurl']);
STemplate::setCompileDir($config['basedir']."/temporary");
STemplate::setTplDir($config['basedir']."/themes");

?>

Hi

I am trying to get the structure of some folders/files on my server to create an xml "Feed" which then goes to a flash file. 

I keep getting the error message that I can't open the folder (it is set to 755)
ERROR: Could not open folder: http://www.name/templates/bluezoo/mp3s

What am I doing wrong please.

Many thanks in advance

Edward

Here's some php:
Code: [Select]
$directoryLocation="http://www.name/templates/bluezoo/mp3s";

// XML Doctype
$xml = new DomDocument('1.0', 'UTF-8');
$xml->xmlStandalone = false;
// XML Root element
$root = $xml->createElement('mp3s');
$root = $xml->appendChild($root);

// Grab a list of folders from the specified directory
if ($dir = @opendir($directoryLocation)) {
    while (false !== ($file = readdir($dir))) {
        if (is_dir($directoryLocation . DIRECTORY_SEPARATOR . $file) && $file != '.' && $file != '..') {
            // If it is a folder, put it in the folders array
            $folders[] = $file;
        }
    }

I would like to open a new IE window. But, failed to do that. Is there any wrong with my statements?

Code: [Select]
<?php
$url='http://www.google.com';
$browser = new COM("InternetExplorer.Application");
$browser->Visible = true;
$browser->Navigate($url);
?>

Can anyone help me with this pls?

Thank you.

Regards,
juzz