PHP - Collapsible Links

ok so im trying to make a news website and i want to be able to include links inside me headline like most news website they talk about the stuff and include some links along the way how would i manage to do that. I would put all my story in the Release textarea

Code: [Select]
<form class="createheadline" action="createrelease.php" method="post" enctype="multipart/form-data">
<table>
<tr>
<td></td>
<td><?php echo $msg;?></td>
</tr>
<tr>
<td>Author:</td>
<td><input type="text" name="author" size="30"/></td>
</tr>
<tr>
<td>Date:</td>
<td><input type="text" name="date" /></td>
</tr>
<tr>
<td>Title:</td>
<td><input type="text" name="title" size="30"/></td>
</tr>
<tr>
<td>Main Picture</td>
<td><input type="file" name="picture" /></td>
</tr>
<tr>
<td>Release:</td>
<td><textarea name="release" cols="75" rows="27"></textarea></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="submitbtn" /></td>
</tr>
</table>
</form>

I am trying to create a link with an ID from one of my MySQL records.

$data = mysql_query("SELECT * FROM USERS");
$info = mysql_fetch_array($data);
echo "<a href=a.php?'$info['id']'>hello</a>";

is what I am attempting, but this does not work. Any  ideas?

Hi... I am really new to this. Please help me with this...  as part of a gallery, I have categories and a thumbnail. As of now the title/link to the gallery shows up on the side of the thumbnail. How can I place the link below the thumbnail?

Here is the code    Code: [Select]
$result_array[] = "<a href='viewgallery.php?cid=".$row[0]."'>".$row[1]."<img src='/photos/categoryimages/category".$row[0].".jpg' border=0 height='133px' width='200px' </a>";
Thank you for your help... 

I replaced the display settings URLs permalink and .htaccess

this is i write in .htaccess file

RewriteEngine on
RewriteCond %{HTTP_HOST} ^www.sportskevesti.co$
RewriteRule ^/?$ "http\:\/\/sportskevesti\.co" [R=301,L]

RewriteRule ^vest/([0-9_]*).html$ index.php?opcija=permalink&=$1 [L]
RewriteRule ^kategorija/([0-9a-zA-Z-_]*).html$ index.php?opcija=kategorija&kategorija_naziv=$1 [L]


link is :
http://sportskevesti.co/index.php?opcija=vest&permalink=evo-sta-se-desi-kad-srpskom-treneru-pukne-film-video

and nothing happens
what is wrong ?

In the MySQL help forum someone asked how to list out all the files in a directory. Another person gave the following code: Code: [Select]
<?php

$handle = opendir('PUT NAME OF YOUR DIR HERE');
while (false !== ($file = readdir($handle)))
{
    if ($file != "." && $file != "..")
{
        echo $file,'<br />';
    }
}
closedir($handle);
?>
I found this to be very helpful! However, is there a way to modify it so that if there are subdirectories, it will list those as hyperlinks so the code would run off of the subdirectory if you were to click that link?

When I asked that question in the MySQL forum, I was told that it had nothing to do with PHP which I know. So that's why I am posting it here. Can anyone help?

I'm trying to make a link to an SQL database survive though page reloads, and it's not working. Connecting, I use this:

function link_to_converted_database()
{
 $link = mysqli_init();
 if (!$link)
  {
   die('mysqli_init failed');
  }
 if (!mysqli_options($link, MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 1'))
  {
   die('Setting MYSQLI_INIT_COMMAND failed');
  }
 if (!mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, 50))
  {
   die('Setting MYSQLI_OPT_CONNECT_TIMEOUT failed');
  }
 if (!mysqli_real_connect($link, 'redacted', 'redacted', 'redacted'))
  {
   die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
  }
 comment( ' Success... ' . mysqli_get_host_info($link) );

 if (mysqli_query($link,'USE conversion_database'))
  {
   comment("now using conversion_database.");
  }
 else
  {
   die('Conversion database unusable (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
  }
 $_SESSION['mysql_link']=$link;
 echo "<!--\n";
 var_dump($_SESSION['mysql_link']);
 echo "\n-->\n";
 return(true);
}

Subsequent SQL commands work fine using $_SESSION['mysql_link'], and the var_dump returns:

object(mysqli)#2 (17) {
  ["affected_rows"]=>
  int(0)
  ["client_info"]=>
  string(48) "mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $"
  ["client_version"]=>
  int(50007)
  ["connect_errno"]=>
  int(0)
  ["connect_error"]=>
  NULL
  ["errno"]=>
  int(0)
  ["error"]=>
  string(0) ""
  ["field_count"]=>
  int(0)
  ["host_info"]=>
  string(24) "192.168.1.101 via TCP/IP"
  ["info"]=>
  NULL
  ["insert_id"]=>
  int(0)
  ["server_info"]=>
  string(16) "5.1.48-community"
  ["server_version"]=>
  int(50148)
  ["sqlstate"]=>
  string(5) "00000"
  ["protocol_version"]=>
  int(10)
  ["thread_id"]=>
  int(194)
  ["warning_count"]=>
  int(0)
}

After a page changes, all my $_SESSION vars work fine except for  $_SESSION['mysql_link']. It's still there, but SQL queries bomb, and var_dump returns:

Warning: var_dump(): Property access is not allowed yet in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Property access is not allowed yet in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595

Warning: var_dump(): Couldn't fetch mysqli in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\voicereader\serverstate.php on line 595
object(mysqli)#1 (17) {
  ["affected_rows"]=>
  NULL
  ["client_info"]=>
  NULL
  ["client_version"]=>
  int(50007)
  ["connect_errno"]=>
  int(0)
  ["connect_error"]=>
  NULL
  ["errno"]=>
  NULL
  ["error"]=>
  NULL
  ["field_count"]=>
  NULL
  ["host_info"]=>
  NULL
  ["info"]=>
  NULL
  ["insert_id"]=>
  NULL
  ["server_info"]=>
  NULL
  ["server_version"]=>
  NULL
  ["sqlstate"]=>
  NULL
  ["protocol_version"]=>
  NULL
  ["thread_id"]=>
  NULL
  ["warning_count"]=>
  NULL
}


There's got to be a way to save my SQL linkages so that I don't have to reconnect to the SQL database every time I want to see if new data has arrived, but this doesn't seem to be it. My PHP version is PHP 5.3.2.0.

Thanks for any help.

Hey everyone, I'm relatively new to php and I have created a basic login page on my site. It checks whether someone is logged in by searching for a cookie.

But I am wondering if there is a simple way to display content an link to only people who are logged in, and show user specific content based on who is logged it (much like forums - but not as complicated, just simple)

Thank you and its very much appreciated

I've been reading about trackbacks and pings but what I'm trying to do is a bit different. I'm trying to track a referral link. For example,

I post this referral link http://www.my-site.com/3ji89 on youtube or a blog..

and that referral links to..

http://www.another-site.com

in http://www.another-site.com is it possible to retrieve the referral link http://www.my-site.com/3ji89 ? Not youtube.com or the blog I posted the link on.

Hi! I have an odd problem... I inserted a flash file in a php doc, and basically what happens is that on some computers, the link does not work without the www extension ... by that i mean if people go to http://mysite.com they will not be able to click the banner but if they put http://www.mysite.com it works...
Very odd as the link is part of the flash movie and it only happens on some computers not all ... anyone would have an idea as to what could cause this ?

Alternativly  what can I do with this piece of code that does not seem to do the trick either

Code: [Select]
<div class="subtitulo"><a href="http://hostelsuites.com/hostel-banner.php?Buenos+Aires+Hostel+Suites+Florida&id_hostel=30&idioma=3&id_banner=2"><?php echo ucfirst($lang["expanish"]) ?></a><br />
<br/></div>
Many thanks for any help !

I have some links created dynamicaly with php. But i have the following problem. When i am in the root folder ieg. localhost/myPage/index.php the links work fine because they link in a file named entry.php. but when i am in a folder ieg. localhost/myPage/users/authors.php and i click the links they try to go to  localhost/myPage/users/entry.php and i want them to link not inside the folder but to the root folder localhost/myPage/entry.php.

Hi all,

Im sorry if this is in the wrong section.


But nonetheless, I use php to display my news:
I.e - news.php?id=1 that displays all the news on that id.



What I want to know is using php how can I get the URL from news.php?id=1 too something like /news/titleofthestory ?

Hope I've given enough detail.

Thanks!!

Hi,
     I need to get links from a web page and display them. User enters a url say abcxyz.com and all the links present on the page abcxyz.com will be displayed.  How can i do this?

Thanks.

Hello dear friends,

Let say we have

Code: [Select]
$to = "gigi";
then we have link like this

Code: [Select]
mysite.com/file.php?id=$1
We can change it to new form by add rule at .htaccess codes

Code: [Select]
RewriteRule -(.*)\.htm file.php?id=$1
So that the link be like this

Code: [Select]
mysite.com/$to-$id.htm

it will works , Now what if i want to make the link like this

Code: [Select]
mysite.com/$id/$to.htm
what will be the .htaccess code in this way ???

thanks

I am trying to get the output for a mysql query to be displayed in colums. I have it where it does this but it goes from left to right. I would rather it go from top to bottem, it would look better this way. I will also need it to brake into sevral pages when there are a certain amout of entrys shown. If you know of a  good how to on that let me know please.  The other problom that I am having is to make the output a link. I was able to do this before I attemped to devide everything but if I add in what I had before it comes back with no data.

Here's what I have now that put shows the data from left to right in 2 colums.

Code: [Select]
<?php
include"scripts/connect.php" ;

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM movies WHERE type LIKE 'movie' ORDER BY title";

if(mysql_query($query))
{
$result=mysql_query($query);

$num=mysql_numrows($result);

}


for($i=0; $i<$num; $i++)
{
if($i%2==0){
echo "<tr><td>";
} 
else{
echo "<td>";
}

print mysql_result($result,$i,"title");

if ($i%2==0){
echo "</td>";
}
else{
echo "</td>";
}
}
echo "</tr>";
?>
Thanks in advance

Hey all, I'm currently coding a Few Blacklists for my Website, in which I want to code it so I'll have all blacklists on one page so the URL would be like:

localhost/blacklist.php?user
localhost/blacklist.php?staff

I've got a Blacklist coded which all works well, just I've attempted using the $_GET function to change the code to the blacklist that they clicked on...


<?php
session_start();

include ("includes/config.php");
include ("includes/functions.php");

logincheck();

$Username = $_SESSION['username'];

?>
<table width='50%' cellpadding='0' cellspacing='0' border='1' class='table' align='center'>
<tr>
     <td class='header' align='center' colspan='4'>Other Blacklists:</td>
    </tr>
    <tr>
     <td align='center'><a href='?user' target='mainFrame'>User Blacklist</a></td><td align='center'><a href='?money' target='mainFrame'>Most Money</a></td><td align='center'><a href='?racewins.php' target='mainFrame'>Race Wins</a></td><td align='center'><a href='?racelose' target='mainFrame'>Race Loses</a></td>
    </tr>
    <tr>
     <td align='center'><a href='?miles' target='mainFrame'>Most Miles</a></td><td align='center'><a href='?fosbl' target='mainFrame'>Faster Or Slower</a></td><td align='center'><a href='?police' target='mainFrame'>Police Chase</a></td>
    </tr>
</table>        
<br />
<table width='20%' cellpadding='0' cellspacing='0' border='1' class='table' align='center'>
     <tr>
         <td colspan='2' align='center' class='header'>User Blacklist:</td>
        </tr>
        <tr>
         <td align='center' class='omg' width='5%'>Num:</td><td align='center' class='omg' width='10%'>Username:</td>
        </tr>       

<?php
if ($_GET['user']){
$Query = mysql_query("SELECT * FROM users WHERE userlevel = '1' OR userlevel = '5' ORDER BY rep DESC LIMIT 25");
for ($Place < 25; $This = mysql_fetch_object($Query);){
$Place = $Place+1;
if ($This->username != $Username){
$Colour = "bgcolor=#424242";
}else{
$Colour = "bgcolor=#111111";
}
print ("<tr><td width='5%' align='center' $Colour>$Place</td><td width='20%' align='center' $Colour><a href='profile.php?viewuser=".$This->username."'>$This->username</a></td></tr>");
}
}


?>
    </table> 
    <br />

Soon as I added the $_GET['user]{ it stopped showing the Blacklist completely.

Sorry if it wasn't explained well, but hopefully you can catch what I'm trying to-do

Thanks.