Shifting from normal PHP scripts to PDO Scripts.

-
PHP Scripts are used a lot but on changing the trend is the new PDO Scripts. Moreover shifting from normal servers to AWS server i.e Amazon Web Services then we have to use PDO scripts.
There are a lot of new things to do in PDO Scripts but some main points are to be followed while converting them.

 Retrival -
mysql_query is changed with $DBH->query()
 where $DBH is the reference variable of the Object in PDO

setFetchMode(FETCH_MODE::ASSOC);
This mode is used for the retrieval of associative array

Insertion and Updation- 
For insertion and updation prepare statements are used. Statements are prepared using the command as shown. There is an array which is used for the creation of prepared statements.
$array=array("Values");
$DBH->prepare("Prepare Statement");

Comments

Post a Comment

Popular posts from this blog

Styling Bottom Navigation

-
Image
Styling Bottom Navigation Off the bat, the library provides considerable styling options. But after recent updates, there has been a lot more. Some of these additions include notification badges and coordinating behaviors. It also includes  on-scroll Quick Return pattern . Its all that one could ever want with the Bottom Navigation. This library is much more feature-rich than  what Android Design Support Library offers . So if you want more customization options and more control, you know what to use. Before we get to that, here’s a heads-up. We’ll be using and referencing a lot of colors. Normally, we reference colors in Android like this: ContextCompat.getColor(context, R.id.yourcolor); Now I’m no fan of writing such a lengthy line for fetching a simple color resource. So I’ll write a simple method that shortens what I have to type. private int fetchColor( @ColorRes int color) { return ContextCompat.getColor(this, color); } Great! From now on I d...
Read more

Lottie Animation in Android

-
Gradle is the only supported build configuration, so just add the dependency to your project  build.gradle  file: dependencies { ... compile 'com.airbnb.android:lottie:2.2.5' ... } Lottie supports ICS (API 14) and above. The simplest way to use it is with LottieAnimationView: <com.airbnb.lottie.LottieAnimationView android:id="@+id/animation_view" android:layout_width="wrap_content" android:layout_height="wrap_content" app:lottie_fileName="hello-world.json" app:lottie_loop="true" app:lottie_autoPlay="true" /> Or you can load it programmatically in multiple ways. From a json asset in app/src/main/assets: LottieAnimationView animationView = ( LottieAnimationView ) findViewById ( R . id . animation_view ) ; animationView . setAnimation ( "hello-world.json" ) ; animationView . loop ( true ) ; animationView . playAnimation ( ) ; ...
Read more

Minimum Required SDK – Target SDK – Compile With

-
Image
Target SDK and Compile With. It is often confusing for Android developers on What to select for the Minimum Required SDK, Target SDK and Compile With options. To help and clear the air, I have decided to write a post on it. Minimum Required SDK It is the lowest version of Android version that your app going to support and it is usually indicated by the API level. To support as many devices as possible, you should set this to the lowest version available that allows your app to provide its core feature set. If any feature of your app is possible only on newer versions of Android and it’s not critical to the app’s core feature set, you can enable the feature only when running on the versions that support it. The Google play will prevent the user from installing the application if the system’s API Level is lower than the value specified for Minimum Required SDK. Here is the current statistics of Android OS versions distribution: Source:  Platform Versions Decide wh...
Read more