PHP - Display Pages Monthly

Hi all,

I'm trying to make a webpage that allows the user to enter new sales figures for a certain product in a chosen month of a chosen year. I thought my code was correct but it doesn't really do anything. It just displays the table but it's not updated.

Can anybody spot an error?

Code: [Select]
   $describeQuery = "SELECT p.ID, p.NAME, dt.[Year], dt.[Month], dt.SalesVolume from Products p
join
(select ProductCode, sum(SalesVolume) as SalesVolume, [Month], [Year] from MonthlySales
 where [Year] = '$desiredYear' AND [Month] = '$desiredMonth'
 group by ProductCode, [Year], [Month])dt
on dt.ProductCode = p.ID";

$editQuery = "UPDATE MonthlySales SET SalesVolume = '$newSales'  WHERE Month ='$desiredMonth' AND Name = '$desiredProduct' AND Year = '$desiredYear'";

$results = sqlsrv_query($conn, $describeQuery);
$resultsx = sqlsrv_query($conn, $editQuery);

echo '<table border="1" BORDERCOLOR=Black>';
echo '<tr><th bgcolor = "LightBlue">Name</th><th bgcolor = "LightBlue" >ID</th> <th bgcolor = "LightBlue" >Sales</th><th bgcolor = "LightBlue" >Month</th> <th bgcolor = "LightBlue" >Year</th> </tr>';


while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC))
  {   
  echo '<tr>';
echo '<td >' .$row['NAME'].'</td>';             
echo '<td>' .$row['ID'].'</td>';
echo '<td>' .$row['SalesVolume'].'</td>';
echo '<td>' .$row['Month'].'</td>';
echo '<td>' .$row['Year'].'</td>';
echo '</tr>';
}

echo '</table>';

while($row = sqlsrv_fetch_array($resultsx, SQLSRV_FETCH_ASSOC))
  {
  }

sqlsrv_close($conn);

Hi everyone, 

I am a beginner web designer and a novice php user. I am a regular forum user and understand that you should always do a search and try to find the answer yourself but I have done that and didn't get any results (or I didn't understand them!).

So I ask for some assistance - either you can tell me the code or link me to the correct answer.

I am working on a website that I have built a enquiry form for and it has a php script for it. I have managed to get the form running properly and got the reCaptcha working correctly (with a custom error page) but I do not understand how to add custom error pages for incomplete email addresses, empty email addresses, or for a blank form? I tried using the same tactic I used for the reCaptcha error page but it didn't work - probably because I was guessing and just tried it in a bunch of different places.

The error msg that displays now is just a plain white page with the msg - Email address is invalid appearing at the top left.
While this is suitably functional it doesn't really look like much so I want to build a custom page for each error that could happen.

So the code is below - if anyone can point a beginner in the right direction I would be super happy.  :mrgreen:

if you need anymore code or other details just tell me and I will post them up.

The url of the form page is http://www.sunsolutionshomeimprovement.com/onlinesales.html

This is the code I think you will need - I got it from a demo php script that I have modified. As I said I don't have much clue what I'm doing so I just posted it exactly how it looks - if I over did it I apologize... :oops:

68.// Validate email field.
69.
70.if(isset($_REQUEST['email']) && !empty($_REQUEST['email']))
71.{
72.
73.if(preg_match("/(%0A|%0D|\n+|\r+|:)/i",$_REQUEST['email'])){$errors[] = "Email address may not contain a new line or
74.a colon";}
75.
76.$_REQUEST['email'] = trim($_REQUEST['email']);
77.
78.if(substr_count($_REQUEST['email'],"@") != 1 || stristr($_REQUEST['email']," ")){$errors[] = "Email address is invalid";}else{$exploded_email = explode("@",$_REQUEST['email']);if(empty($exploded_email[0]) || strlen($exploded_email[0]) > 64 || empty($exploded_email[1])){$errors[] = "Email address is invalid";}else{if(substr_count($exploded_email[1],".") == 0){$errors[] = "Email address is invalid";}else{$exploded_domain = explode(".",$exploded_email[1]);if(in_array("",$exploded_domain)){$errors[] = "Email address is invalid";}else{foreach($exploded_domain as $value){if(strlen($value) > 63 || !preg_match('/^[a-z0-9-]+$/i',$value)){$errors[] = "Email address is invalid"; break;}}}}}}
78.
79.)
80.
81.// Check referrer is from same site.
82.
83.if(!(isset($_SERVER['HTTP_REFERER']) && !empty($_SERVER['HTTP_REFERER']) && stristr($_SERVER['HTTP_REFERER'],$_SERVER['HTTP_HOST']))){$errors[] = "You must enable referrer logging to use the form";}
84.
85.// Check for a blank form.
86.
87.function recursive_array_check_blank($element_value)
88.(
89.
90.global $set;
91.
92.if(!is_array($element_value)){if(!empty($element_value)){$set = 1;}}
93.else
94.
95.
96.foreach($element_value as $value){if($set){break;} recursive_array_check_blank($value);}
97.
98.)
99.
100.)
101.
102.recursive_array_check_blank($_REQUEST);
103.
104.if(!$set){$errors[] = "You cannot send a blank form";}
105.
106.unset($set);
107.
108.// Display any errors and exit if errors exist.
109.
110.if(count($errors)){foreach($errors as $value){print "$value<br>";} exit;}
111.
112.if(!defined("PHP_EOL")){define("PHP_EOL", strtoupper(substr(PHP_OS,0,3) == "WIN") ? "\r\n" : "\n");}
113.
114.// Build message.

I don't think there is anymore that is relevant?

I just want to reiterate that I know nearly nothing about this stuff so if you could keep your answers simple it would help a lot - cheers!

I would like some tips on how to create a monthly archive for my weblog.
I am not using MySQL or any databases. Everything is saved on file.
 any tips or tutorials?

Thanks

  In the code below, I am trying to produce a google-like page where the user can type keywords
and pages of search results are displayed.
  The main difficulty I am encountering is that when the browser changes pages, it forgets everything about current data.    Perhaps I should include the display of pages inside the HTML form ? How can I fix this code ?
   Here is the contents of my searchpage.php file :

<?php



$keywords='';
$display_search_results='';

if(isset($_POST['search_submitted'])) {
    $keywords=$_POST['keywords'];
    $search_results=array();
    $totalNbrOfItems=20;
    for($k=1;$k<=$totalNbrOfItems;$k++) {
      $search_results[$k]='Your keywords '$keyowrds.' have been found in item number '.$k;
    }  

    $nbrOfItemsParPage = 5;
    $nbrOfPages = ceil($totalNbrOfItems / $nbrOfItemsParPage);
    // Compute current page
    $current_page = (isset($_GET['page']))?intval($_GET['page']):1;
    $display_pages=($nbrOfPages<2)?'<p>Page : ':'<p>Pages : ';
    for ($i = 1 ; $i <= $nbrOfPages ; $i++)
    {
        if ($i == $current_page) //No link to the current page
        {
            $display_pages=$display_pages.$i.' ';
        }
        else
        {
            $display_pages=$display_pages.'<a href="searchpage.php?'.
            'page='.$i.'">'.
            $i . '</a> ';
        }
    }
    $display_pages=$display_pages.'</p>';
    $display_items='';
    $start=$nbrOfItemsPerPage*($current_page-1);
    for($k=1;$k<=$nbrOfItemsParPage;$k++) {
      $display_items=$display_items.($search_results[$start+$k]).'<br>';
    }
    $display_search_results=$display_pages.$display_items;
}


echo '<form method="post" action="searchpage.php">'.
' Type your keywords here : <br><br>'.
'<textarea cols="65" rows="1" '.
'id="keywords_id" name="keywords">'.$keywords.'</textarea>'.
'<input type="submit" name="search_submitted" id="search_submitted_id" value="Search" /> '.
'</fieldset>'.
'</form>';

echo $display_search_results;

?>

like if I'm displaying a hundred entries , my website will be super long in length so I wanna break those hundred entries into maybe like 12 per page .  Then click next page or the page number to view the next 12.

Hello,

I was wondering if someone could help me to "get" the webaddress of a current webpage and then pull off pieces of the page.  All of my pages look like:

http://localhost:8888/algebra_book/Chapters/Quadratic_Functions/introductory_problem.php

BUT, the stuff to the left of Quadratic Functions WILL change in the future.  So all will look like:

*Quadratic_Functions/introductory_problem.php

Then, I'd like to pull off a $chapter variable, which in this case is Quadratic_Functions and a $page_name variable which in this case will be introductory_problem.

Thanks so much.

Hello everyone, this is my first post. This isn't just a simple post and leave, I'm looking to expand into this community and learn as much as I can. Well on to the problem at hand!

I decided to start with something simple as a login page and now want to expand it to make it fully functional.

Code: (index.html) [Select]
<html>
<head>
 <title>Deadnode.com</title>
 <LINK href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div style=width:150px;height:80px;position:absolute;left:40%;top:35%;
margin-left:-135px;margin-top:-50px;">

<div class="sidebox">
<div class="boxhead"><h2>Login Required</h2></div>
<div class="boxbody">
<form method="post" action="check.php">
<center><table>

<tr><td><font face="verdana,arial" size=-1>User:</td><td><input type="text" name="user"></td></tr>
<tr><td><font face="verdana,arial" size=-1>Pass:</td><td><input type="text" name="pwd"></td></tr>
<tr><td><font face="verdana,arial" size=-1>&nbsp;</td><td><font face="verdana,arial" size=-1><input type="submit" value="Login"></td></tr>
</table></center>
</form>
</div>

</div>
</body>
</html>

Code: (function.php) [Select]
<?php
function check() {
$admin="test";
$pass="test";
if ( $_POST["user"] == $admin & $_POST["pwd"] == $pass) {
  header('Location: output.php'); }
else {
  header('Location: index.html'); }
}
?>

Code: (check.php) [Select]
<?php
require('function.php');
check();
?>

This is just the code in it originally form; completely functional. I tried to use start_session() in my check() function. I know I should be using cookies, but I haven't gotten that far yet. Is it possible to use my check function as a way to block pages? I tried inserting the same code that is in check.php onto a html page, but I've had no luck with it redirecting back to my index.html page.

Hi,

Im trying to make pages switch.
Read data from database and but every 10 data in 1 pages.
I got my way on making pages by using PHP, but my way is not efficient.
 
Please teach me and tell me the correct way or concept to do it.
Or is there any website teaching this?

Appreciate for the help thanks.

Hey all,

I've a problem with including of my pages.
When I do choose lotto on index.php , I do get the page and also can choose how many roster I want.
But I can't see my lotto results, because it does refresh to the index.php again.
How can I fix this problem ?

this is the code of index.php:
Code: [Select]
<?php
        echo '<table class="achtergrond" border="1">';
        echo '<tr><td colspan="3">';
        /* Keuzelijst tonen */
        echo '<center><form action="'.$_SERVER['php_self'].'" method="POST"><select name="test">';
        echo '<option selected>Kies een formulier</option></center>';
        echo '<option value="1">Lotto</option>';
        echo '<option value="2">Euromillions</option>';
        echo '</select>';
        echo '<button type="submit" name="knop">OK</button>';
        echo '</form>';
        echo '</td></tr>';
            /* Als er op de knop gedrukt is , voer het lottoformulier uit*/
           if(isset($_POST['knop']))
           {
                  echo '<tr><td>';
                  echo $waarde;
                  /* variabel $waarde een waarde insteken via keuzelijst  */
                  switch($_POST['test'])
                  {
                      case 1;
                          include('formulieren/lotto.php');
                      case 2;
                          include('formulieren/euromillions.php');
                  }
                  echo '</td></tr>';
                  echo '</table>';

           }          
        ?>

and this is the code of lotto.php:
Code: [Select]
<?php
    echo '<table class="achtergrond">';
    echo '<tr><td colspan="3">';
    /* Keuzelijst tonen */
        echo '<center><form action="'.$_SERVER['php_self'].'" method="POST"><select name="lotto">';
        echo '<option selected>Kies aantal rooster</option></center>';
        echo '<option value="1">2 roosters</option>';
        echo '<option value="2">4 roosters</option>';
        echo '<option value="3">6 roosters</option>';
        echo '<option value="4">8 roosters</option>';
        echo '<option value="5">10 roosters</option>';
        echo '<option value="6">12 roosters</option>';
        echo '</select>';
        echo '<button type="submit" name="knop1">OK</button>';
        echo '</form>';
    echo '</td></tr>';
    /* Als er op de knop gedrukt is , voer het lottoformulier uit*/
   if(isset($_POST['knop1']))
   {
          /* variabel $waarde een waarde insteken via keuzelijst  */
          switch($_POST['lotto'])
          {
                case 0;
                   $waarde2 = 0;
                   break;
                case 1;
                   $waarde2 = 1;
                   break;
                case 2;
                   $waarde2 = 2;
                   break;
                case 3;
                   $waarde2 = 3;
                   break;
                case 4;
                   $waarde2 = 4;
                   break;
                case 5;
                   $waarde2 = 5;
                   break;
                case 6;
                   $waarde2 = 6;
                   break;
          }...

how to convert php pages to api

Hey, i was wondering if anyone knew how i could make a script so when i register a new account... There will be made a link in members.php and when you go there you see the new registered (and the old ones) name... And once you click it you get into their page (their page should be created when registering a new account).

Im pretty blank how to do it so ill ask you guys :/

How can I go about making dynamic pages?

eg. user types
"phpfreaks.com/index.php?page=name"

Hi, so....i have these 2 pages, but they don't show up in browser....can't find the error so will ask your help guys

index.php
<?php
session_start();
if(!isset($_SESSION["manager"])){
header("Location: admin_login.php");
exit();
}
//Be sure to check that manager SESSION value is in database
$managerID = preg_replace('#[^0-9]#i',",$_SESSION["id"]); // Filter everything but numbers and letters
$manager = preg_replace('#[^A-Za-z0-9]#i',",$_SESSION["manager"]); //Filter everything but numbers and letters
$password = preg_replace('#[^A-Za-z0-9]#i',",$_SESSION["password"]); //Filter everything but numbers and letters
//Run MySQL query to be sure that this person is an admin and that their password session var equals the database
//Connect to the MySQL Database
include("../storescripts/connect_to_mysql.php");
$sql = mysql_query("SELECT * FROM admin WHERE id='$managerID AND username='$manager' AND password='$password' LIMIT 1"); //search user
$existsCount = mysql_num_rows($sql); //count the row numbers
if ($existsCount == 0){ //evaluate the count
header("Location: ../index.php");
exit();
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>MyOnlineStore | Admin Area</title>
<link rel="stylesheet" href="../style/style.css" type="text/css" media="screen"/>
</head>

<body>
<div align="center" id="mainWrapper">
  <?php include_once("../template_header.php");?>
  <p><br  />
    <br />
  </p>
  <p>&nbsp;</p>
  <p><br />
  </p>
  <div id="pageContent">
    <div id="admin" align="left">
      <h3>Hello what you want to do?</h3>
      <p><a href="#">Manage Inventory</a><br />
      <a href="#">Manage afggagdfag</a></p>
</div>
</div>
<?php include_once("../template_footer.php");?>
</div>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>


admin_login.php
<?php
session_start();
if(!isset($_SESSION["manager"])){
header("Location: admin_login.php");
exit();
}
//Be sure to check that manager SESSION value is in database
$managerID = preg_replace('#[^0-9]#i',",$_SESSION["id"]); // Filter everything but numbers and letters
$manager = preg_replace('#[^A-Za-z0-9]#i',",$_SESSION["manager"]); //Filter everything but numbers and letters
$password = preg_replace('#[^A-Za-z0-9]#i',",$_SESSION["password"]); //Filter everything but numbers and letters
//Run MySQL query to be sure that this person is an admin and that their password session var equals the database
//Connect to the MySQL Database
include("../storescripts/connect_to_mysql.php");
$sql = mysql_query("SELECT * FROM admin WHERE id='$managerID AND username='$manager' AND password='$password' LIMIT 1"); //search user
$existsCount = mysql_num_rows($sql); //count the row numbers
if ($existsCount == 0){ //evaluate the count
header("Location: ../index.php");
exit();
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>MyOnlineStore | Admin Area</title>
<link rel="stylesheet" href="../style/style.css" type="text/css" media="screen"/>
</head>

<body>
<div align="center" id="mainWrapper">
  <?php include_once("../template_header.php");?>
  <p><br  />
    <br />
  </p>
  <p>&nbsp;</p>
  <p><br />
  </p>
  <div id="pageContent">
    <div id="admin" align="left">
      <h3>Hello what you want to do?</h3>
      <p><a href="#">Manage Inventory</a><br />
      <a href="#">Manage afggagdfag</a></p>
</div>
</div>
<?php include_once("../template_footer.php");?>
</div>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>

I want to use my form variables in other page which is not specified in action attribute. Please help me out !!! My code is below :   <body>

what I'm trying to do is to setup a page called settings.php that the admin runs to order to turn option in the web site on or off. I don't know how to do this since I never done this before. My code is below.


<link href="mainframe.css" rel="stylesheet" type="text/css">

<?php
require_once '../config.php';

$db = new DbConnector();
$db->DbConnector();


if(isset($_GET['submit'])) {

$db->query('UPDATE '.SETTING_TABLE.' SET option='.$_POST['banner'].' WHERE setname=''');

  echo 'Process complete';
}

$result = $db->query('SELECT * FROM '.SETTINGS_TABLE);

echo '<table border="1">';
echo '<tr>';

echo '<form action="settings.php" methed="post">';

while($row = $db->fetchArray($result))
  {
   
  echo '<tr>';
  echo '<td>'.$row['setname'].'</td><td><select size="1" name="'.$row['setname']'">';
  echo '<option value="on">on</option>';
  echo '<option value="off">off</option>';
  echo '</td>';  
  echo "</tr>";
  }
  echo '<td><input type="submit" value="Submit" name="submit">';
  echo '</td>';

echo "</tr>";
echo "</form>";
echo "</table>";

/*
*/

?>

<h2>Settings</h2>

<a href = "admin.php">Admin Panel</a>