Hi... I am doing a PHP project.I had executed the project on 3 machines.For one machine it is showing a warning as follows.. warning
Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for '5.5/no DST' instead in C:\xampp\htdocs\document_lite\diverse.php on line 497
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for '5.5/no DST' instead in C:\xampp\htdocs\document_lite\diverse.php on line 510
I had checked the system time setting on all the 3 machines.There is no difference on the time setting..what should I do?I anybody have the idea plz help me..Its urgent..
Hi.. I am designing a tabless web page.The page contains 2 div sections.One is for menus and other is to display the contents of the page by clicking the menus.I don't want to use frames and iframes.Is it possible to do it using the div tag? The code I had used is show below.If any one knows please help me.. Thanks in advance...
There is an a problem on declaring variables on MYSQL stored procedure.The code I used I used is shown below.
DELIMITER $$
CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
PROCEDURE `emp`.`third_SP`()
/*LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'*/
BEGIN
DECLARE p1 int ;
SELECT Min(esal)
INTO pl
FROM employ;
END$$
DELIMITER ;
It shows the error message as ---------------------------------- error code :1327 undeclared variable p1 ---------------------------------- I am using MySQL 5.1.4.1..Using SQLYOG Enterprise Trial 7. 11 as GUI.Anyone plz help me.
I am using xampp-win32-1.7.3.I want to use Adodb.I had seen that adodb is included on xampp package(xampp/php/pear/adodb).I had used the following code to retrieve data from mysql database.
<?php
include("adodb.inc.php");
$db = NewADOConnection('mysql');
$db->Connect("localhost", "root", "", "emp");
$result = $db->Execute("SELECT * FROM employ");
if ($result === false) die("failed");
while (!$result->EOF) {
for ($i=0, $max=$result->FieldCount(); $i < $max; $i++)
print $result->fields[$i].' ';
$result->MoveNext();
print "<br>n";
}
?>
It displays the following error messages
Warning: include(adodb.inc.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\divya\adodb\adodbex.php on line 2
Warning: include() [function.include]: Failed opening 'adodb.inc.php' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\divya\adodb\adodbex.php on line 2
Fatal error: Call to undefined function NewADOConnection() in C:\xampp\htdocs\divya\adodb\adodbex.php on line 3
Error message Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Leave decimal(12,2) default NULL)' at line 1
If I type the query as.. create table emp2(Leav decimal(12,2) default NULL)
Then it will executed successfully..What is the problem with the field 'Leave'?Is it a key word?
I want to use the pear package.Pear is already on my xampp package.On the file php.ini the pear is included(I didn't change the file php.ini..there is a line like include_path = ".;c\xampp\php\PEAR").I used the following code to retrieve the results from database..But it is not working ..
<?php
// Include the appropriate PEAR classes
require_once("DB.php");
$dsn = array(
'phptype' => 'mysql',
'hostspec' => 'localhost',
'database' => 'emp',
'username' => 'root',
'password' => 'mysql'
);
$dbh = DB::connect($dsn);
$stmt = "SELECT id, name FROM examples ORDER BY id";
$result = $dbh->simpleQuery($stmt, DB_FETCHMODE_ASSOC);
if ($dbh->numRows($result) > 0) {
$data = (object) $dbh->fetchRow($result, DB_FETCHMODE_ASSOC);
echo "id => $data->id<br>\n";
echo "name => $data->name<br>\n";
}
?>
showing the errors like following ...
Warning: require_once(DB.php) [function.require-once]: failed to open stream: No such file or directory in C:\xampp\htdocs\divya\Pear-examples\dbconnect.php on line 3
Fatal error: require_once() [function.require]: Failed opening required 'DB.php' (include_path='.;c\xampp\php\PEAR') in C:\xampp\htdocs\divya\Pear-examples\dbconnect.php on line 3
