Jump to content

davinci

Members
 View Profile  See their activity

  • Posts

    29

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by davinci

  1. davinci
    [!--quoteo(post=379051:date=Jun 1 2006, 08:54 AM:name=samshel)--][div class=\'quotetop\']QUOTE(samshel @ Jun 1 2006, 08:54 AM) [snapback]379051[/snapback][/div][div class=\'quotemain\'][!--quotec--] check the url u r passing <?=$_GET['url']?> it must be framecontents.php [/quote] The url in the browser is [a href=\"http://mysite.com/visit.php?url=http://othersite.com\" target=\"_blank\"]http://mysite.com/visit.php?url=http://othersite.com[/a] When I click the button it takes me to framecontents.php which is my frame but where I want it to go is to [a href=\"http://othersite.com\" target=\"_blank\"]http://othersite.com[/a]... I'm a newbie but it seems as if its trying to pull the from the framecontents.php. Also, when I check the HTML source after clicking the close frame button, instead of the pulled 'url' value it is blank.
  2. davinci
    [!--quoteo(post=378989:date=Jun 1 2006, 04:33 AM:name=samshel)--][div class=\'quotetop\']QUOTE(samshel @ Jun 1 2006, 04:33 AM) [snapback]378989[/snapback][/div][div class=\'quotemain\'][!--quotec--] Try TARGET="_parent" [/quote] If you meant: [code] <TD width="1%" valign="center">         <A HREF="<?=$_GET['url']?>" TARGET="_parent"><IMG SRC="close.gif" WIDTH="12" HEIGHT="11" BORDER="0" ALT="Remove Frame"></A> [/code] Still doesn't work. When I click the button, it loads up framecontents.php, instead of othersite.com. Any more ideas?
  3. davinci
    Hi, I tried putting together some code so that when someone visits a link off my site it opens the visited site with a frame on top of the page that has my little header. For example: someone clicks on [a href=\"http://mysite.com/visit.php?=http://othersite.com\" target=\"_blank\"]http://mysite.com/visit.php?=http://othersite.com[/a] My Problem: When I click the image of the little "x" in my frame in order to close the frame and show the site without a frame, instead of removing the frame, it removes the visited site instead and brings me to mysite.com/framecontents.php. I believe the code that needs to be modified can be viewed below in framecontents.php visit.php looks like this: [code] <?php include 'library/config.php'; include 'library/opendb.php'; $query = "UPDATE plugs SET clicks = (clicks + 1) WHERE url = '$url'"; mysql_query($query) or die('Error, insert query failed'); ?> <title><?=$_GET[title]?> - Brought to you by MySite.com</title> <frameset rows='100,*' border=0 frameborder=0 framespacing=0> <frame scrolling=no noresize src='framecontents.php'> <frame scrolling=yes frameborder=0 src='<?=$_GET[url]?>'> </frameset> <noframes> <body> <p>This page uses frames, but your browser doesn't support them.</p> </body> </noframes>[/code] framecontents.php looks like this: [code] <html> <head> <title>CJ Link Out V1.0</title> <link rel="stylesheet" href="style.css" type="text/css"> </head> <body topmargin="0" leftmargin="0"> <TABLE border="0" cellspacing="0" cellpadding="0" width="100%" height="75">  <TR>   <TD>     <TABLE border="0" cellspacing="2" cellpadding="1" width="100%">       <TR>       <TD width="1%" nowrap>             <TD width="1%" valign="center">         <A HREF="<?=$_GET['url']?>" TARGET="_top"><IMG SRC="close.gif" WIDTH="12" HEIGHT="11" BORDER="0" ALT="Remove Frame"></A>             </TD>             <TD width="99%" valign="center">         <B><? echo ucfirst($show); ?></B>              <A HREF="index.php" TARGET="_top"><IMG SRC="neon.gif" class="nob"></a> </TD>      </TD>      <TD width="99%" nowrap>        <div align="right"><A HREF="index.php" TARGET="_top">Back to MySite.com        </A></div>      </TD>      </TR>     </TABLE>       </TD>   </TR> </TABLE>[/code] Can anyone point out the error? I'm assuming its something wrong with this... Doesn't seem to be pulling the url... [code] <A HREF="<?=$_GET['url']?>" TARGET="_top"><IMG SRC="close.gif" WIDTH="12" HEIGHT="11" BORDER="0" ALT="Remove Frame"></A>[/code] Thanks!
  4. davinci
    [!--quoteo(post=354279:date=Mar 12 2006, 03:09 PM:name=keeB)--][div class=\'quotetop\']QUOTE(keeB @ Mar 12 2006, 03:09 PM) [snapback]354279[/snapback][/div][div class=\'quotemain\'][!--quotec--] You would add a column to your database called clicks, then, make a referrer PHP file.. something like 'refer.php?to=http://www.google.com' and then, do the necessary checks. [= It seems like you're proficient enough to figure out how to do that, so if you need more help don't hesitate to post! [/quote] I'm not quite as proficient as I wish I was just yet... Mostly put together my scripts from mixing and matching from different scripts. I have this script that I came across, and I use it for trading traffic where it calculates hits in and hits out. Apparently for perm linking you just need to do go.php?j=www.site.com but it doesn't seem to work for sites that aren't already sending traffic to my site: [code]<?php /* * referers.php (c) plebian.com 1999-2004 * * go.php * Jump to a url. */ if(isset($_SERVER['QUERY_STRING'])) {     require_once('config.php');          if(preg_match('!^[0-9]+$!',$_SERVER['QUERY_STRING']))     {         $id=&$_SERVER['QUERY_STRING'];         $c=mysql_query("select id,url from TW_referers where id='{$id}'");     }     elseif(!empty($_GET['j']))     {         $url=addslashes($_GET['j']);         $c=mysql_query("select id,url from TW_referers where url='$url' order by id desc limit 1");     }     else     {         $c=null;     }     $d=mysql_fetch_object($c);     if(is_object($d))     {         mysql_query("update TW_referers set hitsout=hitsout+1 where id='{$d->id}'");         $url=stripslashes($d->url);         if(array_key_exists($url,$jump_url_replace))             $url=$jump_url_replace[$url];     }     else     {         $url=&$_SERVER['SERVER_NAME'];     } } else {     $url=&$_SERVER['SERVER_NAME']; } header("Location: http://$url"); exit; ?>[/code] Also I guess I would need to add to this script to have it add clicks to my links DB, because right now its only adding to the referrers DB that is special for this go.php script. Any suggestions?
  5. davinci
    Is there an easy way to add clicks to my DB for links that I post that direct users off my site? So far this is what I have, but does not include any counting of any sort: [code]<?php include 'library/config.php'; include 'library/opendb.php'; $id = (isset($_GET['id']) ? $_GET['id'] : ""); if (empty($id)) { $rowsPerPage = 2; $pageNum = 1; if(isset($_GET['page'])) {     $pageNum = $_GET['page']; } $offset = ($pageNum - 1) * $rowsPerPage; $query = "SELECT id, title, url, description, thumbnail, DATE_FORMAT(entry_date, '%M %D %Y') AS date, category FROM plugs ORDER BY id DESC LIMIT $offset, $rowsPerPage"; $result = mysql_query($query) or die('Error, query failed'); ?> <div class="title">Must Visit</div><p>&nbsp<br> <?php while($row = mysql_fetch_array($result)) { ?> <table width="460" border="0" align="center" cellpadding="1" cellspacing="0">   <tr>         <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">         <tr>           <td width="18%" align="center" valign="top"> <div align="center"><a href="<?=$row['url'];?>"><IMG BORDER="0" img src="media/thumbs/<?=$row['thumbnail'];?>" height="80" width="80"></a></font><font face="Arial, Helvetica, sans-serif">               </font></div></td>           <td width="82%" align="center" valign="top"><div align="left">               <table width="100%" border="0" cellspacing="5" cellpadding="0">                 <tr>                   <td><font size="2"><a href="<?=$row['url'];?>"><b><?php echo $row['title'];?></b></a> <br><?php echo $row['description'];?></font></td>                 </tr>                 <tr>                   <td>&nbsp;</td>                 </tr>               </table>             </div></td>         </tr>         <tr>           <td colspan="2" align="center" valign="top"> <div align="left"> <font size="1">Submitted               On: <?php echo $row['date'];?> | xxx | Category: <?=$row['category'];?> | Clicks: 99</div></td></font>         </tr>       </table></td>       </tr>     </table>[/code]
  6. davinci
    Ok, I'm an idiot. :P I forgot the " ' " marks around '$category' in my query. So sorry to waste your time!
  7. davinci
    I have form to upload news. Works well but I'm trying to add a drop down box to select the category. I've created a column called category in my news table. For the form I am using this code: [code] <tr><td> <select name="category" style="border: 1px solid #000000"> <option name="Type" option value="Type">Type..</option> <option name="Ad" option value="Ad">Ad</option> <option name="Video" option value="Video">Video</option> <option name="Gallery" option value="Gallery">Gallery</option> <option name="News" option value="News">News</option> <option name="Other" option value="Other">Other</option> </select></td> </tr><br>[/code] But whenever I try to use it I get the error: Error, query failed : Unknown column 'Video' in 'field list' (or instead of video, whichever value I selected). What am I doing wrong here?
  8. davinci
    [!--quoteo(post=354211:date=Mar 12 2006, 11:18 AM:name=wildteen88)--][div class=\'quotetop\']QUOTE(wildteen88 @ Mar 12 2006, 11:18 AM) [snapback]354211[/snapback][/div][div class=\'quotemain\'][!--quotec--] The message you are recieving isn't an error but a just a message PHP throughs out when something isn't set. No the message is refering to the following: [code]$id = $_GET['id']; if ($id == "") {[/code]Notice where it says [i]$id = $_GET['id'][/i] this is ok but when you run your script and the id variable isn't passed over the url (index.php?id=1) then PHP will through a Notice message as $_GET['id'] isn't set! To get arround this simply change the two lines of code I posted above to the following: [code]$id = (isset($_GET['id']) ? $_GET['id'] : ""); if (empty($id)) {[/code] The new code first checks whether $_GET['id'] is actually set. If it is then it'll assign $id the value of $_GET['id'] otherwise it'll set $id to nothing! The next line of code just checks whether the value of $id is empty [/quote] Ok, I'm going to try this. UPDATE: Works perfectly, thank you!
  9. davinci
    Hi guys, I have an index.php page and I'm including the following script (called showplugs.php) that I put together for my news postings . I've including paging but I think I've messed up somewhere because I am getting the following error on my frontpage right over where the news articles start: Notice: Undefined index: id in .../public_html/showplugs.php on line 6 The articles are there but so is the error. Here is the script: [code] <?php include 'library/config.php'; include 'library/opendb.php'; $id = $_GET['id']; if ($id == "") { $rowsPerPage = 6; $pageNum = 1; if(isset($_GET['page'])) {     $pageNum = $_GET['page']; } $offset = ($pageNum - 1) * $rowsPerPage; $query = "SELECT id, title, url, description, thumbnail, DATE_FORMAT(entry_date, '%M %D %Y') AS date FROM plugs ORDER BY id DESC LIMIT $offset, $rowsPerPage"; $result = mysql_query($query) or die('Error, query failed'); ?> <div class="title">Must Visit</div><p> <?php while($row = mysql_fetch_array($result)) { ?> .......more code here [/code] Thanks, and any help or comments appreciated! Addition: Also noticed that it is paging my index.php to page=1 but I don't want this. I want it to page within the index is that possible?
  10. davinci
    [!--quoteo(post=353305:date=Mar 9 2006, 12:00 PM:name=obsidian)--][div class=\'quotetop\']QUOTE(obsidian @ Mar 9 2006, 12:00 PM) [snapback]353305[/snapback][/div][div class=\'quotemain\'][!--quotec--] actually, that's correct syntax. if you're only echoing a variable, you can use the shorthand <?= opening tag instead. as to the question at hand: you're formatting your date in your query, but you're not defining the results as "date", yet you're trying to echo "date" out of the array. i think you should be able to change your query to this and be ok: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] id, name, path, title, thumbnail, playcount, DATE_FORMAT(entry_date, [color=red]'%M %D %Y'[/color]) [color=green]AS[/color] date [color=green]FROM[/color] [color=orange]upload2[/color] [color=green]ORDER BY[/color] id [color=green]DESC[/color] LIMIT $offset, $rowsPerPage [!--sql2--][/div][!--sql3--] by using the "AS date", you are naming the results 'date' in your array, so you can just <?= $row['date'] ?> where you want it displayed. hope this helps [/quote] You guys rock! Adding the "AS date" did the trick!
  11. davinci
    I added paging to one of my scripts and now the date doesn't show up. Can someone catch my mistake? At first I had this: [code]<?php include 'header.php' ?> <?php include 'left.php' ?> <?php include 'library/config.php'; include 'library/opendb.php'; $id = $_GET['id']; if ($id == "") { $query = "SELECT id, name, path, title, thumbnail, playcount, DATE_FORMAT(entry_date, '%M %D %Y') FROM upload2 ORDER BY id DESC"; $result = mysql_query($query) or die('Error, query failed'); while(list($id, $name, $path, $title, $thumbnail, $playcount, $date) = mysql_fetch_array($result)) { ?> <div align="center"> <table cellpadding="2" width="100%"  border="0" cellspacing="0" cellpadding="0"><tr> <td width="30%"> <a href="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?= $id; ?>"><IMG BORDER="0" img src="media/thumbs/<?=$thumbnail;?>" height="80" width="80"><p> </a></td> <td width="70%"> <a href="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?= $id; ?>"><b><?php echo $title;?></b></a><br>Added on <?=$date;?> <br>Plays: <?=$playcount;?> </td></tr></table>[/code] Now wherever I put <?=$date;?> I don't get anything... Then I changed it so that it has paging: [code]<?php include 'library/config.php'; include 'library/opendb.php'; $id = $_GET['id']; if ($id == "") { $rowsPerPage = 6; $pageNum = 1; if(isset($_GET['page'])) {     $pageNum = $_GET['page']; } $offset = ($pageNum - 1) * $rowsPerPage; $query = "SELECT id, name, path, title, thumbnail, playcount, DATE_FORMAT(entry_date, '%M %D %Y') FROM upload2 ORDER BY id DESC LIMIT $offset, $rowsPerPage"; $result = mysql_query($query) or die('Error, query failed'); ?> <div class="title">Video Archive</div><p> <?php while($row = mysql_fetch_array($result)) { ?> <div align="center"> <table cellpadding="2" width="75%"  border="0" cellspacing="0" cellpadding="0"><tr> <td width="50%"> <a href="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?= $row['id'];?>"><IMG BORDER="0" img src="media/thumbs/<?=$row['thumbnail'];?>" height="80" width="80"><p> </a></td> <td width="50%"> <a href="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?= $row['id'];?>"><b><?php echo $row['title'];?></b></a> <br>Added on <?=$row['date'];?> <br>Plays: <?=$row['playcount'];?> </td></tr></table><? } ?>[/code] Thank you to whoever can clear me up!
  12. davinci
    [!--quoteo(post=353112:date=Mar 8 2006, 09:45 PM:name=AndyB)--][div class=\'quotetop\']QUOTE(AndyB @ Mar 8 2006, 09:45 PM) [snapback]353112[/snapback][/div][div class=\'quotemain\'][!--quotec--] Usually means that somewhere there's an unclosed curly bracket ... quite where } belongs isn't evident (so maybe it's in the code that's included) [/quote] Thanks! After knowing what to look for I found that I had left out a } !! I appreciate the help.
  13. davinci
    Trying to mix and match pieces of code in order to get a way to post news to my site but including uploading a thumbnail. Here's what I came up with. However I get an error: Parse error: parse error, unexpected $ in /xxx/public_html/test/addplug.php on line 160 but don't know why considering I don't have a "$" on that line! Can someone help? [code]<?php // include the database configuration and // open connection to database include 'library/config.php'; include 'library/opendb.php'; $uploadDir = 'media/thumbs/'; // check if the form is submitted if(isset($_POST['upload'])) {     // get the input from $_POST variable     // trim all input to remove extra spaces     $title    = trim($_POST['txtTitle']);     $description   = trim($_POST['txtDescription']);     $url     = trim($_POST['txtUrl']);     $thumbnail = trim($_POST['thumbnailfile']);          // escape the message ( if it's not already escaped )     if(!get_magic_quotes_gpc())     {         $title    = addslashes($title);         $description = addslashes($description);     }          // if the visitor do not enter the url     // set $url to an empty string     if ($url == 'http://')     {         $url = '';     } //adding thumbnail stuff if(isset($_POST['upload'])) {     $fileName = $_FILES['thumbnailfile']['name'];     $filePath = $uploadDir . $fileName;     $result    = move_uploaded_file($tmpName, $filePath);     if (!$result) {         echo "Error uploading file";         exit;     }          // prepare the query string     $query = "INSERT INTO guestbook (title, description, url, thumbnail, entry_date) " .              "VALUES ('$title', '$description', '$url', '$fileName', current_date)";     // execute the query to insert the input to database     // if query fail the script will terminate             mysql_query($query) or die('Error, query failed. ' . mysql_error());          // redirect to current page so if we click the refresh button     // the form won't be resubmitted ( as that would make duplicate entries )     header('Location: ' . $_SERVER['REQUEST_URI']);          // force to quit the script. if we don't call exit the script may     // continue before the page is redirected     exit; } ?> <html> <head> <title>Add a Plug</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" type="text/css" href="styles/styles.css"> <script language="JavaScript"> /*     This function is called when     the 'Sign Guestbook' button is pressed     Output : true if all input are correct, false otherwise */ function checkForm() {     // the variables below are assigned to each     // form input     var gname, gemail, gurl, gmessage;     with(window.document.guestform)     {         gtitle    = txtTitle;         gdescription   = txtDescription;         gurl     = txtUrl;         gthumbnail = thumbnailfile;     }          // if name is empty alert the visitor     if(trim(gtitle.value) == '')     {         alert('Please enter a title');         gname.focus();         return false;     }     // alert the visitor if email is empty or the format is not correct     else if(trim(gdescription.value) != '' && !isEmail(trim(gdescription.value)))     {         alert('Please enter a description');         gemail.focus();         return false;     }     // alert the visitor if message is empty     else if(trim(gthumbnail.value) == '')     {         alert('Please Add a Thumbnail');         gthumbnail.focus();         return false;     }     else     {         // when all input are correct         // return true so the form will submit                 return true;     } } /* Strip whitespace from the beginning and end of a string Input  : a string Output : the trimmed string */ function trim(str) {     return str.replace(/^\s+|\s+$/g,''); } </script> </head> <body> <form method="post" enctype="multipart/form-data" name="plugs"> <table width="550" border="0" cellpadding="2" cellspacing="1">   <tr>    <td width="100">Title</td> <td>     <input name="txtTitle" type="text" id="txtTitle" size="30" maxlength="30"></td> </tr>   <tr>    <td width="100">Description</td>    <td>     <input name="txtDescription" type="text" id="txtDescription" size="200" maxlength="200"></td> </tr>    <tr>    <td width="100">URL</td>    <td>     <input name="txtUrl" type="text" id="txtUrl" value="http://" size="30" maxlength="50"></td> </tr>    <tr>    <td width="100">Thumbnail</td>     <td>     <input name="thumbnailfile" type="file" class="box" id="thumbnailfile"></td> </tr>   <tr>    <td width="100">&nbsp;</td>    <td>     <input name="upload" type="submit" id="upload" value="Plug" onClick="return checkForm();"></td> </tr> </table> </form>[/code] Thanks again and sorry for the lengthy code... :)
  14. davinci
    Your way makes more sense! I've changed it to what you told me and now I have a better understanding of why it works the way it does. Thank you very much.
  15. davinci
    Solved it...! This seemed to do the trick: [code] <?php include 'library/config.php'; include 'library/opendb.php'; $id = $_GET['id']; if ($id == "") { $heading = '<div class="title">Video Archive</div><p>'; $rowsPerPage = 6; $pageNum = 1; if(isset($_GET['page'])) {     $pageNum = $_GET['page']; } $offset = ($pageNum - 1) * $rowsPerPage; echo $heading; $query = "SELECT id, name, path, title, thumbnail, playcount, DATE_FORMAT(entry_date, '%M %D %Y') FROM upload2 ORDER BY id DESC LIMIT $offset, $rowsPerPage"; $result = mysql_query($query) or die('Error, query failed'); while($row = mysql_fetch_array($result)) { ?> [/code]
  16. davinci
    Want to insert this HTML header: [code] <div class="title">Videos</div> [/code] Into this script without it repeating in the loop: [code] <?php include 'library/config.php'; include 'library/opendb.php'; $id = $_GET['id']; if ($id == "") { $rowsPerPage = 6; $pageNum = 1; if(isset($_GET['page'])) {     $pageNum = $_GET['page']; } $offset = ($pageNum - 1) * $rowsPerPage; $query = "SELECT id, name, path, title, thumbnail, playcount, DATE_FORMAT(entry_date, '%M %D %Y') FROM upload2 ORDER BY id DESC LIMIT $offset, $rowsPerPage"; $result = mysql_query($query) or die('Error, query failed'); while($row = mysql_fetch_array($result)) { ?> <div align="center"> <table cellpadding="2" width="75%"  border="0" cellspacing="0" cellpadding="0"><tr> <td width="50%"> <a href="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?= $row['id'];?>"><IMG BORDER="0" img src="media/thumbs/<?=$row['thumbnail'];?>" height="80" width="80"><p> </a></td> <td width="50%"> <a href="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?= $row['id'];?>"><b><?php echo $row['title'];?></b></a><br>Added on <?=$row['date'];?> <br>Plays: <?=$row['playcount'];?> </td></tr></table><? } ?> [/code] Can someone show me how to insert this code as a heading rather than a repeated element?
  17. davinci
    [!--quoteo(post=351902:date=Mar 5 2006, 05:19 PM:name=davinci)--][div class=\'quotetop\']QUOTE(davinci @ Mar 5 2006, 05:19 PM) [snapback]351902[/snapback][/div][div class=\'quotemain\'][!--quotec--] While we got this script posted, can someone tell me how to add a a text header to the top of this video listing page? Whatever I try, it keeps repeating my chosen title name for every output in the listing. Thanks! [/quote] Anyone?
  18. davinci
    While we got this script posted, can someone tell me how to add a a text header to the top of this video listing page? Whatever I try, it keeps repeating my chosen title name for every output in the listing. Thanks!
  19. davinci
    Got it now, thanks!
  20. davinci
    When no video is selected for video.php, the script lists all my videos with descriptions and playcounts in a column. Problem is when I try to add paging for some reason its only displaying one entry instead of five per page. The amount of pages is correct however it only shows one video per page instead of the correct page listing. Can someone spot my error? [code] <?php include 'library/config.php'; include 'library/opendb.php'; $id = $_GET['id']; if ($id == "") { $rowsPerPage = 5; $pageNum = 1; if(isset($_GET['page'])) {     $pageNum = $_GET['page']; } $offset = ($pageNum - 1) * $rowsPerPage; $query = "SELECT id, name, path, title, thumbnail, playcount, DATE_FORMAT(entry_date, '%M %D %Y') FROM upload2 ORDER BY id DESC LIMIT $offset, $rowsPerPage"; $result = mysql_query($query) or die('Error, query failed'); while($row = mysql_fetch_array($result)) { ?> <div align="center"> <table cellpadding="2" width="65%"  border="0" cellspacing="0" cellpadding="0"><tr> <td width="50%"> <a href="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?= $row['id'];?>"><IMG BORDER="0" img src="media/thumbs/<?=$row['thumbnail'];?>" height="80" width="80"><p> </a></td> <td width="50%"> <a href="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?= $row['id'];?>"><b><?php echo $row['title'];?></b></a><br>Added on <?=$row['date'];?> <br>Plays: <?=$row['playcount'];?> </td></tr></table> <?php // how many rows we have in database $query   = "SELECT COUNT(id) AS numrows FROM upload2"; $result  = mysql_query($query) or die('Error, query failed'); $row     = mysql_fetch_array($result, MYSQL_ASSOC); $numrows = $row['numrows']; // how many pages we have when using paging? $maxPage = ceil($numrows/$rowsPerPage); // print the link to access each page $self = $_SERVER['PHP_SELF']; $nav = ''; for($page = 1; $page <= $maxPage; $page++) {     if ($page == $pageNum)     {         $nav .= " $page ";   // no need to create a link to current page     }     else     {         $nav .= " <a href=\"$self?page=$page\">$page</a> ";     }         } // creating previous and next link // plus the link to go straight to // the first and last page if ($pageNum > 1) {     $page = $pageNum - 1;     $prev = " <a href=\"$self?page=$page\">[Prev]</a> ";          $first = " <a href=\"$self?page=1\">[First Page]</a> "; } else {     $prev  = '&nbsp;'; // we're on page one, don't print previous link     $first = '&nbsp;'; // nor the first page link } if ($pageNum < $maxPage) {     $page = $pageNum + 1;     $next = " <a href=\"$self?page=$page\">[Next]</a> ";          $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> "; } else {     $next = '&nbsp;'; // we're on the last page, don't print next link     $last = '&nbsp;'; // nor the last page link } // print the navigation link echo $first . $prev . $nav . $next . $last; ?> [/code]
  21. davinci
    Hi, Have a video post site and I use mySQL to display my videos through out my site. Whenever I upload a video it has an 'id' which is auto incremented. Each video is displayed with the following URL structure: ../video.php?id=1, ../video.php?id=2 and so on. I've deleted a whole bunch of videos and kept the few good ones. I renamed all my last 5 remaining 'id' entries so that they would be 1, 2, 3, 4, 5 instead of a bunch of gaps between numbers for the ones I've deleted. But now when I add an entry its being added as id 12 instead of 6 (as if I didn't delete entries). Is there a way around this? I just don't like having the gap in my site structure. In PHPmyAdmin I can see "Next Autoindex 12", is there a way to chaneg this value? Thanks! [!--quoteo(post=350113:date=Feb 27 2006, 09:25 PM:name=davinci)--][div class=\'quotetop\']QUOTE(davinci @ Feb 27 2006, 09:25 PM) [snapback]350113[/snapback][/div][div class=\'quotemain\'][!--quotec--] Hi, Have a video post site and I use mySQL to display my videos through out my site. Whenever I upload a video it has an 'id' which is auto incremented. Each video is displayed with the following URL structure: ../video.php?id=1, ../video.php?id=2 and so on. I've deleted a whole bunch of videos and kept the few good ones. I renamed all my last 5 remaining 'id' entries so that they would be 1, 2, 3, 4, 5 instead of a bunch of gaps between numbers for the ones I've deleted. But now when I add an entry its being added as id 12 instead of 6 (as if I didn't delete entries). Is there a way around this? I just don't like having the gap in my site structure. In PHPmyAdmin I can see "Next Autoindex 12", is there a way to chaneg this value? Thanks! [/quote] Found a feature in PHPmyAdmin table options to set the current auto increment value however when I enter a new one when it runs the query it doesn't actually change it sets the value for the original one (12).
  22. davinci
    Plays recorded but qetting this error: Warning: mysql_close(): no MySQL-Link resource supplied in /home/xxxxx/public_html/test2/video.php on line 78 Used this code: [code]<?php include 'library/config.php'; include 'library/opendb.php'; $query = "UPDATE upload2 SET playcount = (playcount + 1) WHERE id = '$id'"; mysql_query($query) or die('Error, insert query failed'); include 'library/closedb.php'; ?> [/code] So I removed the line "include 'library/closedb.php';" and it works now. Is what I'm doing dangerous in any way because it works like this! :)
  23. davinci
    I added that query like this: [code] <?php } } else { $query = "SELECT name, path, title FROM upload2 UPDATE videos SET playcount = (playcount + 1) WHERE id = '$id'"; $result = mysql_query($query); $r = mysql_fetch_array($result, MYSQL_ASSOC); ?> [/code] Also tried adding a new query: [code] <?php include 'library/config.php'; include 'library/opendb.php'; mysql_select_db($mysql); $query = "UPDATE upload2 SET playcount = (playcount + 1) WHERE id = '$id'". mysql_query($query) or die('Error, insert query failed'); $query = "FLUSH PRIVILEGES"; mysql_query($query) or die('Error, insert query failed'); include 'library/closedb.php'; ?> [/code] Clearly its wrong... Where does it belong?
  24. davinci
    I've added a play count entry in to my video table... How do I have the record updated with every play?
  25. davinci
    Well if this is better for the long term I will keep it this way. Just something that I don't like about people just changing the =id?15 to all different numbers to find videos instead of using my sites navigation. But, of course wouldn't be worth it if it takes a lot of work to update later. Site is really coming along, I'll shoot you a link if you're interested when its finished.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.