0
<?php

        include 'session.inc';
            check_login();



            $con=mysql_connect("localhost","root","");
            if(!$con)
                die('Could not connect:' .mysql_error());

            mysql_select_db("vms", $con);

                if($_POST[product]!='NONE')
                {

                    $product=$_POST[product];                                       
                }   
                else
                {
                    $product='NONE';
                }           
                $expire=time()+60*60;   
                setcookie("product",$product,$expire);

                if(product!='NONE')
                {

// how many rows to show per page
$rowsPerPage = 20;

// by default we show first page
$pageNum = 1;
// if $_POST['page'] defined, use it as page number
if(isset($_POST['page']))
{
echo "page:".$_POST['page'];
$pageNum = $_POST['page'];
}

// counting the offset

$offset = ($pageNum - 1) * $rowsPerPage;


$query="SELECT CRNo AS CR,DescriptionCR AS DCR FROM cr where Product='".$product."' ORDER BY CR"." . LIMIT $offset, $rowsPerPage";
                    $result = mysql_query($query);
                    $i=0;
                    $TotalNoOfCR=0;
                    $checkcr=0;
                    while($row = mysql_fetch_array($result))
                    {   
                        $CR[$i]=$row['CR'];
                        $row['DCR']=str_replace("\'","'",$row['DCR']);
                        $DCR[$i]=$row['DCR'];
                        $TotalNoOfCR=$i;
                        $checkcr=1;             
                        $i++;
                    }


$query="SELECT CRNo AS CR,DescriptionCR AS DCR FROM cr where Product='".$product."' ORDER BY CR".";
                    $result = mysql_query($query);
                    $i=0;
                    $numrows=0;

                    while($row = mysql_fetch_array($result))
                    {   
                        $numrows=$i;

                        $i++;
                    }


$maxPage = ceil($numrows/$rowsPerPage);
// print the link to access each page
$self='Upd_provsCRform.php';

$nav ='';

for($page = 1; $page <= $maxPage; $page++)
{

if ($page == $pageNum)


$nav .= "$page"  ; //  [QUOTE]getting error on this line [/QUOTE]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;
// and close the database connection*/
mysql_close($con);


}









                $query="SELECT projectName AS project FROM project_details ORDER BY project";
                $result = mysql_query($query);
                $i=0;
                $TotalNoOfProject=0;
                while($row = mysql_fetch_array($result))
                {   
                    $PR[$i]=$row['project'];
                    $TotalNoOfProject=$i;                                   
                    $i++;                   
                }   




                $query="SELECT status as S,shortstatus as SS FROM cr_status";
                $result = mysql_query($query); 
                $i=0;              
                $TotalNoOfStatus=0;    
                while($row = mysql_fetch_array($result))
                {
                    $status[$i]=$row['S'];
                    $shortstatus[$i]=$row['SS'];
                    $TotalNoOfStatus=$i;
                    $i++;
                }   
?>

Edited by mike_2000_17: Fixed formatting

2
Contributors
4
Replies
5
Views
7 Years
Discussion Span
Last Post by kingfheartz
0

specify exactly what problem you are facing, error message, unexpected output or some thing like that.

0

specify exactly what problem you are facing, error message, unexpected output or some thing like that.

Parse error: syntax error, unexpected T_VARIABLE in C:\xampp\htdocs\Final\Upd_provsCRform.php on line 84

this error i am getting

0

Remove the red portion. The .(dot) and "(double quote)
It is not required.

$query="SELECT CRNo AS CR,DescriptionCR AS DCR FROM cr where Product='".$product."' ORDER BY CR".";
$result = mysql_query($query);
$i=0;
$numrows=0;

while($row = mysql_fetch_array($result))
{
$numrows=$i;

$i++;
}

Edited by urtrivedi: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.