[PHP Time() in MySQL]

Use FROM_UNIXTIME() MySQL function

[build a dynamic mega drop down menu using php]

try using this

 

http://www.phpclasses.org/package/5927-PHP-Display-an-hierarchic-menu-stored-in-a-MySQL-table.html

[Newline Carriage return in string]

try using like this

$serial->sendMessage("The big Brown Fox jumped over the cold lazey dog <br>");

[problem with saving an object]

explained with examples

 

http://in3.php.net/manual/en/function.urlencode.php

http://in3.php.net/manual/en/function.urldecode.php

 

you can check other function too

[Removing 0s from comma seperated value]

@dweb, the function given by Psycho should work now

 

@Psycho, thanks for noticing the issue of "0" at first and last position

[How to fix Fatal Error PHPExcel: Memory Limit Exhausted while reading XLSX file of 5M]

you can also set memory limit using ini_set function on that page like this

ini_set("memory_limit","256M");

[Removing 0s from comma seperated value]

use javascript replace function

var elm = document.getElementById('fieldx').value;
elm.replace("0","");

after replacing "0" from string it will give output as "1,,23,,99", now replace ",," to blank

elm.replace(",,","");

try this

[I unable to echo date in HTML table]

<td style="font-size: 100%;"><b>Weather History for' echo date("D M jS"); '</b></td>

above line should be like this

<td style="font-size: 100%;"><b>Weather History for '.date("D M jS").'</b></td>

[importing multiple files into different mysql tables]

You can disable notice error through php.ini file or you need to declare every variable at top.

 

And regarding warning errors (line 161,162), you need to give read, write permission to folder "/home/venzo/public_html/admin/files/"

 

 

may this will help you

[slideshow in javascript]

You need to call slideit() after callnow() function where ever you want to use the slide show or else u can call slideit() function in callnow() function, then u don't need to call slideit() function after callnow() function.

 

may this will help you.

[form submit with image]

you can use image tag instead of input tag and can submit using javascript

<img src="img/progress.png" onclick="document.FORMNAME.submit();">

[Align picture within fieldset ,Help!]

give 100% percent width to table tag and use align="right" in td tag

[Export data from multiple databases with one single select statement]

i think it will not work through phpmyadmin, you can use sqlyog (MySQL GUI Tools), download it from here https://www.webyog.com/

 

now when you will execute multiple queries in sqlyog query editor, it will give you multiple result in different tabs below the editor, now you will need to export this result one by one in which ever format you want (i.e. csv,sql etc.)

 

may this will help you

[Export data from multiple databases with one single select statement]

try using DATABASENAME.TABLENAME in you select query like this

SELECT `NickName`,`FirstName`,`LastName`,`Email` FROM DATABASENAME.Profiles;

[Fatal error: Cannot redeclare mime_content_type()]

replace tilt(`) character with quote (") in the line

return trim( "file -bi $f" ); 

[extract the middle part of this url]

try using parse_url() php function

 

refer: http://php.net/manual/en/function.parse-url.php

[FTP Godaddy]

first check ftp_connect, is connection working properly with given details

 

replace this line

$conn_id = ftp_connect($ftp_server);

with and check the connection

$conn_id = ftp_connect($ftp_server) or die("Couldn't connect to $ftp_server"); 

[Textbox onChange, run PHP]

so to avoid reloading a page you should use AJAX

 

refer this url: http://www.w3schools.com/php/php_ajax_database.asp

[Textbox onChange, run PHP]

First option is that you can submit the form to search.php page on onchange event of textbox

And second you can use AJAX

[syntax error - unexpected }]

your semicolon ( ; )  is after curly bracket ( } ), bracket should be after semicolon

[PHP simple mail query]

use any php mailer class, you can check this url

 

http://www.phpclasses.org/search.html?words=php+mailer&x=-421&y=-163&go_search=1

[PHP simple mail query]

Try using this this headers

$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= "From: \"ClairVision Network\" <\"admin@clairvision.net\">\r\n";

[Simple XML parsing problem]

According to XML you will get values like this

$data = "http://www.mesquiteweather.net/xml/mesquite.xml";
$xml = simplexml_load_file($data);
$fname = $xml->fname;
$lname = $xml->lname;
$location = $xml->location;
$report = $xml->report;
$description = $xml->description;

[Trying to cApitalize only the second letter in a sentence]

Try this

$result = str_replace(substr($word,1,1),ucfirst(substr($word,1,1)),$word);

[Urgent : PHP error message]

Please check your MySQL query