PHP - Convert Database Yyyy-mm-dd To Mm/dd/yyyy

hello, i have the following code and it is ok.  what im trying to do is convert a 2010-09-20 post from a form and have it read out as Monday September 20, 2010.

is this possible?

Code: [Select]
$dateselected="$_POST[Y]-$_POST[M]-$_POST[D]";


echo "<table border='1'>";
echo "<tr><td width='100%' colspan='4' align='center'>$_POST[M]-$_POST[D]-$_POST[Y]</td></tr>";

Hi,
In my database, date is stored as in the format of YYYY-MM-DD

Something like $date = 2012-04-01

How can I extract this as follows ...

$year = 2012
$month = 04
$day = 01

Thanks

How can I get the day of the week from DD/MM/YYYY?? Thanks!

I have set up a function to validate user input date in yyyy-mm-dd format taking into account the following possibilities: the length of the month February 29th when the year is not a leap year When I run the code, I do not get any feedback whatsoever, when it should. This is the code below and I would appreciate your thoughts:

if(!function_exists('checkdate'))
{
	function checkdate($date, $checkyear, $currentmonth)
	{
		if($checkyear == 0)//if it is not a leap year
		{
			// if current month is february
			if($currentmonth == 2)
			{
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|1[0-9]|2[0-8])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
			// if current months are april, june, september or november
			elseif($currentmonth == 4 || $currentmonth == 6 || $currentmonth == 9 || $currentmonth ==11)
			{
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|1[0-9]|2[0-8]|3[0])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
			else
			{	
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-8]|3[01])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
		}
		elseif($checkyear == 1)//if it is a leap year
		{
			// if current month is february
			if($currentmonth == 2)
			{
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|1[0-9]|2[0-9])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
			// if current months are april, june, september or november
			elseif($currentmonth == 4 || $currentmonth == 6 || $currentmonth == 9 || $currentmonth ==11)
			{
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|1[0-9]|2[0-9]|3[0])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
			else
			{	
				if(!preg_match("/^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$/", $date))
				{
					// set error for date field
					return ($error = 'Invalid Date!');
				}
				return ($error = 'valid Date!');
			}
		
		}
	}
$todate = getdate();
$currentmonth = $todate['mon'];
$checkyear = date('L');
$date = 2014-02-31;
echo checkdate($date, $checkyear, $currentmonth);

Edited by terungwa, 26 July 2014 - 02:43 PM.

Hey,

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

The date is submitted like this: 2014-02-08

Is there a really simple way to prevent rows showing if the date is in the past?

Something like this:
if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

}

Thanks very much,
Jack

Code: [Select]
<?php echo 
  $row_Recordset1['name']; 
      ?>
i want to convert the name in to like

<a href=main.php?name= $row_Recordset1['name']  >>

in databse i has 3 name
Steve
Mark
Lisa

i want that names into link like main.php?name=mark and so on
how to do it
help me
h
   

I coded the following but some parts are not working (the "curveball" mentioned at the end).
How would YOU do this?

I have a page (A) displaying a form with a textarea field using a WYSIWYG interface.
The user will enter a list of unordered items and upon submit the string will look something like this:

This is my list of food items:
 <ul>
  <li> Lettuce </li>
  <li> Tomatoes </li>
  <li> Eggs </li>
 <ul>




Upon submit, I need to give each list item an unique id and store this id along with the text next to it in a separate table:

List_item_id   List_item_text  List_item_state
food_1             Lettuce
food_2             Tomatoes
food_3             Eggs





The user will then land in another page with a form displaying the list. The text is now in the page itself and not in a textarea.
Instead of the bullets a dropdown list appears, and the user can select "buy" or "sell" for each list item. 
This page (B) looks something like this:

<form>
This is my list of food items:
  <br><select name="food_1">
   <option value="buy">Buy</option>
   <option value="sell">Sell</option>
  </select>
  Lettuce

  <br><select name="food_2">
   <option value="buy">Buy</option>
   <option value="sell">Sell</option>
  </select>
  Tomatoes

  <br><select name="food_2">
   <option value="buy">Buy</option>
   <option value="sell">Sell</option>
  </select>
  Eggs

<input type=submit value="submit">
</form>




When the user hits "submit" the table with the list items will be updated with the values selected in the dropdown list:

List_item_id   List_item_text  List_item_state
food_1             Lettuce        Buy
food_2             Tomatoes       Buy
food_3             Eggs           Sell



The next time the user goes to Page B the list will remember the states.


Here's the curveball: At any point the user may click on "EDIT LIST" on Page B so they may add more items (at the begining, middle or end of the string). On edit mode the list items should appear as bullets again inside the WYSIWYG interface.

Keep in mind that some of the text in the string may not be a list item (ie, "this is my list of food...")

I've been playing around with this code from http://v3.thewatchmakerproject.com/journal/276/building-a-simple-php-shopping-cart

Objective: I'm trying to make the scripts work but without pulling the data from MySQL Database.
Instead, I created an array and inserted some info there and trying to replicate the same results but getting confused.

For example, on the Index.php file, I made the following changes:


<?php

// Start the session
session_start();

// Include functions
require_once('inc/functions.inc.php');

// Products multidimensional Array
$products = array("book" => array(  'id' => '1',
                                    'title' => 'Learn Your ABC\'s',
                                    'author' => 'John Doe',
                                    'price' => '14.95'),
                    "video" => array('id' => '2',
                                    'title' => 'Visual Guide to learn',
                                    'author' => 'Adam Smith',
                                    'price' => '21.38'),
                    "puzzle" => array('id' => '3',
                                    'title' => 'Can You Solve?',
                                    'author' => 'Sara Brown',
                                    'price' => '9.41'),
                    "exam" => array('id' => '4',
                                    'title' => 'Test Your Knowledge',
                                    'author' => 'Kim Carver',
                                    'price' => '11.15'));


?><!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" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#38;#0183; Bookshop</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="booklist">

<h1>Books In Our Store</h1>

<?php
/*
 $sql = 'SELECT * FROM books ORDER BY id';
 $result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
$output[] = '<li>"'.$row['title'].'" by '.$row['author'].': $'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
}
$output[] = '</ul>';
echo join('',$output);
*/
?>

<?php
$output[] = '<ul>';
foreach ($products as $product => $product_item) {
// $flavor is the key and $piece is the value
foreach ($product_item as $item => $piece) {

    if ($item == "id") {                            # Conditional logic defined to map specific keys to specified name value
        $row['id'] = $piece;
//        echo "The id is ". $id."<br />";                            // set just to confirm value correct for variable
    }  elseif ($item == "title")  {                        # Conditional logic defined to map 1st key to price value
        $row['title'] = $piece;
//        echo "The title is ". $title."<br />";                            // set just to confirm value correct for variable
    }  elseif ($item == "author")  {                        # Conditional logic defined to map 1st key to price value
        $row['author'] = $piece;
//        echo "The author is ". $author."<br />";                            // set just to confirm value correct for variable
    }  elseif  ($item == "price")   {                    # Conditional logic defined to map 1st key to shipping value
        $row['price'] = $piece;
//        echo "Price: ". $price."<br /><br />";                        // set just to confirm value correct for variable
    }

$output[] = '<li>"'.$row['title'].'" by '.$row['author'].': $'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
$output[] = '</ul>';
echo join('',$output);

}
}

?>
</div>

</body>
</html>


And here's the original index.php before my edits which show the sql query to the db:


<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
// Start the session
session_start();
?><!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" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#38;#0183; Bookshop</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="booklist">

<h1>Books In Our Store</h1>

<?php
$sql = 'SELECT * FROM books ORDER BY id';
$result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
$output[] = '<li>"'.$row['title'].'" by '.$row['author'].': &pound;'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
}
$output[] = '</ul>';
echo join('',$output);
?>

</div>

</body>
</html>


Also, I included the zipped file of the entire script setup.

Again, I'm trying to figure out how to make the cart work with using an array for the product instead of MySQL database.
My goal is to remove ALL SQL statements from the scripts but stuck with the looping portion to display the title, author, and price from the array as shown above.

I have the following code in javascript, I would like to rewrite it in PHP, if someone can help thank you very much.

my code: http://pastebin.com/Jnt8RiYj

Hi Coders,     any body can convert the following code into codeigniter. 

if($_GET['type'] == 'country'){
	$result = mysql_query("SELECT name FROM country where name LIKE '".strtoupper($_GET['name_startsWith'])."%'");	
	$data = array();
	while ($row = mysql_fetch_array($result)) {
		array_push($data, $row['name']);	
	}	
	echo json_encode($data);
}

Thanks

I have come across a little feature I need to create to be able to upload .doc files and convert them to .pdf using PHP.

I was wondering if anyone had any idea how I would go about achieving this, I am not asking for the code, I'm just asking on how it could be accomplished...I've searched Google and other PHP related forums but none have the answer to which I am looking for.

Any ideas or suggestions are greatly appreciated.

Regards, PaulRyan.

How can I echo this as seconds?

$date_at_timezone = new DateTimeZone('Asia/Shanghai');
$date = new DateTime(); 
$date->setTimezone($date_at_timezone);
echo $date->format('l dS F Y h:i:s A') . "Asia/Shanghai<br>";

Olá,   I have this codE:

        $cb = 'str_replace("' . $this->LE . '", "", "<$1>");';
        $encoded_value[$key] = preg_replace("/<([^>]+)>/e", $cb, $encoded_value[$key]);

error:   "PHP message: PHP Deprecated:  preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead   How can i transform this code to preg_replace_callback ?   thanks

At the moment  I am creating a search function for my website.
The approach I have in mind is a pseudo-PHP database. To give an example:

A HTML form will submit the results to a PHP file.

HTML FORM - Colour: Black
PHP RESULT PAGE - if ($_POST['color'] == 'Black') {readfile("./products/black/*.html");}
HTML FORM - Price: <$50
PHP RESULT PAGE - if ($_POST['Price'] == '<$50') {readfile("./products/less50/*.html");}

The problem here is if there is an item that is black and costs less than $50, then its going to be listed twice. There is probably some code I can write to ommit the listing of duplicate entries, but it is probably going to be messy, so I am wondering if its better to use a centralized MySQL database, rather than a pseudo-PHP database? I've never used MySQL and don't know much about it and this is my first real attempt at using PHP.