MySQL & PHP References: March 2019

Sunday, March 31, 2019

City - Autocomplete JQuery Bootstrap4

City.php

<!DOCTYPE html>
<html>
<head>
    <title>Bootstrap Autocomplete with Dynamic Data Load using PHP Ajax</title>
 <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css" rel="stylesheet">
    <script src="https://code.jquery.com/jquery-2.1.4.min.js"></script>
   
 <style>
 .typeahead { border: 2px solid #FFF;border-radius: 4px;padding: 8px 12px;max-width: 300px;min-width: 290px;background: rgba(66, 52, 52, 0.5);color: #FFF;}
 .tt-menu { width:300px; }
 ul.typeahead{margin:0px;padding:10px 0px;}
 ul.typeahead.dropdown-menu li a {padding: 10px !important; border-bottom:#CCC 1px solid;color:#FFF;}
 ul.typeahead.dropdown-menu li:last-child a { border-bottom:0px !important; }
 .bgcolor {max-width: 550px;min-width: 290px;max-height:340px;background:url("world-contries.jpg") no-repeat center center;padding: 100px 10px 130px;border-radius:4px;text-align:center;margin:10px;}
 .demo-label {font-size:1.5em;color: #686868;font-weight: 500;color:#FFF;}
 .dropdown-menu>.active>a, .dropdown-menu>.active>a:focus, .dropdown-menu>.active>a:hover {
  text-decoration: none;
  background-color: #1f3f41;
  outline: 0;
 }
 </style> 
</head>
<body>
 <div class="bgcolor">
  <form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
  <label class="demo-label">Search City:</label><br/> <input type="text" name="txtCountry" id="txtCountry" class="typeahead"/>
  <input type="submit" name="csubmit" value=" Submit">
 </form>
 <?php if(isset($_POST["csubmit"])){
  print_r($_POST);
 } ?>
 </div>
</body>
<script>
    $(document).ready(function () {
        $('#txtCountry').typeahead({
            source: function (query, result) {
                $.ajax({
                    url: "server.php",
     data: 'query=' + query,            
                    dataType: "json",
                    type: "POST",
                    success: function (data) {
      result($.map(data, function (item) {
       return item;
                        }));
                    }
                });
            }
        });
    });
</script>
</html>

Search.php

<?php  
 $keyword = strval($_POST['query']);
 $search_param = "{$keyword}%";
 $conn =new mysqli('localhost', 'root', '' , 'weddingplanner');

 $sql = $conn->prepare("SELECT * FROM cities WHERE city LIKE ?");
 $sql->bind_param("s",$search_param);   
 $sql->execute();
 $result = $sql->get_result();
 if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
  $countryResult[] = $row["city"] . ' - ' . $row["state"];
  }
  echo json_encode($countryResult);
 }
 $conn->close();
?>

Tuesday, March 19, 2019

Remove PostCSS warning IONIC

Try this

find sass.js file. under /node_modules/@ionic/app-scripts/dist/sass.js
find var postcssOptions and add from: undefined,

Finally should be like this:
var postcssOptions = {
from: undefined,
to: path_1.basename(sassConfig.outFile),
map: autoPrefixerMapOptions
};

Ionic Cordova - spawn EACCES [SOLVED]

While building ionic app I was struck here

JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk1.8.0_202.jdk/Contents/HomeError:
spawn EACCES

and solution is simple

This is the command that finally fixed it for MY configuration
sudo chmod 777 “/Applications/Android Studio.app/Contents/gradle/gradle-4.1/bin/gradle”
Note the space in 'Android Studio'

What is the root problem? I don't know. I do know that I recently downloaded the new android studio 3 and then this started being a problem. It probably is something to do with the 'gradle-4.1'.

On a lot of other threads that contain this same issue there is someone strongly advising against just 'chmod'ing random folders, and I see his point, but I tried everything else.

OSX JAVA_HOME openjdk-11.0.2.jdk Error Requirements check failed for JDK 1.8 or greater

1.Remove all the Java related packages (Sun, Oracle, OpenJDK, IcedTea plugins, GIJ):

dpkg-query -W -f='${binary:Package}\n' | grep -E -e '^(ia32-)?(sun|oracle)-java' -e '^openjdk-' -e '^icedtea' -e '^(default|gcj)-j(re|dk)' -e '^gcj-(.*)-j(re|dk)' -e '^java-common' | xargs sudo apt-get -y remove
sudo apt-get -y autoremove

2.Purge config files (careful. This command removed libsgutils2-2 and virtualbox config files too):

dpkg -l | grep ^rc | awk '{print($2)}' | xargs sudo apt-get -y purge

3.Remove Java config and cache directory:

sudo bash -c 'ls -d /home/*/.java' | xargs sudo rm -rf

4.Remove manually installed JVMs:

sudo rm -rf /usr/lib/jvm/*

5.Remove Java entries, if there is still any, from the alternatives:

for g in ControlPanel java java_vm javaws jcontrol jexec keytool mozilla-javaplugin.so orbd pack200 policytool rmid rmiregistry servertool tnameserv unpack200 appletviewer apt extcheck HtmlConverter idlj jar jarsigner javac javadoc javah javap jconsole jdb jhat jinfo jmap jps jrunscript jsadebugd jstack jstat jstatd native2ascii rmic schemagen serialver wsgen wsimport xjc xulrunner-1.9-javaplugin.so;

do sudo update-alternatives --remove-all $g;

done

6.Search for possible remaining Java directories:

sudo updatedb
sudo locate -b '\pack200'

7.Install JAVA-8-SDK

sudo add-apt-repository ppa:webupd8team/java
sudo apt-get install oracle-java8-installer

8.Open

sudo gedit ~/.bashrc
export ANDROID_SDK_ROOT=/yourAndroidStudioPath/Android
export PATH=${PATH}:$ANDROID_SDK_ROOT/tools:$ANDROID_SDK_ROOT/platform-tools
export JAVA_HOME=/usr/lib/jvm/java-8-oracle
export JRE_HOME=/usr/lib/jvm/java-8-oracle/jre

Try to run your ionic app again :) Njoy!

MySQL & PHP References

Search This Blog