PHP - How To Fix "where Clause Is Ambiguous" Error!!

Hi guys

I'm struggling a bit, I need to replace a word that occurs multiple times in text with an array("up","down","forward","backwards") of words.


$find = "left";
$replace = array("up","down","forward","backwards");
$text = "left left left left";

echo str_replace($find,$replace,$text);


The Output is: array array array array

Did try this with a foreach statement as well, but no luck. Is there a better way of doing this? 

Thanks

Hello, i got a problem with my codes, it says  Parse error: syntax error, unexpected token "endwhile" . Please help me, Here's my code:
 

<?php
                    include "connection.php";
                    
                    if(isset($_POST['submit'])){
                        $from= $_POST['fromdate'];
                        $to= $_POST['todate'];
                        $result = $conn->query("SELECT * FROM tbl_employee WHERE tbl_hiringdate BETWEEN '$from' and '$to'");

                        while($rows=mysqli_fetch_array($result));
                ?>    
                
                <tr style="color:white; text-align:center">
                        <td><?php echo $rows['tbl_id'];?></td>
                        <td><?php echo $rows['tbl_name'];?></td>
                        <td><?php echo $rows['tbl_surname'];?></td>
                        <td><?php echo $rows['tbl_maidenname'];?></td>
                        <td><?php echo $rows['tbl_fathername'];?></td>
                        <td><?php echo $rows['tbl_mothername'];?></td>
                        <td><?php echo $rows['tbl_birthplace'];?></td>
                        <td><?php echo $rows['tbl_bday'];?></td>
                        <td><?php echo $rows['tbl_sex'];?></td>
                        <td><?php echo $rows['tbl_drive'];?></td>
                        <td><?php echo $rows['tbl_marital'];?></td>
                        <td><?php echo $rows['tbl_nationality'];?></td>
                        <td><?php echo $rows['tbl_military'];?></td>
                        <td><?php echo $rows['tbl_disability'];?></td>
                        <td><?php echo $rows['tbl_blood'];?></td>
                        <td><?php echo $rows['tbl_companyname'];?></td>
                        <td><?php echo $rows['tbl_homeaddress'];?></td>
                        <td><?php echo $rows['tbl_homephone'];?></td>
                        <td><?php echo $rows['tbl_mobilephone'];?></td>
                        <td><?php echo $rows['tbl_email'];?></td>
                        <td><?php echo $rows['tbl_profession'];?></td>
                        <td><?php echo $rows['tbl_experience'];?></td>
                        <td><?php echo $rows['tbl_school'];?></td>
                        <td><?php echo $rows['tbl_department'];?></td>
                        <td><?php echo $rows['tbl_hireddepartment'];?></td>
                        <td><?php echo $rows['tbl_hiringdate'];?></td>
                        <td><?php echo $rows['tbl_contactname'];?></td>
                        <td><?php echo $rows['tbl_contactaddress'];?></td>
                        <td><?php echo $rows['tbl_contactphone'];?></td>
                        <td><?php echo $rows['tbl_contactemail'];?></td>
                        <td><?php echo $rows['tbl_relation'];?></td>
                        <td><?php echo $rows['tbl_position'];?></td>
                        <td><?php echo $rows['tbl_jobdescription'];?></td>
                        <td><?php echo $rows['tbl_rate'];?></td>
                        <td><?php echo $rows['tbl_building'];?></td>
                        <td><a href="update.php?id=<?php echo $rows['tbl_id'];?>"><button type="submit" name="update" class="btn btn-dark btn-md">Update</button><br><br>
                        <a href="delete.php?id=<?php echo $rows['tbl_id'];?>"><button type="submit" name="delete" class="btn btn-dark btn-md">Delete</button></td>
                </tr>
                    <?php endwhile;
                    } 
                    ?>

This topic has been moved to Linux.

http://www.phpfreaks.com/forums/index.php?topic=318175.0

This topic has been moved to PHP Installation & Configuration.

http://www.phpfreaks.com/forums/index.php?topic=347922.0

Hi, I currently have an if, elseif, else program that starts off with

Code: [Select]
if( $v_name == "" || $v_msg == "" )
echo "something"
how do I turn this into a switch?

but the very next elseif I have

Code: [Select]
elseif( strcspn( $_REQUEST['msg'], '0123456789' ) == strlen( $_REQUEST['msg'] ) )
echo "something"

is it possible to turn this into a switch with 2 different strings like that to evaluate?

I have a registration form on my website and after Registration I want the user to activate first his account. I don't have problem on sending this email to the user. What I want to appear is like this..

GoodDay "username",

Blah Blah!

how can you actually do that? I know that you can do that through session variables but the thing is email's can't accept scripts on sending emails. how can I get the value from a session variable for example and convert it to plain html text so that i can OUTPUT it to the email.. HELP PLEASE!

Hello!

I have the following php code:

Code: [Select]
<?php
// The message
$message =
"[request("Id_From")]\n
[request("ID")]\n
[request("CUT")]\n
[request("MAKE")]\n
[request("CARAT")]\n
[request("PRICE_PC")]\n
[request("CLARITY")]\n
[request("LOCATION")]\n
[request("CERTIFICATE")]\n
[request("SUP_STOCK_REF")]\n
[request("Measurements")]\n
[request("Total_Depth")]\n
[request("Polish")]\n
[request("Table_Width")]\n
[request("Symmetry")]\n
[request("Crown_Height")]\n
[request("Culet")]\n
[request("Parillion_Depth")]\n
[request("Graining")]\n
[request("Girdle")]\n
[request("Remarks")]\n
[request("TotalPrice")]";

// In case any of our lines are larger than 70 characters, we should use wordwrap()
$message = wordwrap($message, 70);

// Send
mail('gary.impact@gmail.com', 'HIGH PRIORITY DIAMOND ORDER!', $message);
?>

where I am trying to send an email to myself which will send me the listed 'requested' values.  These values are to the script in the form of:

Code: [Select]
http://www.somedomain.com/somepage.html?Id_From=123&ID=50250430&CUT=Round&MAKE=VG+-+G++++&CARAT=.5&PRICE_PC=5719&COLOR=D&CLARITY=VVS1&LOCATION=California+%28U.S.A.%29&CERTIFICATE=GIA&SUP_STOCK_REF=3540-6&Measurements=5.03x5.08x3.17&Total_Depth=62.7%25&Polish=V.good&Table_Width=60%25&Symmetry=Good&Crown_Height=&Culet=None&Parillion_Depth=&Graining=&Girdle=&Fluorescence=None&Remarks=&TotalPrice=2860
I am getting the error:

Code: [Select]
Parse error: syntax error, unexpected T_STRING
Which starts on the first line of my requested data ("[request("Id_From")]\n).

Any help on this would be truely appreciated!

Thank you!

Hello all, I'm an amateur at PHP coding, and am currently enrolled in a PHP and MySQL class that uses the PHP Programming with MySQL textbook, by Don Gosselin. I'm trying to get this simple Shopping Cart script to work, because it's the step-by-step example script for Chapter 11, but I keep getting the following errors on ShowCart.php when I try to add an item to the cart. Quote

Warning: mysqli_query() [function.mysqli-query]: Couldn't fetch mysqli in C:\xampplite\htdocs\ShoppingCart.php  on line 78

Warning: mysqli_errno() [function.mysqli-errno]: Couldn't fetch mysqli in C:\xampplite\htdocs\ShoppingCart.php on line 80

Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch mysqli in C:\xampplite\htdocs\ShoppingCart.php on line 81


Line 78:        $QueryResult = mysqli_query($this->DBConnect, $SQLstring)

Line 80 and 81:             . "<p>Error code " . mysqli_errno($this->DBConnect)
            . ": " . mysqli_error($this->DBConnect)) . "</p>";

I've read "Couldn't fetch mysqli" errors are because the connection was closed prior to those lines, but I don't see any indication of a connection closure. I have no idea what to do, as all the code was given to me in the book, I merely copied it down.

Here's the ShoppingCart.php code:<?php
class ShoppingCart {
    private $DBConnect = "";
    private $DBName = "";
    private $TableName = "";
    private $Orders = array();
    private $OrderTables = array();
function construct() {
    $this->DBConnect = mysqli_connect("localhost", "root", "passHere");
    if (mysqli_connecT_errno())
        die("<p>Unable to connect to the database server.</p>"
        . "<p>Error code " . mysqli_connect_errno()
        . ": " . mysqli_connect_error()) . "</p>";
}

public function setDatabase($Database) {
    $this->DBName = $Database;
    $this->DBConnect->select_db($this->DBName)
        Or die("<p>Unable to select the databbase.</p>"
        . "<p>Error code " . mysqli_errno($this->DBConnect)
        . ": " . mysqli_error($this->DBConnect)) . "</p>";
}
public function setTable($Table) {echo $table."<br />";
    $this->TableName = $Table;
}
public function getProductList() {
    $SQLstring = "SELECT * FROM $this->TableName";
    $QueryResult = $this->DBConnect->query($SQLstring)
        Or die("<p>Error code " . mysqli_errno($this->DBConnect)
        . ": " . mysqli_error($DBConnect)) . "</p>";
    echo "<table width='100%' border='1'>";
    echo "<tr><th>Product</th><th>Description</th><th>Price Each</th><th>Select Item</th></tr>";
    $Row = $QueryResult->fetch_row();
    do {
        echo "<tr><td>{$Row[1]}</td>";
        echo "<td>{$Row[2]}</td>";
        printf("<td align='center'>$%.2f</td>", $Row[3]);
        echo "<td align ='center'>
              <a href='ShowCart.php?PHPSESSID=" . session_id()
              . "&operation=addItem&productID=" . $Row[0]
              . "'>Add</a></td></tr>";
        $Row = $QueryResult->fetch_row();
    } while ($Row);
    echo "</table>";
}
public function addItem() {
    $ProdID = $_GET['productID'];
    if (array_key_exists($ProdID, $this->Orders))
        exit("<p>You already selected that item! Click your
             browser's back button to return to the
             previous page.</p>");
    $this->Orders[$ProdID] = 1;
    $this->OrderTable[$ProdID] = $this->TableName;
}
function _wakeup() {
    $this->DBConnect = new mysqli("localhost", "staticlo_shane", "shinfoosh");
    if (mysqli_connect_errno())
        die("<p>Unable to connect to the database server.</p>"
        . "<p>Error code " . mysqli_connect_errno()
        . ": " . mysqli_connect_error()) . "</p>";
    $this->DBConnect->Select_db($this->DBName)
        Or die("<p>Unable to select the database.</p>"
        . "<p>Error code " . mysqli_errno($$this->DBConnect)
        . ": " . mysqli_error($this->DBConnect)) . "</p>";
}
public function showCart() {
    if (empty($this->Orders))
        echo "<p>Your shopping cart is empty!</p>";
    else {
        echo "<table width='100%' border='1'>";
        echo "<tr><th>Remove Item</th><th>Product</th><th>Quantity</th><th>
              Price Each</th></tr>";
        $Total = 0;
    foreach($this->Orders as $Order) {
        $SQLstring = "SELECT * FROM "
            . $this->OrderTable[key($this->Orders)] . "
            WHERE productID='" . key($this->Orders) . "'";
        $QueryResult = mysqli_query($this->DBConnect, $SQLstring)
            Or die("<p>Unable to perform the query.</p>"
            . "<p>Error code " . mysqli_errno($this->DBConnect)
            . ": " . mysqli_error($this->DBConnect)) . "</p>";
        $Row = mysqli_fetch_row($QueryResult);
        echo "<td align='center'>";
        echo "<a href='ShowCart.php?PHPSESSID=" . session_id()
              . "&operation=removeItem&productID=" . $Row[0]
              . "'>Remove</a></td>";
        echo "<td>{$Row[1]}</td>";
        echo "<td align='center''>$Order ";
echo "<a href='ShowCart.php?PHPSESSID=" . session_id() . "&operation=addOne&productID=" . $Row[0] . "'>Add</a>";
echo "<a href='ShowCart.php?PHPSESSID=" . session_id() . "&operation=removeOne&productID=" . $Row[0] . "'>Remove</a>";
        echo "</td>";
        printf("<td align='center'>$%.2f</td></tr>", $Row[3]);
        $Total += $Row[3] * $Order;
        next($this->Orders);

        echo "<td align='center' colspan='2'><strong>Your shopping
              cart contains " . count($this->Orders)
              . " product(s).</strong></td>";
        printf("<td align='center'><strong>Total: $%.2f</stong>
               </td>", $Total);
        echo "</table>";
    }
    echo "<tr><td align='center'><a href='ShowCart.php?PHPSESSID="
          . session_id() . "&operation=emptyCart'><strong>
          Empty Cart</strong></a></td>";
    }
}
public function removeItem() {
    $ProdID = $_GET['productID'];
    unset($this->Orders[$ProdID]);
    unset($this->OrderTable[$ProdID]);
}
function emptyCart() {
    $this->Orders = array();
    $this->OrderTale = array();
}
function _destruct() {
    $this->DBConnect->close();
}

public function addOne() {
$ProdID = $_GET['productID'];
$this->Orders[$ProdID] += 1;
}

public function removeOne() {
$ProdID = $_GET['productID'];
$this->Orders[$ProdID] -= 1;
if ($this->Orders[$ProdID] == 0)
$this->removeItem();
}

}
?> 

Here is the ShowCart.php code:<?php
session_start();
require_once("ShoppingCart.php");
if (!isset($_SESSION['curCart']))
header("location:GosselinGourmetGoods.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="Robots" content="nofollow, noindex" />
<link rel="stylesheet" type="text/css" media="screen" href="php_styles.css" />
</head>
<body>
<h1>Gosselin Gourmet Goods</h1>
<h2>Shop by Category</h2>
<p><a href="GosselinGourmetCoffees.php">Gourmet Coffees</a><br />
<a href="GosselinGourmetOlives.php">Specialty Olives</a><br />
<a href="GosselinGourmetSpices.php">Gourmet Spices</a></p>

<?php
$Cart = unserialize($_SESSION['curCart']);
if (isset($_GET['operation'])) {
if ($_GET['operation'] == "addItem")
$Cart->addItem();
if ($_GET['operation'] == "removeItem")
$Cart->removeItem();
if ($_GET['operation'] == "emptyCart")
$Cart->emptyCart();
if ($_GET['operation'] == "addOne")
$Cart->addOne();
if ($_GET['operation'] == "removeOne")
$Cart->removeOne();
}
$Cart->showCart();
$_SESSION['curCart'] = serialize($Cart);
?>
</body>
</html>


Here is the product page for "Specialty Olives" which is identical to the Coffees and Spices pages, save for the Table name changed to their respective products: <?php
session_start();
require_once("ShoppingCart.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Gosselin Gourmet Goods</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="Robots" content="nofollow, noindex" />
<link rel="stylesheet" type="text/css" media="screen" href="php_styles.css" />
</head>
<body>
<h1>Gosselin Gourmet Goods</h1>
<h2>Shop by Category</h2>
<p><a href="GosselinGourmetCoffees.php">Gourmet Coffees</a><br />
<a href="GosselinGourmetOlives.php">Specialty Olives</a><br />
<a href="GosselinGourmetSpices.php">Gourmet Spices</a></p>

<h2>Speciality Olives</h2>
<?php

$Database = "gosselin_gourmet";
$Table = "olives";

$Cart=!empty($_SESSION['curCart'])?unserialize($_SESSION['curCart']):new ShoppingCart();
$Cart->construct();
$Cart->setDatabase($Database);
$Cart->setTable($Table);
$Cart->getProductList();
$_SESSION['curCart'] = serialize($Cart);
?>
<p><a href='<?php echo "ShowCart.php?PHPSESSID=" . session_id() ?>'>Show Shopping Cart</a></p>
</body>
</html>

So I wanted to create stickers on my forum where people type in say ":Blobby-Tired" and then instead of the comment showing ":Blobby-Tired" it shows an html image tag displaying a picture of Blobby in the comment box

So I created the following page CommentUpload.php

However my sql fails to insert it despite the fact when I "echo $new" it shows the image on the page correctly

And it can't be my sql insert code as if I change $new variable for "$BodyText" int he SQL query it it inserts   ":Blobby-Tired" OK?

 

<?php
include 'dbconnect.php';
session_start();

if(isset($_POST["submit"]) && !empty($_POST["CommentText"])){
$id = intval($_SESSION['id']);
echo  $_SESSION['id'] . '<p> </p>'   ; 
$BodyText = $conn -> real_escape_string($_POST['CommentText']) ; 
$User = $_SESSION['username'];

//Replace flairs with <img> tags 
/*not working currently) */
$new = str_replace(":Blobby-Tired","<img src='flairs/Blobby-Tired.jpg'> </img>","'$BodyText'");
echo "$new";
/************************/ 

	 $sql = "INSERT INTO Posts (User, CommentText, IdOfThread)
     VALUES ('$User','$new','$id')";
     if (mysqli_query($conn, $sql)) {
        echo "New record has been added successfully !";
     } else {
        echo "Error: " . $sql . ":-" . mysqli_error($conn);
     }


     mysqli_close($conn);

}

?>

 

Edited April 28 by Fishcakes

$query  = "SELECT * FROM School_Registrations WHERE School_Name= '$_POST[SchoolName]' ";
$result2 = mysql_query($query);
if (mysql_numrows($result2) > 0) {
while($row = mysql_fetch_array($result2))
{
echo" 
<h2>ERROR</h2>
...rest of the error code...
";} 
}
else {

mysql_query("INSERT INTO ``.`` (...all the variables...);") 

or die(mysql_error( 'Location: http://www...php' ));  
 
 echo "
...success code...


$url = 'http://www.mypage.com/page.php?';
$url .= 'email='.urlencode($_POST['email']);
 
$result = getPage('', $url, '', 15);
 
function getPage($proxy, $url, $header, $timeout) {
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_HEADER, $header);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_PROXY, $proxy);
    curl_setopt($ch, CURLOPT_HTTPPROXYTUNNEL, 1);
    curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
    curl_setopt($ch, CURLOPT_REFERER, 'http://mypage.org');
    curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8');
    $result['EXE'] = curl_exec($ch);
    $result['INF'] = curl_getinfo($ch);
    $result['ERR'] = curl_error($ch);
    curl_close($ch);
    return $result;
}
}
?>


Ok, so this code verifies what the name entered in the forms is not already in database. If it is it gives you the ...error code... and nothing else. If it does not it gives you ...success code... and it creates new table record, and it sends out email address entered to designated page. Bu I keep getting:

Fatal error: Call to undefined function getPage()

It still fully works, but no email goes out as defined. I am stuck. Help?

Here's my code, whenever I try to fill the form it gives me that error "Oops! Something went wrong. Please try again later"

 

Code: 

<?php
// Include config file
require_once "config.php";
 
// Define variables and initialize with empty values
$CodEntrega = $CodCliente = $Dia = $Pagamento = $Funcionario = "";
$CodEntrega_err = $CodCliente_err = $Dia_err = $Pagamento_err = $Funcionario_err = "";
 
// Processing form data when form is submitted
if($_SERVER["REQUEST_METHOD"] == "POST"){
    // Validate name
    $input_CodEntrega = trim($_POST["CodEntrega"]);
    if(empty($input_CodEntrega)){
        $CodEntrega_err = "Insira o codigo de entrega";
    } else{
        $CodEntrega = $input_CodEntrega;
    }
    
    // Validate address
    $input_CodCliente = trim($_POST["CodCliente"]);
    if(empty($input_CodCliente)){
        $CodCliente_err = "Insira o codigo do cliente";     
    } else{
        $CodCliente = $input_CodCliente;
    }
    
    // Validate salary
    $input_Dia = trim($_POST["Dia"]);
    if(empty($input_Dia)){
        $Dia_err = "Insira a data da entrega"; 
    } else{
        $Dia = $input_Dia;
    }
    
    $input_Pagamento = trim($_POST["Pagamento"]);
    if(empty($input_Pagamento)){
        $Pagamento_err = "Insira o tipo de pagamento"; 
    } else{
        $Pagamento = $input_Pagamento;
    }
    
    $input_Funcionario = trim($_POST["Funcionario"]);
    if(empty($input_Funcionario)){
        $Funcionario_err = "Insira o codigo do funcionario"; 
    } else{
        $Funcionario = $input_Funcionario;
    }
    
    if(empty($CodEntrega_err) && empty($CodCliente_err) && empty($Dia_err) && empty($Pagamento_err) && empty($Funcionario_err)){
       
        $sql = "INSERT INTO entrega(CodEntrega, CodCliente, Dia, Pagamento, Funcionario) VALUES (?, ?, ?, ?, ?)";
         
        if($stmt = mysqli_prepare($link, $sql)){
            // Bind variables to the prepared statement as parameters
            mysqli_stmt_bind_param($stmt, "ssdss", $param_CodEntrega, $param_CodCliente, $param_Dia, $param_Pagamento, $param_Funcionario);
            
            // Set parameters
            $param_CodEntrega= $CodEntrega;
            $param_CodCliente = $CodCliente;
            $param_Dia = $Dia;
            $param_Pagamento = $Pagamento;
            $param_Funcionario = $Funcionario;
            
            if(mysqli_stmt_execute($stmt))
            {
                header("location: home.html");
                exit();
            } 
            else
            {
                echo "Oops! Something went wrong. Please try again later.";
            }
        }
         
        // Close statement
        mysqli_stmt_close($stmt);
    }
    
    // Close connection
    mysqli_close($link);
}
?>
 
<!DOCTYPE html>
<html lang="en">
<head>
<title>Projeto TW</title>
<link rel="stylesheet" href="css/milligram.css">
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
* {
  box-sizing: border-box;
}

body {
  font-family: Arial, Helvetica, sans-serif;
}

/* Style the header */
header {
  background-color: #B0171F;
  padding: 30px;
  text-align: center;
  font-size: 35px;
  color: white;
}

/* Create two columns/boxes that floats next to each other */
nav {
  float: left;
  width: 30%;
  height: 300px; /* only for demonstration, should be removed */
  background: #ccc;
  padding: 20px;
}

/* Style the list inside the menu */
nav ul {
  list-style-type: decimal;
  padding: 0;
}

article {
  float: left;
  padding: 20px;
  width: 70%;
  background-color: #f1f1f1;
  height: 300px; /* only for demonstration, should be removed */
}

/* Clear floats after the columns */
section::after {
  content: "";
  display: table;
  clear: both;
}

/* Style the footer */
footer {
  background-color: #B0171F;
  padding-top: 7px;
  padding-bottom: 7px;
  text-align: middle;
  color: white;
  position: relative;
  bottom: 0;

}

#content-wrap {
  padding-bottom: 2rem;    /* Footer height */
}

#page-container {
  position: relative;
 
}

@media (max-width: 600px) {
  nav, article {
    width: 100%;
    height: auto;
  }
}

.dropbtn {
  background-color: #4CAF50;
  color: white;
  padding: 16px;
  font-size: 16px;
  border: none;
}


.dropdown {
  position: relative;
  display: inline-block;
}


.dropdown-content {
  display: none;
  position: absolute;
  background-color: #f1f1f1;
  min-width: 160px;
  box-shadow: 0px 8px 16px 0px rgba(0,0,0,0.2);
  z-index: 1;
}


.dropdown-content a {
  color: black;
  padding: 12px 16px;
  text-decoration: none;
  display: block;
}


.dropdown-content a:hover {background-color: #ddd;}


.dropdown:hover .dropdown-content {display: block;}


.dropdown:hover .dropbtn {background-color: #3e8e41;}

</style>
</head>
<body>


<header>
  <div class="head1">PROJETO DE TW</div> 
  <div class="head2">Gestão de uma BD</div>
</header>

<div class='container'>
      <div class='navbar'>
        <ul>
          <li><a class="active" href="home.html">Home</a></li>
          <li><a href="#consultar">Consultar</a></li>
          <li><a href="tabela.html">Inserir</a></li>
          <li><a href="#alterar">Alterar</a></li>
          <li><a href="#eliminar">Eliminar</a></li>
        </ul>
      </div> 
   <div class = "body_sec"> 
      <section id="Content"> 
         <h3>INSERIR DADOS DE ENTREGA</h3>
         <button type="button" >ENTREGA</button>         
      </section>
                    <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">
                        <div class="form-group">
                            <label>CodEntrega</label>
                            <input type="text" name="CodEntrega" class="form-control <?php echo (!empty($CodEntrega_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $CodEntrega; ?>">
                            <span class="invalid-feedback"><?php echo $CodEntrega_err;?></span>
                        </div>
                        <div class="form-group">
                            <label>CodCliente</label>
                            <input type="text" name="CodCliente" class="form-control <?php echo (!empty($CodCliente_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $CodCliente; ?>">
                            <span class="invalid-feedback"><?php echo $CodCliente_err;?></span>
                        </div>
                        <div class="form-group">
                            <label>Dia de Entrega</label>
                            <input type="date" name="Dia" class="form-control <?php echo (!empty($Dia_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $Dia; ?>">
                            <span class="invalid-feedback"><?php echo $Dia_err;?></span>
                        </div>
                        <div class="form-group">
                            <label>Pagamento</label>
                            <input type="text" name="Pagamento" class="form-control <?php echo (!empty($Pagamento_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $Pagamento; ?>">
                            <span class="invalid-feedback"><?php echo $Pagamento_err;?></span>
                        </div>
                        <div class="form-group">
                            <label>Codigo do Funcionario</label>
                            <input type="text" name="Funcionario" class="form-control <?php echo (!empty($Funcionario_err)) ? 'is-invalid' : ''; ?>" value="<?php echo $Funcionario; ?>">
                            <span class="invalid-feedback"><?php echo $Funcionario_err;?></span>
                        </div>
                        <input type="submit" class="btn btn-primary" value="Submit">
                        <a href="home.html" class="btn btn-secondary ml-2">Cancel</a>
                    </form>
                </div>
            </div>        
        </div>
    </div>
</body>
</html>

 

 

Edited May 10 by Barand
code tags added

Hello I am trying to only display results within the time period last sunday too next sunday. my code:
Code: [Select]
<?php
$today = date('Y-m-d H:i:s');
$time = strtotime($today);
$last_sunday = strtotime('last sunday', $time);
$next_sunday = strtotime('next sunday', $time);
$format = 'Y-m-d H:i:s';
$last_sunday = date($format, $last_sunday);
$next_sunday = date($format, $next_sunday);
?>
<?php
$sql_totalsurfs = ("SELECT vtp_members.id, vtp_members.name, vtp_members.teamleader, vtp_tracking.Timber, vtp_tracking.Stone, vtp_tracking.Marble, teams.team_name, count(vtp_tracking.id) surfs
FROM vtp_members, vtp_tracking, teams
WHERE vtp_members.team_id=".$_GET['t']." AND vtp_tracking.credit_members_id=vtp_members.id AND vtp_tracking.action_date>'$last_sunday' AND vtp_tracking.action_date<'$next_sunday'
GROUP BY vtp_members.id
ORDER BY surfs DESC LIMIT 0, 10");
$rstotalsurfs = mysql_query($sql_totalsurfs);
$numrows = mysql_num_rows($rstotalsurfs);
.......
Is there and error somwhere in the code?

I'm getting an invalid argument error for my While loop.  I can't figure out why. 

Code: [Select]
$sql="SELECT * FROM schools ORDER BY class DESC,sectional ASC,team ASC";

$results = mysql_query($sql);

while ($team = mysql_fetch_assoc($results)) {

echo $team['school'] . '<br>';

}


Here is the error:

Quote

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/******/public_html/hoosierhoopsmagazine.com/resources/sectional_assignments.php on line 7

Hi, I am new to the forums. I am having an issue with a snippet of code that generates random strings.  I have already searched the forums, but the fix that I found is already in my code.
I am still receiving the error though and was wondering if there was something else going on that I didn't see.  Here is my code:

Code: [Select]
        $Data = 'Ahmet'.md5(mt_rand(0, 123456789));

$length = 30;
$chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
$string = '';
$string2 = '';
for ($a = 0; $a < $length; $a++)
{
$pos = mt_rand(0, strlen($chars)-1);
$string .= $chars{$pos};

$pos2 = mt_rand(0, (strlen($Data))-1);
$string2 .= $chars{$pos2};
}
I appreciate any help on this, as it is cluttering my system log table.
Thanks.