PHP - Convert String To Date Issue

I have a form that submits G

How can I convert this to string of time when I need to insert it into the database and then turn it back around when it needs to be read?

          
<option>11:00 AM</option>
<option>11:30 AM</option>
<option>12:00 PM</option>
<option>12:30 PM</option>
<option>1:00 PM</option>
<option>1:30 PM</option>


Thank you.

//$value1 = $_POST['game'];

$value1 = "game7h";

if (strpos($value1, 'a')) {
$team = 'a';
}elseif (strpos($value1, 'h')) {
$team = 'h';
}      
if (strpos($value1, '7')) {
$num = '7';
} elseif (strpos($value1, '8')) {
$num = '8';
} elseif (strpos($value1, '9')) {
$num = '9';
}

$gm7hodds = $games[41]["BP"];
$gm7aodds = $games[40]["BP"];

$gm8hodds = $games[47]["BP"];
$gm8aodds = $games[46]["BP"];

$gm9hodds = $games[53]["BP"];
$gm9aodds = $games[52]["BP"];


/* 
$getratio = $num + $team;

echo $getratio;

Team is not a math operation so I'll finesse that later.

*/


$findratio = 'gm' . $num . 'h' . 'odds';
echo $findratio;

gm7hodds

How would I add the $ to it and return its array value $gm7hodds?

Solved whoops ->

echo eval('return $'. $findratio. ';');

Edited April 28 by Minzer
solved

how can i convert string type into integer like when using parseInt in javascript...however i use (int)$string but not working

i have this
$string1="10";
$string2="5";

and i wish to add both string ....using (int) still treat $string1 and $string2 as string so i get 105 as a result instead of 15

Hi all,

I'm having a bit of trouble a script running on a site where it converts a date of birth in a database shown like this '30/04/1993' to an actual age, for instance 18 in this case. Only the script I'm using below shows this age as 17, not 18 as it should be.

Code: [Select]
<?php
   $birthday = $row_getdets['dob']; 
    function birthday ($birthday){
    list($day,$month,$year) = explode("/",$birthday);
    $day_diff   = date("d") - $day;
    $month_diff = date("m") - $month;
    $year_diff  = date("Y") - $year;
    if ($day_diff < 0 || $month_diff < 0)
      $year_diff--;
    return $year_diff;
  }
?>

So i've tried to remedy this myself with the following:

Code: [Select]
<?php
$birthday = $row_getdets['dob'];
function birthday ($birthday){
    list($year,$month,$day) = explode("/",$birthday);
     $year_diff  = date("Y") - $year;
     $month_diff = date("m") - $month;
     $day_diff   = date("d") - $day;
     if ($month_diff < 0) $year_diff--;
else if (($month_diff==0) && ($day_diff < 0)) $year_diff--;
return $year_diff;
  }
?>
..but I'm having a syntax error (unexpected T_LINE), most probably down to my novice ability, I bet I've missed something simple. I'm still learning guys and I'd really appreciate any help at all.

Is it possible to convert time(); to date();?

while I'm reading the cell value '20/09/1980' from an excel file using phpexcel class method

 $student[$i]['d_o_b'] = $objWorksheet->getCell('G' . $intRow)->getValue();

 getting the value as '29484' pls help me to convert it into the date format again.

I have a simple form and need to convert it to XML so I can send it to my payment gateway.

I have the XML data types (?) they are expecting, but do not have a clue of how to build the string.   

Can someone help me out?

Thanks,


Debbie

I got a response from an api in json. How do i echo out the account_name in string. Thanks as usual. The response is below...

 

{ "status": true, "message": "Account number resolved", "data": { "account_number": "2067483918", "account_name": "BABALOLA MAYOWA ABEL", "bank_id": 18 } }

"status": true, "message": "Account number resolved", "data": { "account_number": "2067483918", "account_name": "BABALOLA MAYOWA ABEL", "bank_id": 18 } }

 

Code: [Select]
<?php
$myServer = "202.138.125.155";
$myUser = "micro_fms";
$myPass = "micro_fms*#$";
$myDB = "micro_fms"; 

//create an instance of the  ADO connection object
$conn = new COM("ADODB.Connection")or die("Cannot start ADO");

//define connection string, specify database driver
$connStr = "PROVIDER='SQLOLEDB'; SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB; 

//Open the connection to the database
$conn->open($connStr);

//$table_name=$_GET['Device'];
$table_data=$_GET['Data'];
$data=(explode(",",$table_data));

$table_name=$data[0];
$speed=$data[1];
$time=$data[2];
$date=$data[3];
$lat=$data[4];
$long=$data[5];
//$newdate = substr($date,6,2) . "-" . substr($date,0,2) . "-" substr($date,3,2);
$datetime=$date.$time;


$new_lat = substr($lat,0,2).'.'.substr($lat,2);
$new_long = substr($long,0,2).'.'.substr($long,2);

echo $table_name."<br>";
echo $speed."<br>";
echo $new_lat."<br>";
echo $new_long."<br>";
echo $datetime."<br>";

$query="insert into $table_name (DeviceNumber,Speed,dtDateTime,Latitude,Longitude)values('$table_name','$speed','$datetime','$new_lat','$new_long')";


//execute the SQL statement and return records
$rs = $conn->execute($query);
if($rs)
{
echo 'Values Inserted';
}
else
{
echo "faile";
}
?>


Hi friends...
I have two variables ($date and $time). I concat these two strings and make a new variable called "$datetime". Now in above code I want to insert it into table but I got the following error. Code: [Select]
Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Conversion failed when converting datetime from character string.' in C:\wamp\www\FMS\fms.php:44 Stack trace: #0 C:\wamp\www\FMS\fms.php(44): com->execute('insert into A00...') #1 {main} thrown in C:\wamp\www\FMS\fms.php on line 44
In my database, data type of column in which I want to insert is Date time stamp though I have string type ($datetime) variable.
I think I have to convert this $datetime variable string to "DateTime type first but don't have any idea about it.
Please help??/
Thanks in advance....

I have ip_addresses stored in the database as unsigned integers. I want to display them in standard xxx.xxx.xxx.xxx format in a table. In my code, I tried the following:

<?php
while ($row = $query->fetch()) 
{
    $address = inet_ntoa($row['IP_ADDRESS']);  //Throws error here
    echo "<tr>";
//    echo "<td>" . $row['IP_ADDRESS'] ."</td>";
    echo "<td>" . $row['$address'] ."</td>";
    echo "<td>" . $row['FILENAME'] ."</td>";
    echo "<td>" . $row['country'] . "</td>";
    echo "<td>" . $row['area'] . "</td>";
    echo "<td>" . $row['city'] . "</td>";
    echo "</tr>";
}
?>

It throws the following error:

Parse error: syntax error, unexpected 'inet_ntoa' (T_STRING) in /home/larry/web/test/public_html/report1.php on line 205

How do I do the conversion so I can display the ip_address?

Thanks in advance,

Larry

 

Hello, i need a fast convertor that converts the date format 03-03-2008, 08:26 PM into a timestamp fast.
Like, you paste 03-03-2008, 08:26 PM into a post form, submit and it gives you the time stamp.

I made a convertor a whille ago, but you need to insert each numbers into a separate input box (day, months, year etc)
I cant remember how exactly it functions etc asi haventtouched PHP In a while.....

sorry, I know this is simple, but stuck on it...

how would one go about converting 1/21/11 to a UNIX timestamp, something like 1293035229?

and while we are at it, how to convert 1293035229 to 1/21/11 ? (i know the timestamp is wrong, just for example)


thanks!!!!!

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>";

2011-02-05T18:07:57.00+0000

This is a string.

How can i convert an array of results to a single comma separated string so that I can run it through an SQL query?