<?php
/*cara menampilkan isi database mysqli*/
/*pertam kita lakukan koneksi seperti di bawah ini*/
<?php
$db_host = 'localhost';
$db_user = 'username';
$db_pass = 'password';
$db_name = 'nama_database';
$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
/*lakukan logika*/
if (!$conn) { die ('Gagal terhubung MySQL: ' . mysqli_connect_error()); }
/*kemudian kita ambil data yang ada didalam mysqli sperti ini*/
$sql = 'SELECT* FROM nama_tabel ';
$query = mysqli_query($conn, $sql);
/*lakukan logika*/
if (!$query) { die ('SQL Error: ' . mysqli_error($conn)); }
/*terahir kita tampilkan data yang sudah di ambil tadi sperti ini*/
while ($row = mysqli_fetch_array($query)){
$a=$row['nama_kolom'];
echo $a;
}
?>
[WEB] menampilkan isi database dengan php mysqli
<?php
$zip = new ApkArchive;
$file = $zip->open("tes.zip");
if ($file === TRUE) {
$zip->extractTo("hasil-unzip");
$zip->close(); // tutup
echo "Berhasil!";
}
else
{
echo "Gagal";
}
?>
[WEB] Extrack Zip
Buat folder terlebih dahulu didalam public_html sebagai penyimpanan file
Untuk menyimpan file jenis lain kita tinggal mengganti extensi file di script php dibawah
Index.html
<!DOCTYPE html>
<html>
<body>
<form action="proses.php" method="post" enctype="multipart/form-data">
Select image to upload:
<input type="file" name="UploadFile" id="UploadFile">
<input type="submit" value="Upload Gambar" name="submit">
</form>
</body>
</html>
proses.php
<?php
$var = "video/";
$folder =$var.basename($_FILES["UploadFile"]["name"]);
$FileType = pathinfo($folder,PATHINFO_EXTENSION);
if ($_FILES["UploadFile"]["size"] >9999999999999999){
echo "Maaf, ukuran file terlalu besar.";}
if($FileType != "mp4" &&
$FileType != "mkv" &&
$FileType != "3gp" &&
$FileType != "avi"){
echo "extensi file tidak di dukung";}else{ move_uploaded_file($_FILES["UploadFile"]["tmp_name"], $folder);}?>
[WEB] upload file to server
Nb:
untuk bisa berpindah anda harus mengetahui nama package aplikasi target dan activitynya
Seperti contoh di bawah
com.melki adalah package
Dan MainActivity adalah Activitynya
Tapi disini activitynya ditulis package + activity =com.melki.MainActivity
import android.app.*;
import android.os.*;
import android.widget.*;
import android.view.*;
import android.content.*;
public class MainActivity extends Activity
{
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
Button btn=(Button)findViewById(R.id.btn);
btn.setOnClickListener(new Button.OnClickListener(){
@Override
public void onClick(View v){
Intent ii=new Intent();
ii.setComponent(new ComponentName("com.melki","com.melki.MainActivity"));
try{
startActivity(ii);
}catch(Exception e)
{
Toast.makeText(MainActivity.this,"aplikasi tidak terinstal",Toast.LENGTH_SHORT).show();}};});}}
[DROID] Berpindah Aplikasi (implicit)
import android.app.*;
import android.os.*;
import android.widget.*;
import android.view.*;
import android.content.*;
import android.net.*;
public class MainActivity extends Activity implements View.OnClickListener {
EditText edit;
Button button;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
button= (Button) findViewById(R.id.btn);
button.setOnClickListener(this);
}
@Override
public void onClick(View v) {
Toast.makeText(getApplicationContext(),"whatsappsharing",Toast.LENGTH_SHORT).show();
Intent whatsappintent=new Intent();
whatsappintent.setAction(Intent.ACTION_SEND);
whatsappintent.setType("text/plain");
whatsappintent.putExtra(Intent.EXTRA_TEXT, "testing programing");
whatsappintent.setPackage("com.whatsapp");
startActivity(whatsappintent);
}}
[DROID] Mengirim text Ke Whatsapp (implicit Intent)
Nn: jika iklan tidak tampil maka ganti nama package menggunakan apk editor
Main.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:gravity="center">
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:id="@+id/t"
android:text="wait"/>
</LinearLayout>
MainActivity.java
package com.mycompany.myapp;
import android.app.*;
import android.os.*;
import com.google.android.gms.ads.MobileAds;
import com.google.android.gms.ads.AdRequest;
import com.google.android.gms.ads.InterstitialAd;
import com.google.android.gms.ads.AdListener;
import android.util.*;
import android.widget.*;
public class MainActivity extends Activity
{
private InterstitialAd mInterstitialAd;
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
mInterstitialAd = new InterstitialAd(this);
mInterstitialAd.setAdUnitId("ca-app-pub-8053190329240173/4842633610");
mInterstitialAd.loadAd(new AdRequest.Builder().build());
mInterstitialAd.setAdListener(new AdListener() {
@Override
public void onAdLoaded() {}
@Override
public void onAdFailedToLoad(int errorCode) {}
@Override
public void onAdOpened() {}
@Override
public void onAdLeftApplication() {}
@Override
public void onAdClosed() {
mInterstitialAd.loadAd(new AdRequest.Builder().build());
}});if (mInterstitialAd.isLoaded()) {
mInterstitialAd.show();}else{}}
@Override
public void onStart() {
super.onStart();
if(mInterstitialAd.isLoaded()) {
mInterstitialAd.show();}else{}
AndroidManifest.xml
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.mycompany.myapp"
android:versionCode="2"
android:versionName="1.2">
<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<application
android:allowBackup="true"
android:icon="@drawable/ic_launcher"
android:label="@string/app_name"
android:theme="@style/AppTheme" >
<meta-data android:name="com.google.android.gms.version"
android:value="@integer/google_play_services_version" />
<activity
android:name=".MainActivity"
android:label="@string/app_name" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
<activity android:name="com.google.android.gms.ads.AdActivity"
android:configChanges="keyboard|keyboardHidden|orientation|screenLayout|uiMode|screenSize|smallestScreenSize"
android:theme="@android:style/Theme.Translucent" />
</application>
</manifest>
Build.gradle
apply plugin: 'com.android.application'
android {
compileSdkVersion 21
buildToolsVersion "21.1.0"
defaultConfig {
applicationId "com.mycompany.myapp"
minSdkVersion 14
targetSdkVersion 21
versionCode 1
versionName "1.0"
}
buildTypes {
release {
minifyEnabled false
proguardFiles getDefaultProguardFile('proguard-android.txt'), 'proguard-rules.pro'
}
}
}
dependencies {
compile 'com.google.android.gms:play-services-ads:+'
compile 'com.google.android.gms:play-services-ads:+'
compile fileTree(dir: 'libs', include: ['*.jar'])
}
Dikutip dari : http://www.sketchwarehelp.com/2017/09/how-to-integrate-admob-interstitial-ads.html?m=1
[DROID] Admob
TextView text=(TextView)findViewById(R.id.txt);
(Buton listener)
String anu="";
for(int a=1; a<10; a++){anu=anu+"text \n";}
u.setText(anu);