PHP - "time"-related Issue. Error In The Code?

Hey Guys!
I have the following doubt.

When echoing from Server like this:

Code: [Select]
echo "time=" . time();
I get the time in the following raw format: 1299272294

I would really like to echo it with this format: Tue Mar 1 23:50:00 GMT-0300 2011

Is there a way I could do that?

Really looking forward for some help on this one,

Thanks a lot in advance!
Cheers!

Hi guys

I am a newbie with PHP and I have been trying to solve this problem for 3 days..

Ive set up a booking form on my website to be sent directly to my email once the client clicked on the send button..
The problem I am having while checking these pages on wamp is that the booking form is ok but when I click on the send button the following message error appears
"Warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in C:\wamp\www\fluffy_paws\booking_form2.php on line 27"

When I check online I have this message "500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed."

Are my codes wrong???

My webhosting is Blacknight.com , Im on Windows Vista, my internet is a dongle with O2 ireland

Thanks for your help!

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

Greetings to all!

I am very new to this so I may not be on the right track.  I am providing some code I have because I think this is the best way to explain what I am trying to do.  I have a database and php pages that generate a pedigree when one selects any particular dog from the search page.  If anyway has a tip on how to simplify this, I would sure appreciate it!!

First, I request an array for the dog selected:


Code: [Select]
$sql = "SELECT RegName, SireID, DamID FROM pedigrees WHERE ID=";

$thisDogQ = $sql . $values["ID"];
$thisDogR = db_query($thisDogQ,$conn);


$thisDogRow_value = mysql_fetch_assoc($thisDogR);
    $thisDogRow_value = array (
'RegName' => $thisDogRow_value['RegName'],
'SireID' => $thisDogRow_value['SireID'],
'DamID' => $thisDogRow_value['DamID']);
</code>

//Next I request the same information for his sire

<code>
if (is_numeric($thisDogRow_value['SireID'])) {
 
$query_SireQ = $sql . $thisDogRow_value['SireID']; 
$SireR = mysql_query($query_SireQ, $conn) or die(mysql_error());

  $SireRow_value = mysql_fetch_assoc ($SireR);         
$SireRow_value = array (
'RegName' => $SireRow_value['RegName'],           
'SireID' => $SireRow_value['SireID'],           
'DamID' => $SireRow_value['DamID']);
</code>

//and then his dam

<code>
if (is_numeric($thisDogRow_value['DamID'])) {
 
$query_DamQ = $sql . $thisDogRow_value['DamID'];   
$DamR = mysql_query($query_DamQ, $conn) or die(mysql_error());

  $DamRow_value = mysql_fetch_assoc ($DamR);         
$DamRow_value = array (
'RegName' => $DamRow_value['RegName'],           
'SireID' => $DamRow_value['SireID'],           
'DamID' => $DamRow_value['DamID']);

</code>

Now, here's the rub:  Now I need the sire and the dam for those 2 [described above] so this time through, I will need the same information for FOUR dogs.  The next time will be for EIGHT, then SIXTEEN - and so on until there are a total of 256 dogs.

<code>
//Get PatGrandSire 2

if (is_numeric($SireRow_value['SireID'])) {

$PatGrandSireQ = $sql . $SireRow_value['SireID'];
$PatGrandSireR = mysql_query ($PatGrandSireQ, $conn) or die(mysql_error());
    $PatGrandSireRow_value = mysql_fetch_assoc ($PatGrandSireR);         

$PatGrandSireRow_value = array (
'RegName' => $PatGrandSireRow_value['RegName'],           
'SireID' => $PatGrandSireRow_value['SireID'],           
'DamID' => $PatGrandSireRow_value['DamID']);

//GetPatGrandDam 17
if (is_numeric($SireRow_value['DamID'])) {
$PatGrandDamQ = $sql . $SireRow_value['DamID'];
$PatGrandDamR = mysql_query ($PatGrandDamQ, $conn) or die(mysql_error());
$PatGrandDamRow_value = mysql_fetch_assoc ($PatGrandDamR);

$PatGrandDamRow_value = array (
'RegName' => $PatGrandDamRow_value['RegName'],
'SireID' => $PatGrandDamRow_value['SireID'],
'DamID' => $PatGrandDamRow_value['DamID']);
//Get Pat1GGrandSire-3

if (is_numeric($PatGrandSireRow_value['SireID'])) {
$Pat1GGrandSireQ = $sql . $PatGrandSireRow_value['SireID'];
$Pat1GGrandSireR = mysql_query ($Pat1GGrandSireQ, $conn) or die(mysql_error());
     
$Pat1GGrandSireRow_value = mysql_fetch_assoc ($Pat1GGrandSireR);         
$Pat1GGrandSireRow_value = array (
'RegName' => $Pat1GGrandSireRow_value['RegName'],           
'SireID' => $Pat1GGrandSireRow_value['SireID'],
'DamID' => $Pat1GGrandSireRow_value['DamID']);


if (is_numeric($PatGrandSireRow_value['DamID'])) {
$Pat1GGrandDamQ = $sql . $PatGrandSireRow_value['DamID'];
$Pat1GGrandDamR = mysql_query ($Pat1GGrandDamQ, $conn) or die(mysql_error());
     
$Pat1GGrandDamRow_value = mysql_fetch_assoc ($Pat1GGrandDamR);         
$Pat1GGrandDamRow_value = array (
'RegName' => $Pat1GGrandDamRow_value['RegName'],           
'SireID' => $Pat1GGrandDamRow_value['SireID'],           
'DamID' => $Pat1GGrandDamRow_value['DamID'],
'Title' => $Pat1GGrandDamRow_value['Title'],
'Title2' => $Pat1GGrandDamRow_value['Title2'],
'Title3' => $Pat1GGrandDamRow_value['Title3'],
'Title4' =>$Pat1GGrandDamRow_value['Title4'],
'Title5' => $Pat1GGrandDamRow_value['Title5'],
'Title6' =>$Pat1GGrandDamRow_value['Title6'],
'Title7' => $Pat1GGrandDamRow_value['Title7'],
'Title8' =>$Pat1GGrandDamRow_value['Title8'],
'Title9' => $Pat1GGrandDamRow_value['Title9'],
'Addl_Titles' => $Pat1GGrandDamRow_value['Addl_Titles']);
//Get Pat2GGrandSire-18

if (is_numeric($PatGrandDamRow_value['SireID'])) {
$Pat2GGrandSireQ = $sql . $PatGrandDamRow_value['SireID'];
$Pat2GGrandSireR = mysql_query ($Pat2GGrandSireQ, $conn) or die(mysql_error());
     
$Pat2GGrandSireRow_value = mysql_fetch_assoc ($Pat2GGrandSireR);         
$Pat2GGrandSireRow_value = array (
'RegName' => $Pat2GGrandSireRow_value['RegName'],           
'SireID' => $Pat2GGrandSireRow_value['SireID'],
'DamID' => $Pat2GGrandSireRow_value['DamID'],
'Title' => $Pat2GGrandSireRow_value['Title'],
'Title2' => $Pat2GGrandSireRow_value['Title2'],
'Title3' => $Pat2GGrandSireRow_value['Title3'],
'Title4' => $Pat2GGrandSireRow_value['Title4'],
'Title5' => $Pat2GGrandSireRow_value['Title5'],
'Title6' => $Pat2GGrandSireRow_value['Title6'],
'Title7' => $Pat2GGrandSireRow_value['Title7'],
'Title8' => $Pat2GGrandSireRow_value['Title8'],
'Title9' => $Pat2GGrandSireRow_value['Title9'],

'Addl_Titles' => $Pat2GGrandSireRow_value['Addl_Titles']);

//Get Pat2GGrandDaminfo-25

if (is_numeric($PatGrandDamRow_value['DamID'])) {
$Pat2GGrandDamQ = $sql . $PatGrandDamRow_value['DamID'];
$Pat2GGrandDamR = mysql_query ($Pat2GGrandDamQ, $conn) or die(mysql_error());
     
$Pat2GGrandDamRow_value = mysql_fetch_assoc ($Pat2GGrandDamR);         
$Pat2GGrandDamRow_value = array (
'RegName' => $Pat2GGrandDamRow_value['RegName'],           
'SireID' => $Pat2GGrandDamRow_value['SireID'],           
'DamID' => $Pat2GGrandDamRow_value['DamID']);

I apologizing for bothering the expert here again, but I've run into another issue.  I am using the following code because I can't change the default timezone on my shared hosting plan:

$time = date("h:i A", strtotime("+19 hours"));

there are few issues with this.  if I just use: date("h:i: A") the time prints as 7 hours earlier than my timezone, and currently it shows 1:09 AM and it appears in the database as "01:09:00".  if I use the code above, the time prints out as "08:09 PM", but it is inserted into the database as "08:09:00".  Shouldn't it read "20:09:00" instead?  and why isn't the time being inserted into the database with the "PM" suffix on it like it appears in the printout?  the "time" field in my database is set to type TIME.

thanks.

Edited October 14, 2019 by ajetrumpet

This topic has been moved to Linux.

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

Question:
For a website on a shared server (regardless of server location), is there such a thing as PHP code that will consistently produce my own time zone's time without having to adjust every few months?

Background:
No matter how much I "adjust" the code, time zones, etc., things like daylight saving time, or server location throws it off by 1, 2, sometimes 3 hours.

Example:
This is my code:
$date = new DateTime();
$currentTime = $date->sub(new DateInterval('PT8H'))->format('F j, Y \a\t g:ia');

The Pacific ("Los Angeles") time right now is 7:58pm, but my code says it's 6:58pm. So now I have to go in and correct the "PT8H" portion. I'm wondering if there is some code I can use whereby I can simply "set it and forget it."

Thank you!

Edited May 2, 2020 by StevenOliver

This topic has been moved to Miscellaneous.

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

Hello

I have a from that updates a few things in the db, and uses "<?php echo $PHP_SELF;?>".

The form does update everything fine, however that page does not reflect it. If I refresh the page manually
I can see the new values.

Is this a common thing, and can anything be done to fix this?

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!

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?

This topic has been moved to PHP Installation & Configuration.

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

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>