Wednesday, November 13, 2019

htaccess REWRITE URL with multiple Query String

.htaccess REWRITE URL with multiple Query String

RewriteEngine On

Options -Multiviews
Options +FollowSymLinks

#LoadModule rewrite_module modules/mod_rewrite.so 
#AddModule mod_rewrite.c

#RewriteBase /

#local pages
RewriteRule  ^US/([A-Za-z0-9-]+)/([A-Za-z0-9-]+)/?$  city.php?st=$1&cty=$2  [NC,L]

Visit my website : Taxi Website Designers.com

Sunday, November 3, 2019

PHP FIX has been blocked by CORS policy: No 'Access-Control-Allow-Origin' - SOLVED

PHP FIX has been blocked by CORS policy: No 'Access-Control-Allow-Origin'

In the PHP code above, I am telling the browser that site-a.com has permission to make cross-domain requests to my website. The second parameter of PHP’s header function has been set to FALSE so that it is not overwritten by any other Access-Control-Allow-Origin headers that we may add in the future.

Note that you may also come across examples like this on the web:

//Access-Control-Allow-Origin header with wildcard.
Access-Control-Allow-Origin: http://siteA.com
Access-Control-Allow-Methods: GET, POST, PUT
Access-Control-Allow-Headers: Content-Type

<p>In the PHP code above, we have used a wildcard character. The problem with this is that it will allow everybody to make Ajax requests to our website. This is a lazy solution that may introduce security risks.</p>

Friday, November 1, 2019

PHP MySQL multiple rows to JSON

Simple to store PHP MySQL to JSON with multiple rows result

<?php include('config.php'); 
 $mkt = mysqli_query($con,'select * from booking order by csdate DESC');
 //while

 //$mkt = mysqli_query($con, $sql);
$result = array("booknow" => array()); //create an associative array with a property called "dashboard_content", which is an array. (json_encode will convert an associative array to a JSON object)

if (check) {
    $rows = mysqli_fetch_assoc($mkt);
    if (!$rows) {
        echo "No results!";
    } else {
          while ($rows = mysqli_fetch_assoc($mkt)) {
            $pickup = $rows['pickup'];
            $drop = $rows['drop'];
            $csdate = date('m-d-Y @ h:i A', strtotime($rows['csdate']));
            $cmsgs = $rows['cmsgs'];
            $tstamp = $rows['tstamp'];
          //  $rstatus = 

            

            //append the current data to a new entry in the "dashboard_content" array
            $result["booknow"][] = array('pickup' => $cadd, 'drop' => $drop, 'csdate' => $csdate, 'cmsgs' => $cmsgs, 'tstamp' => $tstamp); 
        }
    }

}

    //now, output the whole completed result to one single, coherent, valid JSON array.
    echo json_encode($result); 
?>

MySQL & PHP References

Search This Blog