Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   Change database from mysql 4 to mysql 5 affects my calendar event page (http://www.go4expert.com/forums/change-database-mysql-4-mysql-5-affects-t23621/)

newphpcoder 20Oct2010 06:35

Change database from mysql 4 to mysql 5 affects my calendar event page
 
I changed my database from mysql 4.1.10 to mysql 5.0 and I encountered error in my calendar event page. The output of my calendar date was change instead of date it becomes “>” and also when I press the button to move to another month I can’t move to another month. I have no idea why it happened.
Here is the old calendar code:

PHP Code:

<?php
                $dbCnx 
= @mysql_connect("localhost","""") or die('Could not Connect to the database')
                
mysql_select_db("mydb");         
?>
<html>
<script>
function goLastMonth(month, year){
if(month == 1){
--year;
month = 13;
}
document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month-1)+'&year='+year;
}
function goNextMonth(month, year){
if(month == 12){
++year;
month = 0;
}
document.location.href = '<?=$_SERVER['PHP_SELF'];?>?month='+(month+1)+'&year='+year;

function remChars(txtControl, txtCount, intMaxLength)
{
if(txtControl.value.length > intMaxLength)
txtControl.value = txtControl.value.substring(0, (intMaxLength-1));
else
txtCount.value = intMaxLength - txtControl.value.length;
}
function checkFilled() {
var filled = 0
var x = document.form1.calName.value;
if (x.length > 0) {filled ++}
var y = document.form1.calDesc.value;
if (y.length > 0) {filled ++}
if (filled == 2) {
document.getElementById("Submit").disabled = false;
}
else {document.getElementById("Submit").disabled = true} // in case a field is filled then erased
}
</script>
<body>
<?php
$day 
= (isset($_GET["day"])) ? $_GET['day'] : "";
$month = (isset($_GET["month"])) ? $_GET['month'] : "";
$year = (isset($_GET["year"])) ? $_GET['year'] : "";
if(empty(
$day)){ $day date("j"); }
if(empty(
$month)){ $month date("n"); }
if(empty(
$year)){ $year date("Y"); } 
$currentTimeStamp strtotime("$year-$month-$day");
$monthName date("F"$currentTimeStamp);
$numDays date("t"$currentTimeStamp);
$counter 0;
function 
hiLightEvt($eMonth,$eDay,$eYear){
$todaysDate date("n/j/Y");
$dateToCompare $eMonth '/' $eDay '/' $eYear;
if(
$todaysDate == $dateToCompare){
$aClass='class="today"';
}else{
$sql="select count(calDate) as eCount from calTbl where calDate = '" $eMonth '/' $eDay '/' $eYear "'";
$result mysql_query($sql);
while(
$rowmysql_fetch_array($result)){
if(
$row['eCount'] >=1){
$aClass 'class="event"';
}elseif(
$row['eCount'] ==0){
$aClass ='class="normal"';
}
}
}
return 
$aClass;
}
?>
<div id="Calendar_Event">
<table width="350" cellpadding="0" cellspacing="0">
<tr>
<td width="50" colspan="1">
<input type="button" value=" < " onClick="goLastMonth(<?php echo $month ", " $year?>);">
</td>
<td width="250" colspan="5">
<span class="title" style="color:#FFFFFF"><?php echo $monthName " " $year?></span><br>
</td>
<td width="50" colspan="1" align="right">
<input type="button" value=" > " onClick="goNextMonth(<?php echo $month ", " $year?>);">
</td>
</tr> 
<tr>
<th>M</td>
<th>T</td>
<th>W</td>
<th>T</td>
<th>F</td>
<th>S</td>
<th>S</td>
</tr>
<tr>
<?php
for($i 1$i $numDays+1$i++, $counter++){
$dateToCompare $month '/' $i '/' $year;
$timeStamp strtotime("$year-$month-$i");
if(
$i == 1){
$firstDay date("N"$timeStamp);
for(
$j 1$j $firstDay$j++, $counter++){
echo 
"<td>&nbsp;</td>";

}
if(
$counter == ){
?>
</tr><tr>
<?php
}
?>
<!--right here--><td width="50" <?=hiLightEvt($month,$i,$year);?>><a href="<?=$_SERVER['PHP_SELF'] . '?month='. $month . '&day=' . $i . '&year=' . $year;?>&v=1"><?=$i;?></a></td> 
<?php
}
?>
</table>
</div>
<div id="New_Event">
<?php
if(isset($_GET['v'])){
if(isset(
$_POST['Submit'])){
$sql="insert into calTbl(calName,calDesc,calDate,calStamp) values('" $_POST['calName'] ."','" $_POST['calDesc'] . "','" $_POST['calDate'] . "',now())";
mysql_query($sql);
}
$sql="select calName,calDesc, DATE_FORMAT(calStamp, '%a %b %e %Y') as calStamp from calTbl where calDate = '" $month '/' $day '/' $year "'";
$result mysql_query($sql);
$numRows mysql_num_rows($result);
if (
$_SESSION['username']=="user1"

$check1=mysql_query("SELECT * FROM tbllogin WHERE Username='user1' AND Department='Staff' AND Permission='True'"); 
$check2 mysql_fetch_array($check1); 
$username $check2['Username']; 
$dep $check2['Department']; 
$permiss $check2['Permission']; 
if(
$username=="user1" && $dep=="Staff" && $permiss=="True"){ 
$_SESSION['isallowed'] = $check2['Permission']; 
?> 
<a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">Add Even</a><a href="<?=$_SERVER['PHP_SELF'];?>?month=<?=$_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">t</a>
<?php  

}
else 
{ echo 
"You cannot Add New Event"; } 
?>
</div>
<div id="Cal_Event">
<?php
if(isset($_GET['f'])){
include 
'calform.php';
}
if(
$numRows == ){
echo 
'';
}else{
echo 
'<h3>Event Listed</h3>';
while(
$row mysql_fetch_array($result)){
?>
<h5><?=$row['calName'];?></h5>
<?=$row['calDesc'];?><br/>
Listed On: <?=$row['calStamp'];?>
<?php
}
}
}
?>
</div>
</body>
</html>



On my new codes I only change the codes for the connection of database like the “host”, ”username”, ”password”, ”database name”, “table name”.
Honestly, I have no idea why it happened after I change my database. Actually my tbluser was work so I connected in my database on my other webpage.
Any help is highly appreciated. Thank you in advance.


All times are GMT +5.5. The time now is 20:59.