PHPBuilder.com http://www.phpbuilder.com/board This is a discussion forum for discussing all aspects of the serverside scripting language PHP en Fri, 18 May 2012 11:23:10 GMT vBulletin 60 http://board.phpbuilder.com/board/images/misc/rss.jpg PHPBuilder.com http://www.phpbuilder.com/board Id is not passing when clicking on the link http://www.phpbuilder.com/board/showthread.php?t=10384519&goto=newpost Fri, 18 May 2012 10:58:10 GMT >> http://localhost/metal/editchemical.php?id= if i type id infront of = mark it works perfectly. This is my code for veiwall.php page. Hope u guys will help me PHP: --------- '; echo 'alert("Please login as ADMINISTRATOR to edit a user");'; echo ''; } else include("config.php"); $tableName="chemical"; $targetpage = "view_all_chemical.php"; $limit = 5; $query = "SELECT COUNT(*) as num FROM $tableName"; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages = $total_pages[num]; $stages = 3; $page = mysql_escape_string($_GET['page']); if($page){ $start = ($page - 1) * $limit; }else{ $start = 0; } // Get page data $query1 = "SELECT generalname, Scientificname, quantity, reorder FROM $tableName LIMIT $start, $limit"; $result = mysql_query($query1); // Initial page num setup if ($page == 0){$page = 1;} $prev = $page - 1; $next = $page + 1; $lastpage = ceil($total_pages/$limit); $LastPagem1 = $lastpage - 1; $paginate = ''; if($lastpage > 1) { $paginate .= "
"; // Previous if ($page > 1){ $paginate.= "previous"; }else{ $paginate.= "previous"; } // Pages if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page){ $paginate.= "$counter"; }else{ $paginate.= "$counter";} } } elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few? { // Beginning only hide later pages if($page < 1 + ($stages * 2)) { for ($counter = 1; $counter < 4 + ($stages * 2); $counter++) { if ($counter == $page){ $paginate.= "$counter"; }else{ $paginate.= "$counter";} } $paginate.= "..."; $paginate.= "$LastPagem1"; $paginate.= "$lastpage"; } // Middle hide some front and some back elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2)) { $paginate.= "1"; $paginate.= "2"; $paginate.= "..."; for ($counter = $page - $stages; $counter <= $page + $stages; $counter++) { if ($counter == $page){ $paginate.= "$counter"; }else{ $paginate.= "$counter";} } $paginate.= "..."; $paginate.= "$LastPagem1"; $paginate.= "$lastpage"; } // End only hide early pages else { $paginate.= "1"; $paginate.= "2"; $paginate.= "..."; for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page){ $paginate.= "$counter"; }else{ $paginate.= "$counter";} } } } // Next if ($page < $counter - 1){ $paginate.= "next"; }else{ $paginate.= "next"; } $paginate.= "
"; } // get results from database // $result = mysql_query("SELECT * FROM members") // or die(mysql_error()); // display data in table echo ""; echo ""; // loop through results of database query, displaying them in the table while($row = mysql_fetch_array( $result )) { // echo out the contents of each row into a table echo ""; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; //echo ''; //echo ''; echo ""; } echo "
Name Code Quantity ReorderEditDeleteStock
' . $row['generalname'] . '' . $row['Scientificname'] . '' . $row['quantity'] . ''. $row['reorder'] . 'EditDeleteStockEditDelete
"; echo $paginate; ?> --------- This is the error it shows You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]]> hey need fast help on this matter. In my veiwall.php there are links to click and edit the items. But the problem is id isnot parsing when i click them. This is how it display when i click on edit link.
address bar shows >>> http://localhost/metal/editchemical.php?id=

if i type id infront of = mark it works perfectly. This is my code for veiwall.php page. Hope u guys will help me

PHP Code:
<?php
session_start();

if(!isset($_SESSION['SESS_LOGIN']) || $_SESSION['SESS_TYPE'] !='admin')  
{                                                                                 
  echo '<script language="javascript">';
  echo  'alert("Please login as ADMINISTRATOR to edit a user");';  
  echo  '</script>';                 

}
else

      include("config.php");
      
    $tableName="chemical";        
    $targetpage = "view_all_chemical.php";     
    $limit = 5;
    
    $query = "SELECT COUNT(*) as num FROM $tableName";
    $total_pages = mysql_fetch_array(mysql_query($query));
    $total_pages = $total_pages[num];
    
    $stages = 3;
    $page = mysql_escape_string($_GET['page']);
    if($page){
        $start = ($page - 1) * $limit;
    }else{
        $start = 0;    
        }    
    
    // Get page data
    $query1 = "SELECT generalname, Scientificname, quantity, reorder FROM $tableName LIMIT $start, $limit";
    $result = mysql_query($query1);
    
    // Initial page num setup
    if ($page == 0){$page = 1;}
    $prev = $page - 1;    
    $next = $page + 1;                            
    $lastpage = ceil($total_pages/$limit);        
    $LastPagem1 = $lastpage - 1;                    
    
    
    $paginate = '';
    if($lastpage > 1)
    {    
    

    
    
        $paginate .= "<div class='paginate'>";
        // Previous
        if ($page > 1){
            $paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
        }else{
            $paginate.= "<span class='disabled'>previous</span>";    }
            

        
        // Pages    
        if ($lastpage < 7 + ($stages * 2))    // Not enough pages to breaking it up
        {    
            for ($counter = 1; $counter <= $lastpage; $counter++)
            {
                if ($counter == $page){
                    $paginate.= "<span class='current'>$counter</span>";
                }else{
                    $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
            }
        }
        elseif($lastpage > 5 + ($stages * 2))    // Enough pages to hide a few?
        {
            // Beginning only hide later pages
            if($page < 1 + ($stages * 2))        
            {
                for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
                {
                    if ($counter == $page){
                        $paginate.= "<span class='current'>$counter</span>";
                    }else{
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
                }
                $paginate.= "...";
                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";        
            }
            // Middle hide some front and some back
            elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
            {
                $paginate.= "<a href='$targetpage?page=1'>1</a>";
                $paginate.= "<a href='$targetpage?page=2'>2</a>";
                $paginate.= "...";
                for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
                {
                    if ($counter == $page){
                        $paginate.= "<span class='current'>$counter</span>";
                    }else{
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
                }
                $paginate.= "...";
                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";        
            }
            // End only hide early pages
            else
            {
                $paginate.= "<a href='$targetpage?page=1'>1</a>";
                $paginate.= "<a href='$targetpage?page=2'>2</a>";
                $paginate.= "...";
                for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
                {
                    if ($counter == $page){
                        $paginate.= "<span class='current'>$counter</span>";
                    }else{
                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    
                }
            }
        }
                    
                // Next
        if ($page < $counter - 1){
            $paginate.= "<a href='$targetpage?page=$next'>next</a>";
        }else{
            $paginate.= "<span class='disabled'>next</span>";
            }
            
                
    $paginate.= "</div>";
    
}


// get results from database
     //   $result = mysql_query("SELECT * FROM members")
       //         or die(mysql_error());  
                
        // display data in table          
        echo "<table id='table'>";
        echo "<tr> <th>Name</th> <th>Code</th> <th>Quantity</th> <th>Reorder</th><th>Edit</th><th>Delete</th><th>Stock</th>  </tr>";

        // loop through results of database query, displaying them in the table
        while($row = mysql_fetch_array( $result ))
        {
                
                // echo out the contents of each row into a table
                echo "<tr>";
                echo '<td>' . $row['generalname'] . '</td>';
                echo '<td>' . $row['Scientificname'] . '</td>';
                echo '<td>' . $row['quantity'] . '</td>';
                echo '<td>'. $row['reorder'] . '</td>';
                echo '<td><a href="editchemical.php?id=' . $row['id'] . '">Edit</a></td>';
                echo '<td><a href="delete_chemical.php?id=' . $row['id'] . '">Delete</a></td>';
                echo '<td><a href="stock_chemical.php?id=' . $row['id'] . '">Stock</a></td>';
                //echo '<td><a href="edituser.php?id=' . $row['id'] . '">Edit</a></td>';
                //echo '<td><a href="delete_user.php?id=' . $row['id'] . '">Delete</a></td>';
                echo "</tr>";
                    
        }
       echo "</table>";
echo $paginate;
        
    ?>

This is the error it shows
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ]]> Coding vidz http://www.phpbuilder.com/board/showthread.php?t=10384519 Naming convestion for the .xlsx file http://www.phpbuilder.com/board/showthread.php?t=10384518&goto=newpost Fri, 18 May 2012 10:30:57 GMT (right angle bracket) | (pipe) you can read the dcument Here (http://www.uwsuper.edu/technology/help/tips/upload/NamingFiles.pdf) so what should I use in place of that i don't want to use underscore and don't want to use the timestamp the time should be in common man readable form any suggestion will be appreciated]]> The colon is not working in the name of .xlsx file
when I use it without colon is fine but when i add colon I get don't get my excel fil generated
I am adding this colon to show time at which it has being generated
PHP Code:
$created = date('d-m-Y H:i:s', time());
$file_path = $file_path.$result_group["correct_label"]."_".$created.".xlsx";
how ever I read the document that tell u should avoid this
\ (backslash)
/ (forward slash)
: (colon)
* (asterisk),
? (question mark)
" (double quotes)
< (left angle bracket)
>(right angle bracket)
| (pipe)
you can read the dcument Here

so what should I use in place of that i don't want to use underscore
and don't want to use the timestamp the time should be in common man readable form
any suggestion will be appreciated ]]> General Help vivek151189 http://www.phpbuilder.com/board/showthread.php?t=10384518 <![CDATA[[RESOLVED] random order within category based on day of month]]> http://www.phpbuilder.com/board/showthread.php?t=10384517&goto=newpost Fri, 18 May 2012 09:40:07 GMT Hello
I want to order my db results randomly between three categories, so everything in category one will always appear above category two, etc.

Here is the code I have, which is working fine:

PHP Code:
$query = "SELECT car, model FROM (SELECT * FROM cars ORDER BY RAND()) AS t ORDER BY orderno DESC";
where orderno is the field containing the category numbers 1, 2, or 3. However, I have pagination, so I only want the randomness to be changed daily. How can I add a fixed number, like day of the month, to make sure the ordering is only updated once a day?

Many thanks for any suggestions! ]]> Database etoast http://www.phpbuilder.com/board/showthread.php?t=10384517 find average?? http://www.phpbuilder.com/board/showthread.php?t=10384516&goto=newpost Fri, 18 May 2012 03:22:20 GMT
nis name class math english physics average
_________________________________________________________ how script for find average?? please help me?]]> i have php script:
<html>
<body>
<?php
$conn = mysql_connect("localhost","root","");
mysql_select_db("experiment",$conn);
$sql = "select * from student inner join study where student.nis=study.nis;
$result = mysql_query($sql) or die(mysql_error());

$average = ????

?>
<table cellpadding="7" cellspacing="0" border="1">
<tr>
<th>nis</th>
<th>name</th>
<th>class</th>
<th>math</th>
<th>english</th>
<th>physics</th>
<th>average</th>
</tr>

<?php while($val = mysql_fetch_array($result)){?>
<tr>
<td><?php echo $val['nis'];?></td>
<td><?php echo $val['name'];?></td>
<td><?php echo $val['class'];?></td>
<td><?php echo $val['math'];?></td>
<td><?php echo $val['english'];?></td>
<td><?php echo $val['physics'];?></td>
<td><?php echo ????? ;?></td>
</tr>
<?php }?>
</table>
</body>
</html>
_________________________________________________________

how script for find average??
please help me? ]]> Newbies hasan_alghazi http://www.phpbuilder.com/board/showthread.php?t=10384516 <![CDATA[My sytax is being complained about, but I don't know why.]]> http://www.phpbuilder.com/board/showthread.php?t=10384515&goto=newpost Fri, 18 May 2012 01:55:10 GMT
" . mysql_error()); --------- Which worked fine until I added this: ---Quote--- , key = '$current_key' ---End Quote--- When I added that, the statement broke and I get this: ---Quote--- Failed to update member in the database. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key = '146451373' WHERE name = 'Govannin'' at line 1 ---End Quote--- Can someone tell me what I did wrong?]]> Hi there guys,

Here's my statement:

Code:
mysql_query("UPDATE addon_guild_members SET gender = '$mgender', level = '$mlevel', race = '$mrace', class = '$mclass', rank = '$mrank', last_time = NOW(), active = '1', key = '$current_key'  WHERE name = '$mname'") or die("Failed to update member in the database.<br><br>" . mysql_error());
Which worked fine until I added this:

Quote:
, key = '$current_key'
When I added that, the statement broke and I get this:

Quote:
Failed to update member in the database.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key = '146451373' WHERE name = 'Govannin'' at line 1
Can someone tell me what I did wrong? ]]> Database schwim http://www.phpbuilder.com/board/showthread.php?t=10384515 jquery with php http://www.phpbuilder.com/board/showthread.php?t=10384514&goto=newpost Fri, 18 May 2012 01:53:07 GMT post_title; $date = date('M-d-Y H:i:s e',strtotime($item->post_date)); echo ''; echo ''; echo '' . $title . ''; echo '' . $date . ''; echo ''; return $csv_output .= $title . ', ' . $date . "\n"; // only return this if ckbox is checked } --------- this creates a table with a checkbox. i want the user to be able to check the checkbox and if it's checked return the last line - return $csv_output... when i add jquery or just the script tags to it, the table only returns 1 row and looks funny... any suggestions? thanks!]]> I have a function which creates a table dynamically:
PHP Code:
function create_table($item) {
    $title = $item->post_title;
    $date = date('M-d-Y H:i:s e',strtotime($item->post_date));
    echo '<tr>';
    echo '<td><input type="checkbox" /></td>';
    echo '<td>' . $title . '</td>';
    echo '<td>' . $date . '</td>';
    echo  '</tr>';
    return $csv_output .=  $title . ', ' . $date .  "\n"; // only return this if ckbox is checked
}
this creates a table with a checkbox. i want the user to be able to check the checkbox and if it's checked return the last line - return $csv_output...
when i add jquery or just the script tags to it, the table only returns 1 row and looks funny...

any suggestions?

thanks! ]]> Newbies fxpepper http://www.phpbuilder.com/board/showthread.php?t=10384514 how make table http://www.phpbuilder.com/board/showthread.php?t=10384513&goto=newpost Thu, 17 May 2012 23:47:03 GMT I have a problem with the table. for example. 1. test 5 times 2. 3 subjects (math, English, physics) 3. grade 3 pieces (A, B, C) 4. identity (id, name, grade, gender) how to create a table of the above problems, including primary and foreign keys. please help me!!! I have a problem with the table.
for example.
1. test 5 times
2. 3 subjects (math, English, physics)
3. grade 3 pieces (A, B, C)
4. identity (id, name, grade, gender)
how to create a table of the above problems, including primary and foreign keys.
please help me!!! ]]> Newbies hasan_alghazi http://www.phpbuilder.com/board/showthread.php?t=10384513 Need help determining time difference http://www.phpbuilder.com/board/showthread.php?t=10384512&goto=newpost Thu, 17 May 2012 22:01:14 GMT ' . $query); $result_rows = mysql_num_rows($result); if($result_rows==0){ //Danger, Will Robinson! No data found in db for cron! echo(" Error: Cron time missing for roster_update. "); }else{ //Grab the last run time for roster_update $result = mysql_query ($query); while ($row = mysql_fetch_assoc ($result)) { $roster_update = strtotime($row['roster_update']); $cur_time = strtotime($row['cur_time']); echo $roster_update."
".$cur_time."
"; if($cur_time >= ($roster_update+(60*60))){ echo("

Over 60 minutes.

"); }else{ // Time is under one hour. echo("

under 60 minutes.

"); } } } ?> --------- I've set the database time four hours in the past and it's still telling me that it's under an hour. Could someone tell me how To get this to work? Thanks a bunch for your time!]]> Hi there guys,

I'm trying very hard to figure out a way to determine whether current time is 60 minutes past a stored time. I am having a horrible time. Here's what I've got:

PHP Code:
<?php

include("./includes/header.php");

//Check to see whether cron needs to run.
$query = "SELECT DATE_format(roster_update, '%b %d %Y %h:%i %p') as roster_update, DATE_format(NOW(), '%b %d %Y %h:%i %p') as cur_time FROM addon_cron";
$result = mysql_query ($query) or die('MySQL error: ' . mysql_error() . '<hr/>' . $query);
$result_rows = mysql_num_rows($result);
if($result_rows==0){

    //Danger, Will Robinson!  No data found in db for cron!
    echo("
    Error: Cron time missing for roster_update.
    ");

}else{

    //Grab the last run time for roster_update
    $result = mysql_query ($query);
    while ($row = mysql_fetch_assoc ($result)) {
        $roster_update = strtotime($row['roster_update']);
        $cur_time = strtotime($row['cur_time']);        
        
        echo $roster_update."<br />".$cur_time."<br />";
        
        if($cur_time >= ($roster_update+(60*60))){

            echo("<p align='center'>Over 60 minutes.</p>");
            
            
        }else{
        
        // Time is under one hour.
        echo("<p align='center'>under 60 minutes.</p>");
        
        }
    }
}

?>
I've set the database time four hours in the past and it's still telling me that it's under an hour.

Could someone tell me how To get this to work?

Thanks a bunch for your time! ]]> Coding schwim http://www.phpbuilder.com/board/showthread.php?t=10384512 <![CDATA[[RESOLVED] Truncate text to display only 20 characters]]> http://www.phpbuilder.com/board/showthread.php?t=10384511&goto=newpost Thu, 17 May 2012 21:44:49 GMT tag that uses .php to display titles. This

tag only has enough space to display one line of text. Sometimes the title is too long to fit and the title goes into two lines. I would like to truncate the text after 20 characters. Is there an easy way to do this? Here is the code: Code: ---------

htmlLink($cause->getHref(), $cause->getTitle()) ?>

--------- Thank you, Ken]]> Hello,

I have a <h3> tag that uses .php to display titles. This <h3> tag only has enough space to display one line of text. Sometimes the title is too long to fit and the title goes into two lines. I would like to truncate the text after 20 characters. Is there an easy way to do this? Here is the code:

Code:
<h3><?php echo $this->htmlLink($cause->getHref(), $cause->getTitle()) ?></h3>
Thank you,
Ken ]]> Newbies khong http://www.phpbuilder.com/board/showthread.php?t=10384511 <![CDATA[[RESOLVED] How to show dropdown list value in edit item form]]> http://www.phpbuilder.com/board/showthread.php?t=10384510&goto=newpost Thu, 17 May 2012 21:40:54 GMT Iam working on edit script. My problem is how to drop down list's current value(value from the db) and this should be shown in drop down list. Because it should be editable. Iam ok with showing values in text fiels and all. ]]> Coding vidz http://www.phpbuilder.com/board/showthread.php?t=10384510 Query using Date http://www.phpbuilder.com/board/showthread.php?t=10384508&goto=newpost Thu, 17 May 2012 16:48:43 GMT =7 AND date <=13 Variable =.10 also keep going with it IF date >=14 AND date <=20 Variable =.20 What i cant figure out is how to count how many days away date is from the curdate so if Date=2012-04-20 I wanna know how to count how many days that is from curdate Now im pretty sure I can figure out how to do this if someone can help me in counting days date is from today.]]> What I wanna do is update a field in a row based on the date.

UPDATE tabe SET field=field-field*variable WHERE date


What i cant figure out how to do is count days if date >=7 AND date <=13 Variable =.10 also keep going with it IF date >=14 AND date <=20 Variable =.20

What i cant figure out is how to count how many days away date is from the curdate

so if Date=2012-04-20 I wanna know how to count how many days that is from curdate

Now im pretty sure I can figure out how to do this if someone can help me in counting days date is from today. ]]> Database Mark Nordstrom http://www.phpbuilder.com/board/showthread.php?t=10384508 How to send values from a Calendar? http://www.phpbuilder.com/board/showthread.php?t=10384507&goto=newpost Thu, 17 May 2012 14:17:34 GMT function somma_valori(form) { var elementi = form.elements.length; var somma = 0; for(var i = 0; i < elementi; i++){ if(form.elements[i].name != "invia") { var valore = parseInt(form.elements[i].value); if(isNaN(valore)) valore = 0; somma = somma + valore; } } document.getElementById('somma').innerHTML = somma } " . $mese[($month - 1)] . ""; echo ""; echo ""; echo ""; $g = $primo_del_mese; for ($i = 1; $i <= $giorni_nel_mese; $i++) { $classe = ""; if ($giorni_settimana[$g] == "Dom") { $classe = " class=\"dom\""; } elseif ($giorni_settimana[$g] == "Sab") { $classe = " class=\"sab\""; } echo ""; if ($g == 7) { $g = 1; } else { $g++; } } echo ""; echo ""; for ($i = 1; $i <= $giorni_nel_mese; $i++) { $classe = ""; if ($i == $oggi) { $classe = " class=\"oggi\""; } echo ""; } echo ""; echo ""; for ($i = 1; $i <= $giorni_nel_mese; $i++) { echo "\n"; } echo ""; echo ""; echo ""; echo ""; echo ""; echo "
" . $giorni_settimana[$g] . "
$i
"; echo "Totale : 0  "; echo " "; echo "
"; ?> --------- reports.pgp PHP: --------- "; echo ""; $g = $primo_del_mese; for ($i = 1; $i <= $giorni_nel_mese; $i++) { echo "" . $giorni_settimana[$g] . ""; if ($g == 7) { $g = 1; } else { $g++; } } echo ""; echo ""; for ($i = 1; $i <= $giorni_nel_mese; $i++) { echo "$i"; } echo ""; echo ""; unset($_POST['invia']); foreach ($_POST as $key => $value) { (int) $value; if ($value != 0) { echo $key . "->" . $value . "
"; } } ?> --------- ]]> Hello everybody, I would make sure that the numeric values ​​included in the file "index.php" will be sent to "report.php" and then can not be changed.


Thanks

Like this: http://thaypan.altervista.org/Time_T...Management.png

index.php

PHP Code:
    <script type="text/javascript">
        function somma_valori(form) {       
            var elementi = form.elements.length;
            var somma = 0;
            for(var i = 0; i < elementi; i++){
                if(form.elements[i].name != "invia") {
                    var valore = parseInt(form.elements[i].value);
                    if(isNaN(valore))
                        valore = 0;               
                    somma = somma + valore;
                }
            }
            document.getElementById('somma').innerHTML = somma
        }
    </script>
    <style type="text/css">
        table{
            font-family:Arial, Helvetica, sans-serif;
            font-size:12px;
            text-align:center;
            background-color:#F1F1F1;
        }
        .dom{
            background-color:#FF6600;
        }
        .sab{
            background-color: #FFFFCC;
        }
        .oggi{
            border-width:2px;
            border-color: #009900;
            border-style:solid;
            font-weight:bold;
        }
        .me{
            font-family:Arial, Helvetica, sans-serif;
            font-size:14px;
            font-weight:bold;
        }
    </style>
    <?php
    $month = date('m');
    $year = date('Y');
    $oggi = date("d") + 0;
    $giorni_settimana = array(1, "Lun", "Mar", "Mer", "Gio", "Ven", "Sab", "Dom");
    $mese = array('Gennaio', 'Febbraio', 'Marzo', 'Aprile', 'Maggio', 'Giugno', 'Luglio', 'Agosto', 'Settembre', 'Ottobre', 'Novembre', 'Dicembre');
    $time_primo_del_mese = mktime(0, 0, 0, $month, 1, $year);
    $primo_del_mese = date('w', $time_primo_del_mese);
    $giorni_nel_mese = cal_days_in_month(CAL_GREGORIAN, $month, $year);
    echo "<span class=\"me\">" . $mese[($month - 1)] . "</span>";


    echo "<table border='1'>";
    echo "<form action='reports.php' method='post'>";
    echo "<tr>";
    $g = $primo_del_mese;
    for ($i = 1; $i <= $giorni_nel_mese; $i++) {
        $classe = "";
        if ($giorni_settimana[$g] == "Dom") {
            $classe = " class=\"dom\"";
        } elseif ($giorni_settimana[$g] == "Sab") {
            $classe = " class=\"sab\"";
        }
        echo "<td $classe>" . $giorni_settimana[$g] . "</td>";
        if ($g == 7) {
            $g = 1;
        } else {
            $g++;
        }
    }
    echo "</tr>";
    echo "<tr>";
    for ($i = 1; $i <= $giorni_nel_mese; $i++) {
        $classe = "";
        if ($i == $oggi) {
            $classe = " class=\"oggi\"";
        }
        echo "<td $classe>$i</td>";
    }
    echo "</tr>";
    echo "<tr>";
    for ($i = 1; $i <= $giorni_nel_mese; $i++) {
        echo "<td><input type='text' onkeyup='somma_valori(this.form)' size='1' name='" . $year . "-" . $month . "-" . $i . "'/></td>\n";
    }
    echo "</tr>";
    echo "<tr>";
    echo "<td colspan='$i'>";
    echo "Totale : <span id='somma'>0</span> &nbsp;";
    echo "&nbsp;<input type='submit' name='invia' value='Invia'/>";
    echo "</td>";
    echo "</tr>";
    echo "</form>";
    echo "</table>";
    ?>
reports.pgp

PHP Code:
    <?php

    $month = date('m');
    $year = date('Y');

    $giorni_settimana = array(1, "Lun", "Mar", "Mer", "Gio", "Ven", "Sab", "Dom");

    $time_primo_del_mese = mktime(0, 0, 0, $month, 1, $year);
    $primo_del_mese = date('w', $time_primo_del_mese);

    $giorni_nel_mese = cal_days_in_month(CAL_GREGORIAN, $month, $year);

    echo "<table border='1'>";
    echo "<tr>";
    $g = $primo_del_mese;
    for ($i = 1; $i <= $giorni_nel_mese; $i++) {
        echo "<td>" . $giorni_settimana[$g] . "</td>";
        if ($g == 7) {
            $g = 1;
        } else {
            $g++;
        }
    }
    echo "</tr>";
    echo "<tr>";
    for ($i = 1; $i <= $giorni_nel_mese; $i++) {
        echo "<td>$i</td>";
    }
    echo "</tr>";
    echo "</table>";

    unset($_POST['invia']);
    foreach ($_POST as $key => $value) {
        (int) $value;

        if ($value != 0) {
            echo $key . "->" . $value . "<br/>";
        }
    }
    ?>
]]> Coding thaypan http://www.phpbuilder.com/board/showthread.php?t=10384507 $row entry to variable to form submission and retrieval http://www.phpbuilder.com/board/showthread.php?t=10384506&goto=newpost Thu, 17 May 2012 13:59:00 GMT parameter in the form so that each field generated has a unique value, you with me so far? So to confirm I have a form that the user fills out and it has two hidden fields that are automatically given random values when submitted to the database. This is then retrieved on another page and the random values are assigned to the name value in another form. I want the user to fill out this form and have each value submitted to another page and shown. I shall post my code and if anyone could help me with this issue I would be most grateful. Thank you! Form in which the data from the database is assigned to the name tag: PHP: ---------
"; echo""; echo""; echo""; echo""; } echo ""; mysql_close($con); ?>
"; echo"

"; echo $row["title"]; echo " - £"; echo $row["price"]; echo"
"; echo"". $row['subtext'] . ""; echo"

"; echo"		"; echo""; echo""; echo""; echo"
--------- How would I go about taking the values randomly generated and get them to be an actual name value, so that the information typed into the form can be passed properly from one form to the next, I have tried variables and sessions and im getting no errors, but nothing displays results wise, so I dont know what im doing wrong.]]> Hi, Im at a standstill.

I have a MYSQL database which has a name and amount field that automatically generates a random number when the details get uploaded via form and submitted. The information is then displayed on another and the values generated are assigned to the <name> parameter in the form so that each field generated has a unique value, you with me so far?

So to confirm I have a form that the user fills out and it has two hidden fields that are automatically given random values when submitted to the database. This is then retrieved on another page and the random values are assigned to the name value in another form.

I want the user to fill out this form and have each value submitted to another page and shown.

I shall post my code and if anyone could help me with this issue I would be most grateful. Thank you!

Form in which the data from the database is assigned to the name tag:

PHP Code:
                       <form method="post" action="step4.php">
         <table class="food">
         <?php
         
         $con = mysql_connect("database details");
         if (!$con)
           {
           die('Could not connect: ' . mysql_error());
           }

         mysql_select_db("catering", $con);

         $result= mysql_query("SELECT * FROM starters WHERE category='meat'");
         
         while($row = mysql_fetch_array($result))
         {
         
         echo"<tr>";
         echo"<td>";
         echo"<p class=\"form2\">";
         echo $row["title"];
         echo " - £";
         echo $row["price"];
         echo"<br>";
         echo"<span class=\"subtext\">". $row['subtext'] . "</span>";
         echo"</p>";
         echo"</td>";
         echo"<td class=\"addon\">";
         echo"<input type=\"checkbox\" class=\"largecheckbox\" name=". $row['nameid'] .">";
         echo"</td>";
         echo"<td class=\"addon\">";
         echo"<input type=\"text\" class=\"amount\" name=". $row['amountid'] .">";
         echo"</td>";
         echo"</tr>";
         }
         echo "";
         
         mysql_close($con);
         ?>
         
         </table>
         </div>
      
      <div id="bottom">
         <div id="build"></div>
         <div id="backbutt"><a href="step2.html"><img src="./images/prevbutt.png"></a></div>
         <div id="nextbutt"><input type="image" src="./images/nextbutt.png"></div>
         </form>
         </div>
      </div>
      
      <div id="footer">
      <p class="footer">Mistrys Catering | 01234 567 890 | example@example.com</p>
      </div>
      
   </div>
</body>
</html>
How would I go about taking the values randomly generated and get them to be an actual name value, so that the information typed into the form can be passed properly from one form to the next, I have tried variables and sessions and im getting no errors, but nothing displays results wise, so I dont know what im doing wrong. ]]> Newbies uncaringuser http://www.phpbuilder.com/board/showthread.php?t=10384506 Logging Visitor’s IP http://www.phpbuilder.com/board/showthread.php?t=10384505&goto=newpost Thu, 17 May 2012 10:39:45 GMT Hi All,

I'm new to the PHP Builder and i'm hoping someone can help me.

Basically I have a website and want to record some of my visitors details for potential marketing purposes I found an example script online from ...
http://tournasdimitrios1.wordpress.c.../#comment-1046


However when I try and test this (see attachment) it does not function.
PHP is enabled on the server as I have PHP feedback forms already running which are working fine.

When I open the log file in notepadd++ it does not appear to highlight, i'm worried why its not recognising it as PHP. I double checked and wrote some PHP on a new page and it worked fine so i'm a bit confused as to what to do. Can anyone please help, i'm sure its something ridiculous i'm not seeing.

Thank you for your time
Attached Files
File Type: zip Test.zip (1.0 KB)
]]> Newbies swiss123 http://www.phpbuilder.com/board/showthread.php?t=10384505 Decode eval(base64_decode) http://www.phpbuilder.com/board/showthread.php?t=10384504&goto=newpost Thu, 17 May 2012 09:44:45 GMT >]]> Hi

pleas decode

<<removed by moderator>> ]]> Coding koorosh2004 http://www.phpbuilder.com/board/showthread.php?t=10384504