How to add foreign key PHPMYADMIN or MYSQL

Wahyu Raja Reply 3:25 PM
he innodb storage engine supports foreign keys in Mysql.


To create foreign keys in phpmyadmin :
1. Convert both tables into innodb, if they are not already.
2. View the structure of the table which will have a foreign key. Make the referencing field an INDEX.
3. Now come back to structure view and click Relation view.
Phpmyadmin Relation View Link
Phpmyadmin Relation View Link
In the Relation view page the field (which was made an INDEX) can be made a foreign key referencing to some other field in another table.
Phpmyadmin Foreign Key
Phpmyadmin Foreign Key
That should do it.

source : http://www.binarytides.com/create-foreign-key-phpmyadmin/

How to import large CSV file to your Mysql or PHPMYADMIN

Wahyu Raja Reply 3:24 PM
First you must create a file. with everything. i assume my filename is bigdump.php. and write this code:

<?php
mysql_connect('servername','username','password');

mysql_select_db('databasename');

$sql = "LOAD DATA LOCAL

INFILE 'data.csv'

INTO TABLE data

FIELDS

       TERMINATED BY ','

       OPTIONALLY ENCLOSED BY '\"'";

$insert = mysql_query($sql);

if($insert)

  echo 'success';

else

  die('error : ' . mysql_error());

?>

and now put in htdocs. and dont forget to move your csv file to htdocs too. and run it. TARAAA.. you got you want :)

Cara Upgrade Perl

Wahyu Raja Reply 7:47 AM
Untuk menjaga keterkinian versi interpreter Perl dan modul-modulnya saya menjalankan console CPAN dengan mengetikkan perintah cpan pada Command prompt. Setelah masuk ke console CPAN, saya ketikkan perintah upgrade. Secara otomatis CPAN akan menguduh versi baru dari modul-modul yang sudah terpasang di komputer saya.

Membuat Tanggal Dengan PHP

Wahyu Raja Reply 5:39 AM

<?PHP
date_default_timezone_set("Asia/Jakarta");

//Array Hari
$array_hari = array(1=>"Senin","Selasa","Rab
u","Kamis","Jumat",
"Sabtu","Minggu");
$hari = $array_hari[date("N")];
//Format Tanggal
$tanggal = date ("j");

//Array Bulan
$array_bulan = array(1=>"Januari","Februari","Maret",
"April", "Mei",
"Juni","Juli","Agustus","September","Oktober",
"November","Desember");
$bulan = $array_bulan[date("n")];

//Format Tahun
$tahun = date("Y");
//Menampilkan hari dan tanggal
echo $hari . "," . $tanggal."-" . $bulan."-" . $tahun;
?>

Cara membuat Kuisioner Online dengan Google Docs

Wahyu Raja 1 7:02 AM
Ada satu hal yang membuat saya senang ketika menulis sebuah postingan, yaitu ketika artikel yang saya tulis terkait atau terinspirasi dari proses perkuliahan atau pembelajaran. seperti postingan kali ini yang notabene adalah tugas mata kuliah Interaksi Manusia Komputer, ceritanya mahasiswa saya wajibkan untuk menyebarkan kuisioner terkait respon pengguna terhadap sebuah website, diantara mahasiswa ada yang mengeluhkan terkadang sulit untuk menemui seluruh responden karena keterbatasan waktu dan kesempatan. terlintas lah ide untuk menyebarkan kuisioner secara online untuk melengkapi berkas pengumpulan data analisis.
Pengumpulan Data dalam sebuah riset / penelitian dapat dilakukan dengan beberapa metode antara lain 
1. Perekaman Data, melalui Catatan, audio, video, foto
2. Interview, dengan pihak pihak terkait
3. Kuesioner
4. Observasi, maupun kombinasi dari beberapa metode
Masing masing metode diatas mempunyai keunggulan dan kekurangan , liat slide yang saya posting disini 1
metode kuisioner sendiri cocok dipakai untuk pengumpulan data pada populasi dalam jumlah besar, mudah dalam proses analisa terlebih jika menggunakan pertanyaan tertutup (dapat diproses secara komputerisasi). kuisioner dalam versi online lebih flexibel (karna responden dapat berpartisipasi dengan mengakses melalui jaringan internet) dan memudahkan proses pengumpulan dan pengolahan data
berkunjunglah ke halaman http://docs.google.com,
maka page otomatis akan redirect ke akun gmail, as you know fasilitas adalah milik om google
sign in,
login
selanjutnya pilih tombol create
create
pilih form
from
beri nama dan pilih tema backround
beri nama dan pilih theme
mulai dengan mengisi judul quisioner dan deskiripsi
judul dan deskripsi
mulai dengan pertanyaan pertama, pilih jenis jawaban.
jenis jawaban
Ada banyak jenis, yaitu :
- teks (untuk isian)
- paragraf teks (untuk jawaban panjang, contoh alamat)
- multiple choice, checkbox dan choose form a list untuk jawaban yang bersifat pilihan (ex : jenis kelamin, agama dll)
- scale untuk jawaban dengan rating tertentu (ex 1-10, 11 – 20 dsb)
- grid untuk pertanyaan yang disusun dalam bentuk tabel
- Date untuk jawaban tanggal ( ex tgl lahir)
- Time untuk jawaban waktu
setelah selesai, save
send form dan copy
kirimkan link yang di tampilkan ke responden dan mintalah mereka berpartisipasi.
untuk melihat respon dari quisioner, sigin kembali di google docs, lalu pilih create response
create response
view respon
view response
terlihat jawaban
jawaban response
dan download untuk mengolah
download as ms excell
dibawah ini saya sertakan tutorial video pembuatan kuisioner online google yang diunggah oleh flytenewmedia [2]

dan inilah contoh quisioner penelitian Mahasiswa Bimbingan TA yang saya buatkan versi
Kuisioner gooegle docs nya

Source : http://dianramadhani.wordpress.com/2013/06/11/cara-membuat-quisioner-online-dengan-google-docs/

Mengembalikan System Icon Battery, Volume dan Network Yang Hilang di Windows 7

Wahyu Raja Reply 7:15 AM
Adapun langkah-langkah seperti ini :
Klik "Start", lalu pilih "run" dan ketik "regedit" pada kotak Start Search box, lalu tekan ENTER. 
Jalankan regedit lalu lokasi kan pada subkey registry HKEY_CURRENT_USER\Software\Classes\Local Settings\Software\Microsoft\Windows\CurrentVersion\TrayNotify
Lalu delete registry entry IconStreams dan PastIconsStream 
Keluar dari registry editor.
Restart Explorer.exe 
Untuk me restart explorer.exe caranya :
Tekan CTRL+SHIFT+ESC.
Pada tab Processes di Task Manager, klik explorer.exe lalu tekan tombol End 2 kali.
Kemudian pada menu File, klik New Tasks (Run), ketik explorer - OK.
Keluar dari Task Manager

TECHNICAL LIBRARY

Wahyu Raja Reply 8:53 PM

Submissions from 2013

Recommender System Using Collaborative Filtering Algorithm, Ala Alluhaidan
Mapping of UML Diagrams to Extended Petri Nets for Formal Verification, Byron DeVries
ParabolaX: Learner Engagement with Serious Games, Kevin Formsma
Cost Accrued as a Measure of Hospital Quality Improvement- Can Lean Health Make A Difference, AmarChandra Ganna
SMiT: Local System Administration Across Disparate Environments Utilizing the Cloud, Kevin Guyot
Zero Configuration Networking and Communication using iOS and Android, Gray Gwizdz
Skini: A device ecosystem for integrating household appliance events into smartphone and tablet apps, Saro Iskanian
Book Discussion Web Application Based on Django Framework with UI/IX Design for Senior Citizens and Inexperienced Users, Gayane Kabalyan
Analysis of Virulence Factors of Helicobacter pylori Infection and Human Migration, Yuka Kutsumi
Impact of Gamification and Shared Situated Displays on Smartphone Application Engagement, Juan Mejia
Calerdo: A Web Application for Event Discovery by Tags, Daniel Ribbens
Blackboard on Android: a Free and GVSU Centric Blackboard Mobile App, Jacob V. Romero
Threadz: Image-Matching Using Colors and Contrasts, Chris Rysko
Search Engine Optimization: A Survey of Current Best Practices, Niko Solihin
Aspects of Mobile Health in Africa, Cheick Traore
iBusinessReports: An Android App for Managing Personal Finances, Senthilraj Ulagasundaram
Clinical Decision Support Systems – An Economic Evaluation, Nicholas VanderLaan

Submissions from 2008

Issues In Open Source Software (OSS), Divya Abbagani, Harsha Lella, Jeffrey Martin, Sherzod Odinaev, and Silpa Pathapati
Using Distributed Computing to Find Large Prime Numbers, Alec Dhuse Alec
High-Performance Distributed Computing, Vinay Alofs
Process Reporting Information Monitoring System (PRIMS.NET), David J. Bass
Revisiting Marcus’s 1993 Paper and Reflecting on Evolution, Varsha Chaphalkar
Enterprise Resource Planning and Business Process, Parvez Gaggutur, Varun Reddivari, and Naga Puligadda
Developing an Interactive P2P-Water Modeling System, Chunhui Han
Utilizing AJAX Calls to Separate the Presentation & Application Layers in Web Applications, Kevin Holleran
DocumentCenter: A Document Management System, Yuri Kazarov
Does Test Driven Development Yield a Good Design?, Chris King
Inspired Design: Using Interdisciplinarity And Biomimicry For Software Innovation, Steven A. Korecki
Task Management Application Prototype for the iPhone OS, Harold Kuhn
Advancement of ERP in Small and Medium Enterprises (SMEs), Ramya Mannar, Vinay Ponnekanti, and Sai S. Dwarknath
Considering the Critical Success Factors for ERP Implementation, Archana Molugu, Craig Witter, and Ravindran Vellore
Mapping between State Charts and Event Driven Petri Nets, Larry Osterbaan
AJAX Tutorial, Pramod Rane
A Study on the Impact of Information Technology Use on Nonprofit Organizations, Ashima Saigal
Analysis of Various Issues affecting ERP Implementation, Arul Vannalaa, Shwetha Kundanam, and Sindhu Malla

Submissions from 2007

Mobile Transaction Management - (A Survey of Transaction Processing on Mobile Hosts), Aishwarya Apte, Jennifer Kasul, and Manasa Maraboyina
Outsourcing, Holly B. Barsamian, Mark Brouwer, Haritha Chandupattla, Venkata R. Dasam, Aravind G. Mandadi, Namrata Mangu, Shakthi K. Nandivada, Robert E. Pratt, Eric J. Thorsen, Vishnu Yada, and David A. Young
Constraining Protein Structure Simulation Using Robotic Techniques with Aggregate Data, Eric Bracey
Semantic Web, Rajani Choudhary, Mansoor Farook, and Harshita Malhotra
A Bibliographic Retrieval System Using Lucene and Digester, Suvarna V. Damodaran
An Exploration of Business Rules Engines, Patrick Dunlap, Quentin Reader, and Jeff Ryan
Compiler Design Using Template “Meta-Programming”, Amer Gerzic
Implementation of ODscan: An Algorithm for Mining Frequent Itemsets, Brenda Marie Harvey
Virtualization in an Enterprise Environment, Mary Jo Hills, Adeel Khan, and Ryan Smallegan
A Performance Study of Object Relational Databases, Tariq Lahyani
High-Performance Computation of Voronoi Diagrams using a Graphics Processing Unit, Igor Majdandzic
Radio Frequency Identification (RFID) Middleware for Existing Data Collection Systems, John Manilla
Jipange Kifedha - A Distributed Dot Net Expense Manager Application Demonstrating the MVC Pattern, Leecox Omollo
A Visualization of 2-3-4 Trees Using Jhave, Sudhakar Pandurangan
An Implementation Using Oracle Spatial, Scott Riblet
A Study on the Impact of Information Technology Use on Nonprofit, Ashima Saigal
Explore Mashup, Sudhir Waghmare

Submissions from 2006

Testing Programs That Contain OpenMP Directives, Bob Barnhart
Comparison of Hierarchical Agglomerative Clustering Utilizing an Apriori Itemset Lattice with Term Based Vectors versus Bisec, Casey R. Bartman
TIC: Term Intersection Clustering of Text Documents, Casey R. Bartman
Implementation Plan for End-to-End Performance Monitoring of a Distributed Application, Steve Boeve
sing Experimental Protein Data to Construct a Configuration Space for Protein Folding Simulation Using Motion Planning Tech., Eric Bracey
Serf Engine – Reusable and Reusable Framework, Tina Ehlizevak
XCOM: The OpenGL Dancing Robot, Carl Furrow
Cross-Platform Podcast Feed Authoring Application, Brian P. Geary
An Exemplary Procedural Implementation and Testing of a Calendar Problem, Ryan Harrelson
Generating a Jump Distance Based Synthetic Disk Access Pattern, Dr. Zachary Kurmas
A Database-Based Engine to Execute Time-Enabled Event Driven Petri Nets, Andrew G. Lewis
Web-based Dynamic Database Creation, Andrew G. McGuckin

Submissions from 2002

Justification and Considerations in Profiling Automated Testing in Software Maintenance Organizations for E Type Systems, Patrick Bailey
A Flexible Communication Framework: Implementing a Camera Controller for Skydiving, Tim Bochenek
POP3 Troubleshooter, Chris Burnham
Has the Object-Oriented Paradigm Kept Its Promise?, David Fernandez, Al Fischer, Michael Greco, Bradly Hussey, Steven Kuchta, Hong Li, Steven Overkamp, Douglas Rodenberger, and Richard VanderWal
Wireless Handheld Computers: The Next Generation in Industrial Computing, Kevin Hykin
Effective Diagramming Techniques, Ralph Palmer
Load Balancing policies and their Effectiveness, Murali Rajagopalan
Product Configuration System: A Product Configuration Solution to Mass Customization for Large-sized Engineering Companies, Angela Richards

Source : http://scholarworks.gvsu.edu/cistechlib/?utm_source=scholarworks.gvsu.edu%2Fcistechlib%2F155&utm_medium=PDF&utm_campaign=PDFCoverPages

Search

Ikuti Channel Youtube Aku Yaa.. Jangan Lupa di subscribe. Terima kasih.

Google+ Followers

Popular Posts

Translate