PHP - How To Convert Strings To Headers Format?

Can anyone please tell me how I convert DD-MM-YYY (text) to TIME (unix)

thought I'd say that I have this line at the top of all my pages, just in case it means a different code.

Code: [Select]
date_default_timezone_set('Europe/London'); //### Set the default timezone

I have multiple datetimes. The format is dd-mm-yy, hh:mm. I want to insert it into a table using mysql. However mysql format is yy-mm-dd, hh:mm:ss. How can i do it and what type should i use (datetime?timestamp?).
Thanks for your help!!

Does anyone know how I can convert linux epoch number such as 1292878800 to the UTC format?

Ricky

Hi. I have an input field where a date is entered, format dd-mm-yy. I need to query the database to see if this date exists. How can I convert the date to yyyymmdd before the query?

Thanks

Hi, I have a connection set up to an API using a PHP script - the API sends back data in JSON format, and if I capture it and echo it, it displays in extremely unfriendly format on the screen.

I've tried to find a way to convert this data into readable format, ideally in a HTML table, but although there are articles on converting manually inputted JSON data into a HTML table using Javascript, I can't find a way to do it from a PHP variable.

This is what I have so far:

if ($_POST['getcompany']) {
$companyname = $_POST['_Name'];
	
$ch = curl_init();

$data_array2 =  array(
      'token' => $token
);
$make_call2 = json_encode($data_array2);
	//echo 'Token is '.$token;
	$token2 = substr($token, 14);
	$token3 = substr($token2, 0, -3);
	
	//echo 'Token 2 is '.$token3;
	//echo 'Company Name is '.$companyname;

//curl_setopt($ch, CURLOPT_GET, 1);
//curl_setopt($ch, CURLOPT_POSTFIELDS, $make_call2);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json','Authorization: '.$token3.'')); 
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_URL, 'https://connectionurl?countries=GB&name='.$companyname);

//Execute the request
$result = curl_exec($ch);

echo 'Companies: '.$result; //This displays the data provided by the search, but is in JSON format

 

So I need a way to get the data held in $result, into a HTML table. Any idea how I can do this?

I have tried a large number of "solutions" to  this but everytime I use them I see 0000-00-00 in my date field instead of  the date even though I echoed and can see that the date looks correct.

Here's where I'm at:
I have a drop down for the month (1-12) and date fields (1-31) as well as a text input field for the year.  Using the POST array, I  have combined them into the xxxx-xx-xx format that I am using in my field as a date field in mysql. 

<code>
$date_value =$_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
echo $date_value;
</code>

This outputs 2012-5-7 in my test echo but 0000-00-00 in the database.

I have tried unsuccessfully to use in a numberof suggested versions of:
strtotime()
mktime

Any help would be extremely appreciated.
I am aware that I need to validate this data and insure  that it is a valid date. That I'm okay with. I would like some help on getting it into the database.

I wish to know how i can convert this date 24-09-2010 to this format 2010-09-24

Hi
I am getting the following php error that is on all my pages and it works fine on the other pages except index.php
Code: [Select]
<?php
session_start();
include 'includes/conn_db.php';
  if (isset($_POST['submit'])) {
    
    if (empty($_POST['userName'])) {
      $u = FALSE;
      $nouser = '<font color="red" size="2" face="arial">You forgot to enter your username!</font>';
    } else {
    $u = $_POST['userName'];
    }  
    if (empty($_POST['userPassword'])) {
      $p = FALSE;
      $nopass = '<font color="red" size="2" face="arial">You forgot to enter your password!</font>';
    } else {
    $p = $_POST['userPassword'];
    } 
    $errorMessage = $nouser . "<br>" . $nopass;
    if ($u && $p) {
    $query = "SELECT * from clients WHERE email = '$u' AND pword = '$p'";
$result = mysql_query($query, $conn);
while ($row = mysql_fetch_assoc($result)){
if ($u == $row["email"] && $p == $row["pword"]) {
  $query_name = "SELECT * FROM clients WHERE email = '$u' AND pword = '$p'";
    $result_name = @mysql_query ($query_name);
    while ($row_name = mysql_fetch_assoc($result_name)){
$client_id_out = $row_name['client_id'];
    $firstname_out = $row_name['firstname'];
    $lastname_out = $row_name['lastname'];
    
    


// Create sessions
$_SESSION['client_id'] = $client_id_out;
    $_SESSION['firstname'] = $firstname_out;
    $_SESSION['lastname'] = $lastname_out;
   
    
    ob_end_clean();
    header ("Location: myaccount.php");
    exit();
    }} } } }
?>
<!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>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE8" />
    <title></title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <link href="style.css" rel="stylesheet" type="text/css" />
    <link href="layout.css" rel="stylesheet" type="text/css" />

    <script src="js/jquery-1.3.2.min.js" type="text/javascript"></script>

    <script src="js/cufon-yui.js" type="text/javascript"></script>

    <script src="js/cufon-replace.js" type="text/javascript"></script>

    <script src="js/Futura_Bk_BT_400.font.js" type="text/javascript"></script>

    <script src="js/Futura_XBlk_BT_400.font.js" type="text/javascript"></script>

    <!--[if lt IE 7]>
   <script type="text/javascript" src="js/ie_png.js"></script>
   <script type="text/javascript">
       ie_png.fix('.png');
   </script>
<![endif]-->
</head>

Thanks

Lional

Okay, I've read all the rules for Headers...still can't it to execute properly.  At the bottom is my code.  I basically want to check the database, see if the user is already registered, and redirect as appropriate (there is no HTML on my page, no info sent to the browser).  My server doesn't send any error messages.  All I get are white screens. 

Now, if I do the headers_sent()...it tells me that it's sent right after the initial connection with the database. 

The ONLY way I can get it to redirect, is if I put
<?php
header("location:index.php?msg=3");
?>
 at hte very top, but then I can't evalute...which doesn't help me much.

Here is the code (obviously, I have more...but it's sending headers in these lines)


<?php
$connection = mysql_connect("localhost","####","#####");

if (!$connection){
echo mysql_errno().": ".mysql_error()."<br/>";
exit;
}

if(!mysql_select_db("prixaurora")){
echo("Database not found<br>");
}

I am trying to do a page redirect using the header() function. I am aware that header() must be called before any actual output is sent, either by normal HTML tags, blank lines in a file, or from PHP. and also that reading code with include, or require, functions, or another file access function, can create spaces or empty lines that are output before header() is called. thus causing a redirect failure. I have therefore used this output control function (ob_start(); ob_implicit_flush()  right at the top of my page. I am then creating the redirect like this as part of my login() function:

if($user_role == ADMIN_LEVEL || $user_role == EDITOR_LEVEL)
{
		if (!headers_sent($filename, $linenum)) 
		{
				return header("Location:http://mysite.com/dashboard.php");
				exit;
		}
		else
		{
				echo "Headers already sent in $filename on line $linenum\n" .
				  "Cannot redirect\n";
				exit;
		}
}

Unfortunately I am still getting this error:

Headers already sent in /home/steveoje/public_html/login.php on line 1 Cannot redirect

And this is what I have at the top of the login.php page:

<?php ob_start(); 
ob_implicit_flush(); 
require_once 'includes/config.php';
if(isset($_POST['submit']))
{
	login($_POST['username'], $_POST['password']);	
}
require_once "includes/header.inc.php" ?>
//other html content

So why would the redirect fail in this instance?   Thanks.
Edited by terungwa, 28 September 2014 - 05:28 AM.

Hi all,

It's probably something obvious, but perhaps someone could explain to me what is going on here...

I spent a lot of time this afternoon trying to fix what seemed to be a very odd problem, which involved an image being chucked out like so:

Code: [Select]
<?php
header("Content-Type: image/png");
echo file_get_contents("http://www.example.com/some_image.png");
?>
Except the image was coming out as corrupted, ultimately because I had some white space before this snippet (foolish, I know). The reason it took me so long to diagnose the problem was because I wasn't getting PHP errors (even though they were switched on). As far as the script was concerned, it seems I wasn't sending anything before attempting to modify the headers.

After solving the problem, I put the following little bit of code together, trying to force a header error... And yet I get nothing. It all works, and I get redirected, when I'm sure I shouldn't be. I've run this on a default install of XAMPP, and a configured CentOS server, and the same thing happens on both.

If anyone can explain to me what is going on, I would be most appreciative! There are some inline comments which should help clarify what I mean.

Code: [Select]
<?php

error_reporting(E_ALL);
ini_set("display_errors","1");

?>

<p>Hello! The very existence of this text should really have resulted in the headers being sent... Shouldn't it?</p>
<p>So I'd expect to see a "Headers already sent" message... Shouldn't I?</p>

<?php

// Headers sent?
echo "<p>";
echo "Headers ";

if(!headers_sent()) {
echo "not "; // This "not" does echo out.
}
echo "sent.</p>";

// This WILL start a session (or at least, won't throw an error)
session_start();

// This redirect WILL work, and you will never see the above messages.
header("Location: redirect.php");

// What?!

?>
Thanks!

Dave

My error:

Code: [Select]
Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/w/e/b/webaskius/htdocs/index.php:7) in /www/zxq.net/w/e/b/webaskius/htdocs/functions.php on line 6

Now, I can't quite figure out why it's doing this. The section of code that is causing this problem is above any HTML tags, at the very beginning of the file.


<?php 
include('functions.php'); 
?>
<link href="style.css" rel="stylesheet" type="TEXT/CSS">
<img src="logo.png" border="0">
<div id="maincontent">


As you can see, the functions that cause this error are at the VERY beginning of my file. This is where they are called within index.php:


if(mysql_num_rows($query_verify_login) > 0)
{
        create_cookie(10000, 'user', $username);
redirect('index.php');
}
else
{
       echo 'Woops! You\'ve entered in the wrong username and password combination!';
}


And finally, my functions:


<?php

//our cookie creator function
function create_cookie($time, $name, $data)
{
setcookie($name, $data, time()+$time);
}

function redirect($url)
{
header('Location: '. $url .'');
}

function get_replies($id)
{
//set query to find posts that match our id
$query_get_replies = mysql_query("SELECT * FROM replies WHERE to = {$id}");

return mysql_num_rows($query_get_replies);
}

?>

I have a form as a php include and it's giving me this error:

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/altimusw/public_html/www.csmsolution.com/register.php:6) in /home/altimusw/public_html/www.csmsolution.com/core.php on line 17

Here is the main page that includes the php include:

<!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=iso-8859-1" />
<title>CSM Solution </title>
<style type="text/css">
<!--
#Layer1 {
position:absolute;
left:100px;
top:70px;
width:800;
height:62px;
z-index:1;
}
.style1 {
font-family: Arial, Helvetica, sans-serif;
color: #535959;
font-size: 12px;
}
-->
</style>
</head>
<body>
<div id="Layer1">
  <table width="800" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td height="97"><img src="images/header.jpg" width="800" height="59" border="0" usemap="#Map" /><br />
      <img src="images/navbar.jpg" width="800" height="38" border="0" usemap="#Map2" />
      <map name="Map2" id="Map2">
        <area shape="rect" coords="506,1,552,26" href="contact.php" /><area shape="rect" coords="459,1,502,26" href="form.php" /><area shape="rect" coords="396,-1,455,25" href="login.php" />
        <area shape="rect" coords="357,0,393,26" href="index.php" />
      </map>
      </td>
    </tr>
    <tr>
      <td><img src="images/welcome_img.jpg" width="131" height="21" /></td>
    </tr>
    <tr>
      <td><?php include("form.php"); ?></td>
    </tr>
    <tr>
      <td><img src="images/placeholderclouds_bottem.jpg" width="800" height="60" /></td>
    </tr>
  </table>
</div>
</body>
</html>

Here is the Core.php the error is referring to:

<?php
//CSM Solution Core. Rahul Parkar 2010
$_config = array();
$_config['db_type'] = "mysql";
$_config['db_server'] = "localhost";
$_config['db_username'] = "altimusw_csm";
$_config['db_password'] = ']17=rXh7tJ0~';
$_config['db_database'] = "altimusw_csm";
$_config['db_tbl_prefix'] = '';
$_config['user_table'] = "customers";
$_config['user_username'] = "username";
$_config['user_password'] = "password";
$_config['user_active'] = "approved";
$_config['user_role1'] = "prirole";
$_config['user_role2'] = "secrole";
$_config['pass_hash_func'] = "SHA1";
session_start();

function fetch_row($query)
{
        build_connection($db);
        sql_exec($db, $query, $result);
        sql_fetchone($result, $row);
        finish_connection($db);
        return $row;
}
 
function build_connection(&$db)
{
global $_config;
if ($_config['db_type'] == "mysql")
{
$db = mysql_connect($_config['db_server'], $_config['db_username'], $_config['db_password']) or die(mysql_error());
mysql_select_db($_config['db_database'], $db) or die(mysql_error());
}
}
 
function sql_exec(&$db, $query, &$result)
{
        global $_config;
        if ($_config['db_type'] == "mysql")
              $result = mysql_query($query, $db) or die(mysql_error() . "/$query");
}
 
function sql_fetchone(&$result, &$row)
{
global $_config;
      if ($_config['db_type'] == "mysql")
      {
              $row = mysql_fetch_assoc($result);
              @mysql_free_result($result);
      }
}

function sql_do(&$db, $query)
{
global $_config;
sql_exec($db, $query, $noclue);
finish_connection($db);
}

function finish_result(&$result)
{
global $_config;
if ($_config['db_type'] == "mysql")
@mysql_free_result($result);
}

function finish_connection(&$db)
{
global $_config;
if ($_config['db_type'] == 'mysql')
mysql_close($db);
}
 
function check_auth($username, $password)
{
global $_config;
      $row = fetch_row("SELECT `" . $_config['user_active'] . "`, `" . $_config['user_password'] . "`, " . $_config['pass_hash_func'] . "('" . $password . "') AS `passcheck`, `fname`, `lname` FROM `" . $_config['user_table'] . "` WHERE `" . $_config['user_username'] . "`='" . $username . "' LIMIT 1");
      if (!$row[$_config['user_active']]) { return -1; }
      else
      {
              if ($row[$_config['user_active']] != 1) { return -2; }
              else if ($row[$_config['user_password']] == $row['passcheck'])
              {
                      $_SESSION['username'] = $username;
                      $_SESSION['fname'] = $row['fname'];
  $_SESSION['lname'] = $row['lname'];
                      return 1;
              }
              else
              {
                      return -1;
              }
      }
}
 
function load_access()
{
global $_config;
        if ($_SESSION['username'])
        {
                $row = fetch_row("SELECT `" . $_config['user_role1'] . "` FROM `" . $_config['user_table'] . "` WHERE `" . $_config['user_username'] . "`='" . $_SESSION['username'] . "' LIMIT 1");
                $role1 = $row[$_config['user_role1']];
                $_SESSION['role1'] = $role1;
        }
        else
        {
                return -1;
        }
}

function has_level()
{
for ($i = 0; $i < func_num_args(); $i++)
{
if (func_get_arg($i) == $_SESSION['role1']) { return 1; }
}
return 0;
}
?>

hello,

I'm using this code:

<?php

  if (isset($_REQUEST['email']))
  {
 $name = $_REQUEST['name'] ;
 $email = $_REQUEST['email'] ;
 $code = $_REQUEST['code'] ;
 $from = $email;
    mail("email@email.com", "Winner request id: $name - code: $code",
    "From:" . $from);
    }
  $headers = "From:" . $from;
  header('Location: index.php?done');
  ?>

And I'm getting:

Code: [Select]
Warning: Cannot modify header information - headers already sent by (output started at /home/site/public_html/config.php:10) in /home/site/public_html/send.php on line 13
This worked before.

Many thanks