PHP - Link Share Image And Text

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

Hi, I've read a lot of places that it's not recommended to store binary files in my db.
So instead I'm supposed to upload the image to a directory, and store the link to that directory in database.

First, how would I make a form that uploads the picture to the directory (And what kinda directories are we talking?).

Secondly, how would I retrieve that link? And I guess I should rename the picture..

I'd appreciate any help, or a good tutorial (Haven't found any myself).

I am trying to implement the method described in this post: http://www.addthis.com/forum/viewtopic.php?f=4&t=24637 to get my Addthis button to act the way I need it to. I have posted on the site, but have gotten no response.

I cannot get it to work. Can anybody have a look at the code below and see if they can help? Thanks

The PHP I need to modify is:


<?php     
defined('C5_EXECUTE') or die(_("Access Denied."));
    $html = Loader::helper('html');
    $uh = Loader::helper('concrete/urls');
    $bt = BlockType::getByHandle('news_list');
    global $c;



   $rss_address = $controller->getRssUrl().'?ctID='.$ctID.'&bID='.$bID ;

    if (isset($_GET['pageno'])) {
    $pageno = $_GET['pageno'];
} else {
    $pageno = 1;
} // if
?>

<div class="newsflash1">
  <div class="headtitle1">
<?php echo $rssTitle ?>
  </div>
  <?php    



if (!function_exists('newslistParse')) {

function newslistParse($url,$thumbnail,$thumbwidth,$time,$content,$title,$date){

//###################################################################################//
//here we lay out they way the page looks, html with all our vars fed to it  //
//this is the content that displays.  it is recommended not to edit anything beyond //
//the content parse.  Feel free to structure and re-arrange any element and adjust //
//CSS as desired. //
// available vars:  $url,$thumbnail,$thumbwidth,$time,$content,$title,$date       //
//###################################################################################//

?>
  <div class="newsflashcontain1">
    <div class="title1"><h3><?php echo $title; ?></h3>
    </div>
    <div class="time1"> <?php echo $date; ?></div>
    <div class="description1"><?php echo $content;?></div>
<div class="addthis_toolbox addthis_default_style">
<a class="addthis_button" addthis:title="Title goes here" addthis:description="Check their site!" addthis:url="http://www.davidcunniffe.com/test3/index.php?cID=69" href="http://www.addthis.com/bookmark.php?v=250&amp;username=dcunniffe"/>
    <a class="addthis_button_facebook"></a>
    <a class="addthis_button_twitter"></a>    
    <a class="addthis_button_favorites"></a>
    <a class="addthis_button_email"></a>
    <a class="addthis_button_print"></a>
    <a class="addthis_button_facebook_like"></a>
<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#username=dcunniffe"></script>
</div>
</div>
  <?php

//#####################################################################################//
//this is the end of the recommended content area.  please do not edit below this line //
//#####################################################################################//

}
}


$db = Loader::db();

//go grab the posts, check if they are current, return only current posts
Loader::model('newzy','simplenews');
$news = NewsCheck::getCurrentBlocks($ctID,$ordering);

//count the number of current posts returned
$pcount = count($news);

//if no events are returned, then we display a user defined message
if($pcount==0){
echo $nonelistmsg;
}

//now calc the last page
$lastpage = ceil($pcount/$num);


//set the current page min max keys -1 as array key's start @ 0
$sKey = $num * ($pageno-1) ;
$eKey = ($num * ($pageno-1)) + ($num-1) ;


//take each current post and treat it like a query, for each one do X
foreach($news as $key => $row){

//check for external URL, if none, rout to parent page
if(!empty($row['urlLink'])){
$url = $row['urlLink'];
}else{
$url = $controller->grabURL($row['cParentID']); 
}
//check if thumbnail is there, if so get it, if not, null
if($row['graphic']>0){
$thumbnail = $controller->getThumbnail($row['graphic']);
}else{
$thumbnail = NULL;
}
//set vars
$time = $controller->replaceTimeString($row['nbID']);
$date = date('l, jS F, Y');
$title = $row['title'];
$content = $controller->translateFrom($row['content']);
//$content = $controller->translateFrom($row['content']);
//if truncation is enabled
if($truncateSummaries == 1){
if (strlen($content) >= $truncateChars){
//truncate to suplied truncation value
 //$content = substr($content,0,$truncateChars).'.....';
 $content = wordwrap($content, $truncateChars);
     $content = substr($content, 0, strpos($content, "\n")).'.....';
}
}


//check if paging is enabled
if($isPaged){

//check to make sure the array key is within the range
if($key >= $sKey && $key <= $eKey){
  newslistParse($url,$thumbnail,$thumbwidth,$time,$content,$title,$date);
}

//if paging is not selected, use number of items designated in the list block
}else{

$i += 1;

newslistParse($url,$thumbnail,$thumbwidth,$time,$content,$title,$date);

//once we reach the set number stop the script
if($i >= $num){ break; }

}
}

?>
</div>
<?php    

//is iCal feed option is sellected, show it
if($showfeed==1){
?>
<div class="rssfeed1"> <img src="<?php echo $uh->getBlockTypeAssetsURL($bt, 'rss.png');?>" width="14" height="14" alt="rss feed" />&nbsp;&nbsp; <a href="<?php echo $rss_address ; ?>" id="getFeed">Get Feed</a>
  <link href="<?php echo $controller->getRssUrl();?>" rel="alternate" type="application/rss+xml" title="<?php echo t('RSS');?>" />
</div>
<?php    
}

//$c = Page::getCurrentPage();
$link = Loader::helper('navigation')->getLinkToCollection($c);
$link = $controller->URLfix($link);

//if pagination is set, if it is needed, show it
if($isPaged==1){

if ($pcount > $num) {
echo '<div id="pagination">';

if ($pageno == 1) {
    echo " FIRST PREV ";
} else {
    echo '<a href="'.$link.'pageno=1">FIRST </a>';
    $prevpage = $pageno-1;
    echo '<a href="'.$link.'pageno='.$prevpage.'"> PREV</a>';
} // if

echo ' ( Page '.$pageno.' of '.$lastpage.' ) ';

if ($pageno == $lastpage) {
    echo " NEXT LAST ";
} else {
    $nextpage = $pageno+1;
    echo '<a href="'.$link.'pageno='.$nextpage.'">NEXT </a>';
    echo '<a href="'.$link.' pageno='.$lastpage.'"> LAST</a>';
} // if
echo '</div>';
}
}
if (isset($bID)) { echo '<input type="hidden" name="bID" value="'.$bID.'" />';}
?>

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=349561.0

Can somebody please explain how to properly add a Facebook Share button to my site?   It's not simply a matter of generating the button and pasting the code into my pages; in order to ensure that the right information is shared, I also have to add Open Graph metatags.   But the thing that's confusing me is that one of the required Open Graph metatags is this:

<meta property="fb:app_id" content="APP_ID_NUMBER" />

Questions   1) Does this mean that I have to register as an app builder before I can add the Share button? If so, why doesn't Facebook say so on the Share button page?   2) When generating the Share button, I am asked for the "URL to share". Does this mean that I have to generate a different Share button for each page? Surely not.   3) I use ShareThis at the moment. Does ShareThis work with Facebook Insights?

I have placed the Facebook LIKE/SHARE buttons on a website using the following:

<div class="fb-like" data-href="http://mysite.com" data-layout="standard" data-action="like" data-show-faces="false" data-share="true" data-width="280px"></div>

the LIKE button works fine.  the SHARE button works but i cannot seem to customize and of the values such as which image to include.  i have the following in my HEAD section but it does nothing.  do i need to create an APP and reference the ID?  any help is much appreciated

<meta property="og:type" content="website" />
    <meta property="og:title" content="Can tea make for a happy marriage" />
    <meta property="og:url" content="http://mysite.com/index.php" />
    <meta property="og:image" content="http://mysite.com/pics/gallery/2.jpg" />

Edited by BuildMyWeb, 28 September 2014 - 05:18 PM.

Hi,   I've added social sharing icons to every article on the homepage. Now they just share the page itself - the idea is to share that (wordpress) post/article. I've succeeded to do so with facebook likes on the English version with adding 

<div class="fb-like" data-href="<?php the_permalink(); ?>"

Now I want to do the same with these 3 share icons:

<div class="social-content"><?php if (ICL_LANGUAGE_CODE=='zh-hans'): ?><div class="bshare-custom"><div class="bsPromo bsPromo2"></div><a title="分享到微信" class="bshare-weixin" href="javascript:void(0);"></a><a title="分享到新浪微博" class="bshare-sinaminiblog" href="javascript:void(0);"></a><a title="分享到QQ空间" class="bshare-qzone"></a><a title="更多平台" class="bshare-more bshare-more-icon more-style-addthis"></a><span class="BSHARE_COUNT bshare-share-count" style="float: none;">19.5K</span></div><?php endif; ?></div>

Can this be done by adding PHP? I'm not sure where I would have to add this...   Thanks Attached Files  csr1.jpg   38.34KB   0 downloads

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=347238.0

Dear Friends,

I have 3 different Applications under the same server.
http://myserver/App1, http://myserver/App2 and http://myserver/App3

Please, could you help me to share info between them?

App1 is a "User Admin Application". Here the user should do the login. After the login, the User should be able to open App2 or/and App3
I have tried with SESSION and COOKIES. As I am under the same server, I think, I am doing something wrong. Or SESSION and/or COOKIES doesn't will work?

Thank you.

My setup: (everything on a local network)
Web server: Ubuntu Server 8.10 -- Workgroup
File server: Windows Server 2008 x64 -- domain
Test server: Win 2000 running WAMP -- domain

I'm trying to run the code snippet below. $file is a file on the File server above. It definitely exists.
Running the code below on the Test server works perfectly. But the file cannot be found when running from the Web server.
$file = '//server/share/file.txt';
if (file_exists($file))
echo 'yay!';
else
echo 'error';

What with the safe mode considerations, I've also tried to add:
ini_set('safe_mode', 'Off'); to no effect. And since file, and fopen similarly not work, I'm pretty sure it's not that either.

The File & Test servers are on the same Windows domain, but that's definitely not the reason. I tried the code on a file on a Linux computer in the Workgroup (where the Web server is) with the same results: Test server works, Web server does not.

Please advise; I'm really lost.

I need to know if this is even possible.  I have found conflicting information on this online. 

Anyway, here is what I want to do.  I have two websites that reside on the same dedicated server.  Both have different IP's.  www.mywebsite1.com and www.mywebsite2.com. 

I need a user that logs in at www.mywebsite1.com to be able to pass the $_SESSION from www.mywebsite1.com to www.mywebsite2.com.  Any help on this would be cool.  Thanks in advance.

Ryan

Is there a way to add an HTML link in a Text E-mail that was generated by PHP?

I am trying to create an e-mail that looks like this...

Quote

Dear Member,

Your password was re-set, and the following Temporary Password has been assigned:

Use this temporary password to Log In.




Debbie

change link text
Code: [Select]
<?php 
require 'connect.php';
?>
<html>
<head><title>Admin</title>
<link rel="stylesheet" type="text/css" href="tab_style.css">
<script type="text/javascript">

function getXMLHTTP() {
var xmlhttp=false;
try{
xmlhttp=new XMLHttpRequest();
}
catch(e) {
try{
xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
}
catch(e){
try{
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
}
catch(e1){
xmlhttp=false;
}
}
}

return xmlhttp;
    }

function approve(e) {
var req = getXMLHTTP();
if (req) {

req.onreadystatechange = function() {
if (req.readyState == 4) {
// only if "OK"
if (req.status == 200) {
document.getElementById("appr <?php echo $fet['s_id']; ?>").innerHTML=req.responseText;
} else {
alert("There was a problem while using XMLHTTP:\n" + req.statusText);
}
}
}
req.open("GET", "approve.php?stu="+e, true);
req.send(null);
}
}

function block(b) {
var req = getXMLHTTP();
if (req) {

req.onreadystatechange = function() {
if (req.readyState == 4) {
// only if "OK"
if (req.status == 200) {
document.getElementById('blok').innerHTML=req.responseText;
} else {
alert("There was a problem while using XMLHTTP:\n" + req.statusText);
}
}
}
req.open("GET", "block.php?blo="+b, true);
req.send(null);
}
}
</script>
</head>
<body>
<?php
$admin_err='';
$pass_err='';
if (isset ($_REQUEST['submit'])) {
require 'connect.php';

$admin = $_REQUEST['admin'];
$pass = $_REQUEST['password'];
    $err=0;

if($admin=="") {
          $admin_err="enter username";
          $err=1;
}
    if($pass=="") {
          $pass_err="enter password";
          $err=1;
    }
if ($err == 0) {

$check = mysql_query("SELECT admin FROM admin_login WHERE admin='".$admin."' and password='".$pass."' ");
$exi = mysql_num_rows ($check);

if($exi == 0) $err_msg = "Username/password combination incorrect.";
else {
$sel = mysql_query("SELECT * FROM stud");
echo "<h4 class='table-caption'>Students</h4>";
while ($fet = mysql_fetch_array($sel)) {
?>
<div class="base-layer">
<div class="table-row">

<div class="c_one"><p class="text"> <? echo $fet['name']; ?></p></div>

<div class="c_two"><p class="text"> <? echo $fet['email']; ?></p></div>

<div class="c_three"><p class="text"> <? echo $fet['school']; ?></p></div>

<div class="c_four"><p class="text"> <? echo $fet['subject']; ?></p></div>

<div class="c_five"><p class="text"> <? echo $fet['class']; ?></p></div>

<div class="c_six"><p class="text"> <? echo $fet['teacher']; ?></p></div>

<div class="c_seven" id="appr <?php echo $fet['s_id']; ?>"><p class="text">
<?php if ($fet['approve'] == 0) ?>
<a href="#" onClick="return approve(<?php echo $fet['s_id']; ?>);"
style="text-decoration:none">
Approve</a>
</p>
</div>

<div class="c_eight" id="block"><p class="text">
<?php if($fet['approve'] == 1) ?>
<a href="#" onClick="block(<?php echo $fet['s_id']; ?>);" style="text-decoration:none">
Block
</a>
</p>
</div>
<div class="space-line"> </div>
</div>
</div>
<?php
}
die(mysql_error());
}
}
}
?>
<form  id="formid" method="post" name="myform" action="">
<p>
<label for="username">Admin:</label>
<input name="admin" type="text" size="20" value="<?php if(isset($admin)) echo $admin; ?>" />
<?php echo $admin_err; ?>
</p>

<p>
<label for="pass">Password:</label>
<input name="password" type="password" value="<?php if(isset($pass)) echo $pass;?>" />
<?php echo $pass_err; ?>
</p>

<p>
<input name="submit" type="submit" value="Log in" >
</p>

<?php if(isset($err_msg)) echo $err_msg; ?>
</form>
</body>
</html>

approve.php
Code: [Select]
<?php
require_once 'connect.php';
$id = $_REQUEST['stu'];
$upd = mysql_query ("UPDATE stud SET approve = '1' WHERE s_id = ".$id." ");
if (!$upd)
die(mysql_error());
//header("Location:administrator.php");
echo "Approved";
//echo "<h3>Student Approved</h3>";
?>

I am trying to wrap a string with an anchor tag if it finds a match with a block of text. Here is an example text block:

CONOCO 1'10x8 VC DF TP SGN||PRINCIPAL ILLUMINATION||ENG: CO3028TP_0VPR||DWG: CO200428||TO BE: DYED DIESEL (SPEC)||

The string I would want to wrap with a link would be "CO200428". 

The next problem is the drawings (what I'm searching the text for) has over 115,000 possibilities. The text blocks to search are over 1300.

I have the drawing names stored in a simple mysql table...but doing a foreach takes forever...I imagine it will take even longer when looking in the text blocks...

Is there a way to easily to do the anchor wrap? I don't know regex very well...