PHP - How Do I Convert Linux Epoch To Utc Format?

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!!

Hi I was going to start a new project which need to convert files from one fomrat to other like, you can check a site here  online-convert.com , there they give user to convert in various fomats. please check

my question is i have idea how to do these conversion with ffmpeg and php.
Code: [Select]
Audio converter
Video converter
Image converter
Hash generator
can someone please tell me how to do these conversion.
Code: [Select]
Document converter
Ebook converter

Thanks for any help

Hi,

I need to post to a form with cURL. I'am sending strings in Headers format...

There are some documentation or some function that translates from the human readable format to the Headers format?

For example:

Human readable format:
Quote

Vendo bicicleta. Como nova.


Headers format:
Quote

Vendo%20bicicleta.%20Como%20nova.


The problem is not the spaces but more the accents. I write in Portuguese.

Can you give me some clue?


Best Regards,

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 all,

I like to write scripts for my Aastra IP phone. 480i.

I have done all my scripts with Apache on windows. I thought I would try it on Linux with the AsteriskNOW FreePBX 1.4 load. Phone system software for those that do not know.

So my code is below something very simple to display on the screen. Ignore the $textmenu code that works fine. The problem is it does not open a file and do something then write the file.

On my Windows / Apache box the screen will display  on the phone and open the file and do whatever. On my Linux box it will display the screen fine but will not open that file.

Why would it be ingnoreing those PHP file commands? Any ideas? It file commands work if I run it with php script.php but not when I use my phone to launch that script. Now keep in mind Windows/Apache is fine no problem. I thought maybe it was a php.ini setting on the linux box?

<?php
$textmenu = "<AastraIPPhoneTextMenu style = \"numbered\">\n";
$textmenu .= "<Title>------- Test -------</Title>\n";

$textmenu .= "<MenuItem>\n";
$textmenu .= "<Prompt>Applications</Prompt>\n";
$textmenu .= "<URI>http://65.205.71.13/xml/menu/menu.php?source=all</URI>\n";
$textmenu .= "</MenuItem>\n";

$textmenu .= "<SoftKey index = \"1\">\n";
$textmenu .= "<Label>Select</Label>\n";
$textmenu .= "<URI>SoftKey:Select</URI>\n";
$textmenu .= "</SoftKey>\n";

$textmenu .= "<SoftKey index = \"6\">\n";
$textmenu .= "<Label>Exit</Label>\n";
$textmenu .= "<URI>SoftKey:Exit</URI>\n";
$textmenu .= "</SoftKey>\n";

$textmenu .= "</AastraIPPhoneTextMenu>\n";

echo $textmenu;



$fp=fopen("/var/www/html/aastra/awa-det/conference/test.txt","w+");
fwrite($fp);
fclose($fp);
?>

What are your feelings regarding Linux desktop distros, and their ability to break through to mainstream usage? I started using Ubuntu about 6 or 7 years ago, and have fooled around with some other distros, but at least for me Ubuntu always seemed the best. I've got my 65 year old mom using it, and my 11 year old son playing with Kubuntu (and learning python!). I don't really consider us normal though; normal being almost too dumb to do more than check email and get on the internet.   I've managed to fully switch over to Ubuntu on all of my computers, with the exception of running Windows in a VM for Photoshop and Illustrator. Since I don't use those programs every day, there are a lot of days where I don't see Windows. I never really had a problem with Windows, except for Windows 3.1 was kind of a drag. Getting on the internet on a 56K modem on Windows 95 wasn't any fun either, but that wasn't Windows' fault. I never had the crashes and bad experiences people like to claim makes Windows suck. My main reason for abandoning Windows is just to be more involved with Linux, and hopefully reach Linux guru status someday.   I really never liked Macs. I bought one 3 or 4 years ago, and it just felt like I was paying a lot of money for a glorified (and over-hyped) linux distro. I really never liked the feel of the Finder. At the time there was no awesome text editor, and I bought a couple just to test out what I could find. Unlike Windows and Linux, it seemed like nothing is free in the Mac world. I eventually gave the Mac away. We couldn't be friends.   I'd really like to see Linux become the dominant OS. It's exciting to see how far Ubuntu has come in the years that I've used it, and I evangelize for Linux/Ubuntu quite a bit. Even still, it can sometimes seem that I am a stranger in a strange world. Do you think we can count on Linux being a bigger part of mainstream computing? One of the problems I see is that there are so many distros that a person investigating Linux may be a little overwhelmed. What do you think is keeping the masses from using Linux desktops?

Sorry for posting this here, but for some reason the "create new topic" in linux subforum doesnt exist.


anyways i made a small php script that enables me to retrieve data between two dates. now am stuck on how i should copy it  or u0pload it into linux.

system tells me i need to upload to /usr/bin/libexec , i am there now but i dont have the slightest idea on how to do that.


help is much appreciated.

Thanks

Hi,
I am trying to use php to pass some commands to my linux box.From my webpage I am using the shell_exec function which is working OK but for some administrative tasks in linux I must have root access. As I am sending the commands from the webpage the apache user is used and so I am not allowed to do several tasks. I have also tried to use a bash script to pass the commands but with no result. Any ideas ?

Hi Guys

I am struggling with a shell_exec command in the long run, but I am trying to work down the root cause.

The error I am getting with shell_exec is a file not found error, so I thought I would start with getting to the right folder.

I have this

Code: [Select]
$sym_dir = "/root/";
$cwd = getcwd();
  echo getcwd()."\n";
  chdir ($sym_dir);
  echo getcwd()."\n";

Which in theory should 1st display '/var/www' as it does and then display the contents of root, at least that is my understanding!

However my return is this /var/www /var/www

Why cannot I move outside the web root?

Cheers
Dave

Hi,    Please I keep seeing this on my wordpress website Linux+cfcd208495d565ef66e7dff9f98764da+01+[[]].  I've tried to clear it out but to no avail. Does anyone has a solution? I will appreciate.   Thanks

I am new to Php and the linux environment.  I have written a php program which sames a file to folder using xampp in Windows but I am having a problem with the pathway using my Ubuntu server and LAMP.  My code I used in Windows was:

$fileName = "guessbook.txt";
$file = fopen ($fileName, "ab");
if(!$file)
{
    echo "ERROR! did not create the file! Exiting.<br />;
    exit();
}

This file was saved correctly using xampp into the htdoc folder and worked fine when I called it in my browser.  I tried to substitute a Linux pathway ie: /var/www/assignment2/guessbook.txt, where guessbook is in the code but still nothing.  Can someone explain how to write the correct pathway to save this file?

Thank you

Paul

My IDE (Nusphere's PhpED) runs on Windows but is configured so that both the web server as well as all project files are located on a development Linux server. Since the project files are located on the Linux server, the git repository is located there as well and not on my PC.  Every now again, my IDE complains that content was externally modified and whether I wish to reload the file.  Also, I was recently asked to set git's core.autocrlf to true on a project I was collaborating on which prevented me from adding any changes to git (git complained that LF will be replaced by CRLF).

The IDE allows file encoding to be changed (system default, UTF-8, Windows-1252, or ISO-8859-01) as well as the default file format (Unix, Windows, Mac, or autodetect).

Any recommendations on how best to configure git and these ide settings?

Thanks