تالار گفتمان nCIS.ir

$query="SELECT * FROM dating WHERE t_fdate LIKE BETWEEN '%$get_date3%' AND '%$get_date4%' ";

نقل قول:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:xampphtdocsTaghvim-2process.php on line 98

while($user=mysql_fetch_assoc($records))

if (isset($_POST["submit3"])) {
    
    $get_date3=$_POST["fdate3"];
    $get_date4=$_POST["fdate4"];
    echo ' <table border="1" >
        <tr>
          <th>Row</th>
          <th>Persian Date</th>
          <th>Milade Date</th>
        </tr>
        ';
    
        mysql_query('set names "utf8"');
        $query="SELECT * FROM dating WHERE t_fdate LIKE BETWEEN '%$get_date3%' AND '%$get_date4%' ";
        $records=mysql_query($query);

    
       while($user=mysql_fetch_assoc($records))
       {
         echo '<tr>';
         echo "<td>".$user['t_id']."</td>";
         echo "<td>".$user['t_fdate']."</td>";
         echo "<td>".$user['t_edate']."</td>";      
         echo "</tr>";
       }
        echo '</table>' ; 
    
    echo '<br />';
    echo '<a href="index.php">Go back</a>';

}
else {  
   echo "Error in submit-3";
}

$start = jmktime(0, 0, 0, 1, 1, 1395);
$end = jmktime(23, 59, 59, 29, 12, 1395);
$query = "SELECT * FROM dating WHERE t_fdate BETWEEN {$start} AND {$end}";

if (isset($_POST["submit1"])) {
    
   $fa_date=$_POST["fdate"];
   $en_date=date("Y/m/d");
   
   mysql_query('set names "utf8"');
   $qry = "INSERT INTO dating(t_fdate, t_edate) VALUES('$fa_date','$en_date')";
   $result = mysql_query($qry);
   echo "Inserrt record";
   echo '<br />';
   echo '<a href="index.php">Go back</a>';
}
else {  
   echo "Error";
}

<?php
//(isset($_POST["submit1"]) && !empty($_POST["fdate"]))    
if (isset($_POST["submit5"])) {
   //$created_date = date("Y-m-d H:i:s");
   $created_date=time();
   mysql_query('set names "utf8"');
   $qry = "INSERT INTO bingo(b_val) VALUES('$created_date')";
   $result = mysql_query($qry);
   echo "Inserrt record";
   echo '<br />';
   echo '<a href="index.php">Go back</a>';
}
else {  
   echo "Error in submit-1";
}

echo date('l j F Y - H:i:s', $row['b_val']); // Gregorian format
echo jdate('l j F Y - H:i:s', $row['b_val']); // Jalali format

<?php
 
if (isset($_POST["submit6"])) {
$con=mysqli_connect("localhost","root","","taghvim");
// Check connection
if (mysqli_connect_errno())
 {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }

   
$timezone = 0;//برای 3:30 عدد 12600 و برای 4:30 عدد 16200 را تنظیم کنید
$now = date("Y-m-d", time()+$timezone);
$time = date("H:i:s", time()+$timezone);
list($year, $month, $day) = explode('-', $now);
list($hour, $minute, $second) = explode(':', $time);
$timestamp = mktime($hour, $minute, $second, $month, $day, $year);
include ('jdf.php');
$jalali_date = jdate("زمان: H:i:s - تاریخ: Y/m/d",$timestamp);
//echo $jalali_date;
   
   
$sql="SELECT * FROM bingo";
$result=mysqli_query($con,$sql);

// Associative array
$row=mysqli_fetch_assoc($result);
echo date('l j F Y - H:i:s', $row['b_val']); // Gregorian format
   echo "<br />";
echo $jalali_date('l j F Y - H:i:s', $row['b_val']); // Jalali format    

// Free result set
mysqli_free_result($result);

mysqli_close($con);    
}

?>

نقل قول:

Wednesday 27 July 2016 - 07:27:38

Fatal error: Call to undefined function زمان: ۱۳:۰۷:۳۷ - تاریخ: ۱۳۹۵/۰۵/۰۶() in C:xampphtdocsTaghvim-2process.php on line 159

echo $jalali_date('l j F Y - H:i:s', $row['b_val']); // Jalali format    

echo $jalali_date; // Jalali format

<?php
 
if (isset($_POST["submit6"])) {
$con=mysqli_connect("localhost","root","","taghvim");
// Check connection
if (mysqli_connect_errno())
 {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }
   
$timezone = 0;//برای 3:30 عدد 12600 و برای 4:30 عدد 16200 را تنظیم کنید
$now = date("Y-m-d", time()+$timezone);
$time = date("H:i:s", time()+$timezone);
list($year, $month, $day) = explode('-', $now);
list($hour, $minute, $second) = explode(':', $time);
$timestamp = mktime($hour, $minute, $second, $month, $day, $year);
include ('jdf.php');
$jalali_date = jdate("زمان: H:i:s - تاریخ: Y/m/d",$timestamp);
//echo $jalali_date;
   
   
$sql="SELECT * FROM bingo";
$result=mysqli_query($con,$sql);

// Associative array
$row=mysqli_fetch_assoc($result);
echo date('l j F Y - H:i:s', $row['b_val']); // Gregorian format
   echo "<br />";
//echo $jalali_date('l j F Y - H:i:s', $row['b_val']); // Jalali format    
echo $jalali_date;
// Free result set
mysqli_free_result($result);

mysqli_close($con);    
}

?>

list($sy, $sm, $sd) = explode('-', '1395-05-12');
list($ey, $em, $ed) = explode('-', '1395-05-28');
$sts = jmktime(0, 0, 0, $sm, $sd, $sy); // Start Timestamp
$ets = jmktime(0, 0, 0, $em, $ed, $ey); // End Timestamp
$query = "SELECT * FROM `table` WHERE (`ts` BETWEEN {$sts} AND {$ets})");

<?php
  
if (isset($_POST["submit8"])) {
mysql_connect('localhost','root','');
mysql_select_db('taghvim');
   
   
$date1=$_POST['fdate7'];    
$date2=$_POST['fdate8'];

list($sy, $sm, $sd) = explode('-', '$date1');    
list($ey, $em, $ed) = explode('-', '$date2');        
   
   
$sts = jmktime(0, 0, 0, $sm, $sd, $sy); // Start Timestamp    
$ets = jmktime(0, 0, 0, $em, $ed, $ey); // End Timestamp    

echo '
   <table class="table" style="font-size:12px">
       <tr>
         <th>ردیف</th>
         <th>تاریخ های جستجو شده</th>
       </tr>
       ';
       
   
       mysql_query('set names "utf8"');
       $query="SELECT * FROM bingo WHERE b_val BETWEEN $sts AND $ets";
       $records=mysql_query($query);

   
while($user=mysql_fetch_assoc($records))
      {
        echo "<tr>";
        echo "<td>".$user['b_id']."</td>";
        echo "<td>".$user['b_val']."</td>";
        echo "</tr>";
      }
       echo '</table>';
    
}

?>
     

نقل قول:

Notice: Undefined offset: 2 in C:xampphtdocsTaghvim-2process.php on line 180

Notice: Undefined offset: 1 in C:xampphtdocsTaghvim-2process.php on line 180

Notice: Undefined offset: 2 in C:xampphtdocsTaghvim-2process.php on line 181

Notice: Undefined offset: 1 in C:xampphtdocsTaghvim-2process.php on line 181

Fatal error: Call to undefined function jmktime() in C:xampphtdocsTaghvim-2process.php on line 184