encode multiple rows to json in php mysql

how to encode multiple rows from mysql table to php encode_json?

very simple!

$result = mysqli_query($con,'select uno,ucode,uref,uname,uphone,uemail from usermst order by uname ASC'); $rows = array(); while($r = mysqli_fetch_assoc($result)){ $rows[] = array('data' => $r); } echo json_encode($rows);

How to recover data from WannaCry Ransomware affected computers?

What is WannaCry?

WannaCry is a ransomware program targeting Microsoft’s Windows operating system. Ransomware is a kind of cyber-attack where hackers can take control of your computer, and keep you from using it or accessing your data until you make a payment to the hackers. If you don’t, they can even delete everything.

How does WannaCry affect my computer?

If you don’t, they can delete everything on your computer

How much is ransom paid to WannaCry?

The hackers demanded payments of $300 to $600 (roughly Rs. 19,000 and Rs. 38,000) which were to be paid using Bitcoins.

Who all infected by WannaCry Virus?

The British NHS, international shipper FedEx, telecommunications company Telefonica and others were among the targets.

How to recover your data?

• Turn off your computer
• Create a Bootable USB from clean desktop or laptop
• Change boot preferences to USB on your infected PC Bios
• Boot from USB Pen-Drive
• Take backup of all important data & let go videos & images
• format your computer
• REINSTALL WINDOWS

Adding multiple input elements dynamically to a form

Simple Way to Add multiple input elements or formset to a html form when you need extra multiple formsets.

<div class="container1"> <button class="add_form_field">Add New Field   <span style="font-size:16px; font-weight:bold;">+ </span> </button> <div class="xset"><table id="tbl4"><tr><td width="50%"><label>Type of Game Edition</label><input type="text" id="game_editions" name="game_editions[]"></td><td width="50%" rowspan="3"><label>Edition Description</label>>textarea id="edition_desc" name="edition_desc[]" placeholder="Type in Editions description of the Game">>/textarea></td></tr><tr><td><label>Edition Image Link</label><input type="text" id="edition_img" name="edition_img[]"></td></tr><tr><td><a href="#" class="delete">Delete</a></td></tr></table></div> </div> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function() { var max_fields = 10; var wrapper = $(".container1"); var add_button = $(".add_form_field"); var x = 1; $(add_button).click(function(e) { e.preventDefault(); if (x < max_fields) { x++; $(wrapper).append('<div class="xset"><table id="tbl4"><tr><td width="50%"><label>Type of Game Edition</label><input type="text" id="game_editions" name="game_editions[]"></td><td width="50%" rowspan="3"><label>Edition Description</label>>textarea id="edition_desc" name="edition_desc[]" placeholder="Type in Editions description of the Game">>/textarea></td></tr><tr><td><label>Edition Image Link</label><input type="text" id="edition_img" name="edition_img[]"></td></tr><tr><td><a href="#" class="delete">Delete</a></td></tr></table></div>'); //add input box } else { alert('You Reached the limits') } }); $(wrapper).on("click", ".delete", function(e) { e.preventDefault(); $(this).parent('div').remove(); x--; }) }); </script>

PaisaBazaar.com Improve your credit score is a scam???

I dont know how they do it, i mean IMPROVE MY CREDIT SCORE by just paying Rs.1200 as am having little overdue BAD LOANS.

Once I paid Rs 1200 they disappeared on my. No buggar calls me or take my calls??? Wow!!! Thats Very Scary

.

CreditSudhar.com -- Scams

One of my friend had even bad experience with CreditSudhaar.com. These bastards are even very intelligent scamsters. They charged him some Rs. 3000 as fee & took all his details. Then left a remark of Rs.12000 as some fee or bad loan & screwed his CREDIT RATING --- and this bugger ended up paying Rs.22000 to resolve the issue with CREDIT SUDHAR.

waiting for alexgorbatchev.com [solved]

Very simple way to avoid "waiting for alexgorbatchev.com" is to CHANGE YOUR BLOGSPOT THEME to SIMPLER ONE

Thats it!!! Hope you like it

how to generate sha1 key in windows for Firebase & Android App

it is very simple to create SHA1 PrivateKeyEntry with Javascript Keytool for Firebase & Andriod App

1. keytool –keystore clientkeystore –genkey –alias client
2. keytool -exportcert -list -keystore clientkeystore

How to Get Alexa Ranking for your Website for FREE???

It is very simple to get ALEXA RANKING for your website

Install Google Chrome ALEXA TRAFFIC RANK extention
Keep Hitting your website for a 7-10 days
Even you can ask your friends to do he same

Voila!!! Your website will be placed somewhere btw 7 MILLION-th rank.
This shit I dont understand. How many websites are placed in 7th million ranking
Never mind. ALAXA RANKING IS IMPORTANT

Alexa Ranking - Why it is fake and Scam?

Bcoz ALEXA RANKING IS PAID

IF YOU DONT PAY THEM - YOU WILL NOT BE GIVE alexa ranking

Thats greed of AMAZON & fakery, foolery of ALEXA

Insert Multiple Checkbox Values in MySQL column Using PHP

This is how you can save values of a set of checkbox to an one variable to store the collective values of all checkboxes to one mysql column

<form action="" method="post" enctype="multipart/form-data"> <div style="width:200px;border-radius:6px;margin:0px auto"> <table border="1"> <tr> <td colspan="2">Select Technolgy:</td> </tr> <tr> <td>PHP</td> <td><input type="checkbox" name="techno[]" value="PHP"></td> </tr> <tr> <td>.Net</td> <td><input type="checkbox" name="techno[]" value=".Net"></td> </tr> <tr> <td>Java</td> <td><input type="checkbox" name="techno[]" value="Java"></td> </tr> <tr> <td>Javascript</td> <td><input type="checkbox" name="techno[]" value="javascript"></td> </tr> <tr> <td colspan="2" align="center"><input type="submit" value="submit" name="xsubmit"></td> </tr> </table> <?php if(isset($_POST["xsubmit"]{ $checkbox1=$_POST['techno']; $chk=""; foreach($checkbox1 as $chk1) { $chk .= $chk1.","; } } ?>

PHP setcookie for both localhost and domain

something it wasn't clear to me for a while was that domain names must contain at least two dots (.), hence 'localhost' is invalid and the browser will refuse to set the cookie! instead for localhost you should use false.

to make your code work on both localhost and a proper domain, you can do this:

<?php $domain = ($_SERVER['HTTP_HOST'] != 'localhost') ? $_SERVER['HTTP_HOST'] : false; setcookie('cookiename', 'data', time()+60*60*24*365, '/', $domain, false); ?>

Godaddy Hosting Renewal Scams - is true

GoDaddy induggles in Hosting Renewal Scams

It is well known fact that Godaddy fleece & squeeze & screw its customer who are its longtime clients with huge data & multiple website of various size portals & vortals including high networth eCommerce, corporate, Business websites and they leave none to fool & cheat their customers

GoDaddy Scam Modus Operandi

This is how GoDaddy trick you before suspending your hosting a/c as soon as it expires not a day extension. These days many customers have more than one domain with hosting and you never know what product has expired

What happens when GoDaddy suspends your hosting a/c?

• Customers buy MULTIPLE DOMAINS & do not want to RENEW DOMAINS that they bought on GoDaddy and let it go
• GoDaddy SUSPEND these unsuspected CUSTOMERS A/C without intimating that YOUR HOSTING EXPIRING
• GoDaddy Suspends you Hosting A/c and never intimate THRU mail IN SUBJECT LINE it is that your HOSTING is EXPIRING and not DOMAIN
• Suspension of Hosting means you lost all data - your website files, backend database and E-Mail A/c will be deleted at once
• Supension of Hosting means YOU LOOSE EVERYTHING - Website, valuable database and E-mails

How Godaddy Fleece its Customer

• Godaddy charge you $1000 to restore hosting from its backup - that is outrageous
• and also they charge you exorbitant HOSTING RENEWAL CHARGES $240 per year + TAX
• and include WORKSPACE EMAIL that customers DID NOT BUY - ADDITIONAL CHARGES
• E-Mail & Office will be RENEWED - ADDITIONAL CHARGES
• and many more services which you did not subscribe
• If you have SSL for your multiple domains will go add up to $300 + TAX per year for each obsolete & inferior SSL Certificates that is not of Security Standards
• BUT ONCE YOU PAID ALL THESE & UNKNOWN CHARGES - your website comes alive in let then a MINUTE

Osolete Services of GoDaddy

GoDaddy SERVERS has 93.4% UPTIME its E-mail headers are INSECURED & all most all WebMail Servers lables emails from GoDaddy E-mail server as SPAM. Many a times godaddy your website content disappears DUE TO CHANGED SERVER SETTINGS & MISCONFIGURATION by stupid systems engineers of Godaddy.

Finally, GoDaddy is only 70% RELIABLE
10% SCAMS
10% MISCONFIGURATION
10% unreliable & culmination of obsolete technology & new technology might make you happy & cheated as well

How Much Godaddy Fleeced Me & my clients

All my clients and my business websites were deleted by Godaddy without intimation . My Hosting A/c on GoDaddy was for 7 years with more than 140+ website of my clients hosted were SUSPENDED BY GODADDY and tried to fleece me INR 63,000 ($1000 2 years ago) + GST + HOSTING RENEWAL. Fortunately I had backups and regularly backup mine and clients websites & backend data. and I decided to buy DEDICATED SERVER from another reputed hosting company in US

December 2019 my client in South Dakota was suspended by Godaddy & charged $300 to restore + Hosting Renewal and I had to call immediatly godaddy to cancel unwanted services like Workspace Email that Godaddy sold to my client after renewal

Today in New Jersey, my client had 18 websites hosted & had hosted for over 17 years was SUSPENDED & fleeced $1200 + $380 Hosting Renewal + TAX

and I do not recommend GODADDY but go with Google or Amazon Cloud Servcies but choose what & how much technology you are looking for to run your business or you can go with Dedicated Server that comes at renewal cost of GODADDY's ULTIMATE LINUX HOSTING

PHP Server-Side CORS Header for Cordova PhoneGap Ionic

PHP Server-side CORS header for Cordova, PhoneGap and Ionic

header('Access-Control-Allow-Origin: http://app.nearests.com/'); header('Access-Control-Max-Age: 3600'); header('Access-Control-Allow-Methods: GET, POST, PUT, DELETE'); <textarea> <p>Hope that will help mankind of CORS & CrossDomain Errors</p> <div style='clear: both;'></div> </div> <div class='post-footer'> <div class='post-footer-line post-footer-line-1'> <span class='post-author vcard'> Posted by <span class='fn' itemprop='author' itemscope='itemscope' itemtype='http://schema.org/Person'> <span itemprop='name'>Hydhost.com</span> </span> </span> <span class='post-timestamp'> at <meta content='http://msql-php.blogspot.com/2020/05/php-server-side-cors-header-for-cordova.html' itemprop='url'/> <a class='timestamp-link' href='https://msql-php.blogspot.com/2020/05/php-server-side-cors-header-for-cordova.html' rel='bookmark' title='permanent link'><abbr class='published' itemprop='datePublished' title='2020-05-28T11:46:00-07:00'>11:46 AM</abbr></a> </span> <span class='post-comment-link'> <a class='comment-link' href='https://msql-php.blogspot.com/2020/05/php-server-side-cors-header-for-cordova.html#comment-form' onclick=''> No comments: </a> </span> <span class='post-icons'> <span class='item-control blog-admin pid-1079127077'> <a href='https://www.blogger.com/post-edit.g?blogID=90790251245063676&postID=5105439217725880476&from=pencil' title='Edit Post'> <img alt='' class='icon-action' height='18' src='https://resources.blogblog.com/img/icon18_edit_allbkg.gif' width='18'/> </a> </span> </span> <div class='post-share-buttons goog-inline-block'> </div> </div> <div class='post-footer-line post-footer-line-2'> <span class='post-labels'> Labels: <a href='https://msql-php.blogspot.com/search/label/cordova' rel='tag'>cordova</a>, <a href='https://msql-php.blogspot.com/search/label/CORS' rel='tag'>CORS</a>, <a href='https://msql-php.blogspot.com/search/label/crossdomain' rel='tag'>crossdomain</a>, <a href='https://msql-php.blogspot.com/search/label/phonegap' rel='tag'>phonegap</a>, <a href='https://msql-php.blogspot.com/search/label/php' rel='tag'>php</a> </span> </div> <div class='post-footer-line post-footer-line-3'> <span class='post-location'> </span> </div> </div> </div> </div> </div></div> <div class="date-outer"> <h2 class='date-header'><span>Sunday, May 24, 2020</span></h2> <div class="date-posts"> <div class='post-outer'> <div class='post hentry uncustomized-post-template' itemprop='blogPost' itemscope='itemscope' itemtype='http://schema.org/BlogPosting'> <meta content='90790251245063676' itemprop='blogId'/> <meta content='4182827950459464367' itemprop='postId'/> <a name='4182827950459464367'></a> <h3 class='post-title entry-title' itemprop='name'> <a href='https://msql-php.blogspot.com/2020/05/drag-google-map-pin-get-lattitude.html'>Drag Google Map Pin Get Lattitude Longitude Address</a> </h3> <div class='post-header'> <div class='post-header-line-1'></div> </div> <div class='post-body entry-content' id='post-body-4182827950459464367' itemprop='description articleBody'> <br /> <p>Here is best working example of on how to get Latitude Longitude and address while dragging google map pin to desired location</p> <br><br> <textarea class="code" style="width:100%;height:400px;"> <style> #myMap { height: 350px; width: 680px; } </style> <div id="myMap"></div> <input id="address" type="text" name="address" /><br/> <input type="text" id="latitude" placeholder="Latitude"/> <input type="text" id="longitude" placeholder="Longitude"/> <input type="text" id="latlong" placeholder="latlong" style="width:200px;" /> <script src="https://maps.googleapis.com/maps/api/js?v=3.exp&key=<YOUR_KEY>"></script> <script type="text/javascript"> var map; var marker; var myLatlng = new google.maps.LatLng(17.485550,78.387932); var geocoder = new google.maps.Geocoder(); var infowindow = new google.maps.InfoWindow(); function initialize(){ var mapOptions = { zoom: 18, center: myLatlng, mapTypeId: google.maps.MapTypeId.ROADMAP }; map = new google.maps.Map(document.getElementById("myMap"), mapOptions); marker = new google.maps.Marker({ map: map, position: myLatlng, draggable: true }); geocoder.geocode({'latLng': myLatlng }, function(results, status) { if (status == google.maps.GeocoderStatus.OK) { if (results[0]) { $('#latitude,#longitude').show(); $('#address').val(results[0].formatted_address); $('#latitude').val(marker.getPosition().lat()); $('#longitude').val(marker.getPosition().lng()); var latlng = marker.getPosition().lat() + ', ' + marker.getPosition().lng(); $('#latlong').val(latLng); infowindow.setContent(results[0].formatted_address); infowindow.open(map, marker); } } }); google.maps.event.addListener(marker, 'dragend', function() { geocoder.geocode({'latLng': marker.getPosition()}, function(results, status) { if (status == google.maps.GeocoderStatus.OK) { if (results[0]) { $('#address').val(results[0].formatted_address); $('#latitude').val(marker.getPosition().lat()); $('#longitude').val(marker.getPosition().lng()); infowindow.setContent(results[0].formatted_address); infowindow.open(map, marker); } } }); }); } google.maps.event.addDomListener(window, 'load', initialize); </script> </body> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"> </script>

Background Image resized when Soft keyboard is shown in Android iOS Ionic Cordova

After lot of bang bang finally I found solution to Make full screen CSS background image appear behind a mobile soft keyboard activated on Browser of Anroid Phone or Ionic or Cordova app background

background:url(img/bg.png); background-repeat: no-repeat; background-size: 100% auto; background-attachment: fixed;

BACKGROUND-SIZE : 100% AUTO -- does the magic

Show Hide DIV using Bootstrap without Javascript

This neat & clean way to SHOW/HIDE DIV without JAVASCRIPT but only BOOTSTRAP CLASS

<!DOCTYPE html> <html> <head> <meta name="format-detection" content="telephone=no"> <meta name="msapplication-tap-highlight" content="no"> <meta name="viewport" content="initial-scale=1, width=device-width"> <link rel="stylesheet" type="text/css" href="css/bootstrap.css"> <title>Nearests.com - Login</title> </head> <body> <div class="container"> <div class="row"> <a href="#Foo" class="btn btn-default" data-toggle="collapse">Toggle Foo</a> <button href="#Bar" class="btn btn-default" data-toggle="collapse">Toggle Bar</button> <div id="Foo" class="collapse"> This div (Foo) is hidden by default </div> <div id="Bar" class="collapse in"> This div (Bar) is shown by default and can toggle </div> </div> </div> <script type="text/javascript" src="js/jquery.min.js"></script> <script type="text/javascript" src="js/bootstrap.js"></script> </body> </html>

Visit my website Taxi Website Designerscom