Help with database

@Arnie7294authorMay 17.2010 — #<?php

include('admin/db1.php');
  mysql_select_db($database);
 
  $limit          = 5; 
  $query_count    = "SELECT * FROM  eternal_patientforms ORDER BY id ASC"; 
  $result_count   = mysql_query($query_count); 
  $totalrows      = mysql_num_rows($result_count); 
 
  if(empty($page)){
   $page = 1;
  }
  $limitvalue = $page * $limit - ($limit); 
  $query = "SELECT * FROM  eternal_patientforms ORDER BY id DESC LIMIT $limitvalue, $limit";
 
  $result = mysql_query($query) or die ("Failed to execute query: " . db_error() . '<br>SQL: ' . $db_query);
  $color1 = "#ffffff"; 
  $color2 = "#eeeeee"; 
  $row_count = 0;

?>

<?php

while($row = mysql_fetch_array($result)) {

// Set row color

$id = $row ["id"];

//$desc = $row['story'];

$new = preg_replace(

'/<img (.*?)src="[a-z0-9.://-]+"(.*?)>/i',

'',

$row[description]

);

$new = preg_replace(

'/<strong>/i',

'',

$new

);

$new = preg_replace(

'/<p>/i',

'',

$new

);

//$output = preg_replace('/<img src="[a-z0-9.]+"/i', '<img src=""', $desc);

//$desc = preg_replace('/<img src="[a-z0-9.]+"/i', '', $desc);

$text = substr($new,0,130);

?>

<?php

$row['date'] = date("M jS Y" ,strtotime($row['date']));

?>

<p>
   <div style="text-align:left;">
   <strong>
   <a href="admin/user/files/<?php echo $row['file']; ?>"><? echo $row['manualname']; ?></a>
   </strong>
   </div>
 
   <div>
   <?php echo $text; ?>...
   </div>
   <br />&nbsp;
   </p>
 
   <?php
  $row_count++; 
   }
 
   ?>

<div class="newsdisplay">
  <?
  if($page != 1){ 
   $pageprev = $page-1;
 
   echo("<a href="$PHP_SELF?page=$pageprev">Prev </a> "); 
  }else{
   echo("Prev ");
  }
 
  $numofpages = $totalrows / $limit; 
 
  for($i = 1; $i <= $numofpages; $i++){
   if($i == $page){
   echo("<big>".$i." </big>");
   }else{
   echo("<a href="$PHP_SELF?page=$i">$i</a> ");
   }
  }
 
 
  if(($totalrows % $limit) != 0){
   if($i == $page){
   echo("<big>".$i." </big>");
   }else{
   echo("<a href="$PHP_SELF?page=$i">$i</a> ");
   }
  }
 
  if(($totalrows - ($limit * $page)) > 0){
   $pagenext = $page+1;
 
   echo("<a href="$PHP_SELF?page=$pagenext"> Next</a>"); 
  }else{
   echo(" Next"); 
  }
  ?>

Help with database

2 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Help with database

2 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #PHP _↴