PHP - Number Of Pages

Hello, I have problem durring binding update query. I can't find what is causing problem.

public function Update(Entry $e)
    {
        try
        {
            $query = "update entry set string = $e->string,delimiter=$e->delimiter where entryid= $e->id";
            $stmt = $this->db->mysqli->prepare($query);
            $stmt->bind_param('ssi',$e->string,$e->delimiter,$e->id);

            $stmt->close();
           

        }
        catch(Exception $ex)
        {
            print 'Error: ' .$ex->getMessage();
        }
    }

When I run function update I'm getting next error:Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement   Can you help me to solve this problem ?
Edited by danchi, 17 October 2014 - 10:25 AM.

I need to display a number(the number is retrieved from the db) in the form input field such that only the last 4 digits is visbile, the remaining can be masked as * or X or whatever is applicable.

I know the last 4 can be obtained as follows:

    Code: [Select]
$number=substr($number,-4,4);
 
But when i hit the submit button the form validates the input field and checks if the number is a valid number of a specific format.
Therefore when I click on the submit button then I should still be able to unmask the masked numbers or do something similar that would help me validate the whole number.

  Code: [Select]
  <input type="text" name="no" value="<?php if(!empty($number)){ echo $number;} ?>">

Hey

I have a string that looks like the following:
Quote

top-php-tutorials-2.html


I have a script that cycles through each page. The 2 in the quote above is the page number.

How can I extract the number between the - and the .html and replace it with another number?

I've tried
Code: [Select]
substr($engine->selectedcaturl, 0,-6).$v.".html"But then I realised this only works for numbers that are 1 digit long

Any input would be appreciated

hello,  i have a start time and an end time (no dates).  the following works great, except for when the start time is at night, and the end time is in the morning.  im thinking if i can do an if the number is negative, add 24, that it will resolve my issue.

any ideas?

Code: [Select]
$tbilled = $tfinish - $tstart;

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.

Hi,
I hope someone can help. I currently have a page that includes the main page after login, however I am looking into changing this so that when a user logs in they get 3/4 linked images that, when clicked dynamically load/include the page based on the select i.e. user selects the image laptop, that has a hyperlink, it loads the laptop page.

If anyone has any ideas or suggestion,i'd appreciate it.

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.

How can I go about making dynamic pages?

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

Hello everyone,

 I am new to this site and new to working with php. I am wondering about a code that i could use for splash pages for members to be able to use them. I have the splash pages set up already but have not been able to figure out how to code it so that all the members of the site can use them to promote the site.

 Any help would be great thanks.
Aaron

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>

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.

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;
          }...

Hi,

I am looking for reliable, effective code to cache one or two of my website webpages. I know there are packages like the pear cache lite but is far beyond my needs and complex in terms of never used pear before etc.

I am looking for a good cache class perhaps or a link to a good cache script. Does anyone have any code they would like to share or know of any good cache classes etc?

I want to keep it relatively simple if possible.

Thanks for any suggestions, help.
PHPLOVER

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 :/

Hi, can someone help me to understand this? What i want to do is to write some information in a form and after i submit the form that data will be in a new php page.

Thanks in advance