Tutorial Komputer dan Buku Pembelajaran Gratis
achmatim
(152 comments, 371 posts)
Home page: http://achmatim.net
Yahoo Messenger: achmatim
Jabber/GTalk: achmatim
Posts by achmatim
Membuat Header, Footer dan Nomor Halaman pada PDF dengan PHP FPDF
42 weeks ago
Dokumen PDF (Portable Document Format) sudah menjadi format dokumen yang secara luas dikenal. Karena format PDF bersifat terbuka (open document format), PDF dapat dibuka di berbagai sistem operasi dan juga dapat dibuat dengan berbagai macam software, termasuk dapat dibuat dengan bahasa pemrograman seperti PHP. Untuk tutorial step by step membuat laporan pdf dengan php sudah pernah saya posting sebelumnya. Nah, dalam tutorial kali ini saya akan membahas mengenai penambahan Header, Footer serta Nomor Halaman pada halaman PDF yang dibuat. Semoga tutorial ini bermanfaat untuk kita semua, dan jangan lupa sebarkan tutorial ini agar lebih banyak lagi orang yang menikmati manfaatnya.
Langsung aja, untuk membuat Header dan Footer pada halaman PDF caranya sangat mudah. Kita cukup mendefinisikan fungsi Header() dan Footer() di dalam class kita. Fungsi tersebut tidak perlu dipanggil karena secara otomatis sudah dipanggil bersamaan dengan pembentukan object dari class.
Popularity: 2% [?]
Fungsi GROUP BY dan HAVING untuk Pengelompokkan Data di MySQL
9Database MySQL merupakan salah perangkat lunak untuk penyimpanan data yang sangat populer untuk saat ini. Salah satu alasan banyak orang memilih MySQL adalah keunggulan dan kelengkapan fitur-fitur di dalamnya. Salah satu fitur dari MySQL adalah dukungan terhadap berbagai fungsi agregat GROUP BY dan HAVING untuk pengelompokkan data. Pada tutorial ini dijelaskan mengenai fitur GROUP BY dan HAVING tersebut, disertai contohnya.
Sebelum mencoba fungsi GROUP BY dan HAVING, perlu diketahui bahwa keduanya sangat berkaitan dengan fungsi agregat. Fungsi agregat merupakan kelompok fungsi di MySQL yang memungkinkan untuk memiliki parameter berupa kelompok data. Sebagai contoh dari fungsi agregat adalah fungsi SUM() yang akan menjumlahkan seluruh nilai yang menjadi parameternya. Contoh lain adalah fungsi MAX() yang akan menghasilkan nilai terbesar dari keseluruhan nilai yang menjadi parameternya.
Popularity: 4% [?]
Fungsi Rekursif dan Penerapannya di PHP
9Fungsi merupakan bagian yang tidak terpisahkan dari konsep bahasa pemrograman. Dengan adanya fungsi, akan meningkatkan readibility (kemudahan untuk dibaca), modularity (pemecahan program menjadi modul-modul) dan reusability (dapat digunakan kembali) program kita. Lalu apa itu fungsi rekursif? Singkatnya, fungsi rekursif adalah suatu fungsi yang memanggil dirinya sendiri. Jadi di dalam suatu fungsi rekursif terdapat pemanggilan terhadap dirinya sendiri.
Penasaran? Dalam tutorial kali ini, saya akan menyajikan beberapa contoh sederhana penerapan fungsi rekursif di bahasa pemrograman PHP. Pada akhir tutorial, akan dicontohkan penggunaan fungsi rekursif dalam menampilkan menu bertingkat yang diambil dari database MySQL.
Popularity: 7% [?]
Membuat Menu Bertingkat dengan JQuery jQSimpleMenu
172 months ago
Sekitar dua tahun yang lalu, saya pernah membuat tutorial membuat menu bertingkat menggunakan Dreamweaver, waktu itu masih versi 8. Waktu itu teknologi JQuery belum begitu dikenal dan belum sekaya saat ini. Seperti kita ketahui, JQuery merupakan salah satu framework(library) Javascript yang menekankan bagaimana interaksi antara Javascript dan HTML dapat dilakukan dengan mudah. Nah, saat ini untuk membuat menu bertingkat atau sering disebut tree menu, hierarchical menu atau multi level dropdown menu, sangatlah mudah. Cukup dengan menuliskan satu atau dua baris perintah jquery, menu sudah jadi.
Penasaran? Ingin tau caranya? Ikuti terus tutorial ini.
Popularity: 9% [?]
Adminer: Database Client berbasis Web dalam Satu File PHP
14Bosan dengan PHPMyAdmin? Ingin sesuatu yang lebih sederhana namun powerfull? Ini dia salah satu Database Client berbasis Web yang saya suka. Tidak hanya untuk MySQL, tapi juga bisa dipake untuk Oracle, SQL Lite, PostgreSQL dan MS SQL. Tidak perlu space yang besar, karena Adminer terdiri dari satu file PHP saja dengan ukuran kurang dari setengah Mega.
Menarik bukan? Silahkan langsung dicoba saja, download di situs resmi Adminer atau coba demo onlinenya.
Popularity: 7% [?]
Membuat Auto Wrap Content pada Tabel dengan FPDF dan PHP
383 months ago
Semalem saya dapet pertanyaan dari salah satu pengunjung website ini terkait dengan tutorial membuat laporan PDF dengan FPDF yang pernah saya posting. Dia sudah mencobanya namun saat isi data pada suatu kolom melebihi lebar dari kolom tersebut, maka tulisannya akan kepotong alias ga keliatan. Saya juga sering mendapatkan pertanyaan serupa baik dari beberapa mahasiswa, pengunjung website achmatim.net, kawan-kawan di facebook maupun follower di twitter. Sehingga saya mencoba untuk membuat contoh program PHP sederhana mengenai membuat auto wrap content pada tabel ini.
Bagi Anda yang belum pernah menggunakan library FPDF sebaiknya mencoba tutorial dasarnya terlebih dahulu sebelum mencoba tutorial ini. Dan untuk menyederhanakan tutorial, data yang ditampilkan diambil dari sebuah array. Anda dapat memodifikasinya dengan mudah jika ingin dikoneksikan dengan sebuah database. Contoh Program PHP pada tutorial ini menggunakan library FPDF versi 1.7 yang dapat Anda download di situs resminya.
Popularity: 10% [?]
HTML5 for Web Designers
3 months ago
When the book first landed on my doorstep, I was a bit let down by its meagre length of around 85 pages. I have to be honest, however, and admit I had not done my research before its arrival. From the book’s inception, the publishers stated that they intended to produce something to fill the gap between a blog post and book, something that people would be able to pick up, read quickly, and start implementing straight away.
So I set aside my disappointment and started reading this beautifully crafted book.
After reading through it, my opinion has changed. I realise exactly what A Book Apart were aiming to create when they decided on a short format for the series. HTML5 for Designers is split up into six bite-size chapters:
Chapter One
The first chapter lays out the foundations of the book and explains how, as a community, we arrived at the latest iteration of our favorite markup language, HTML5. Keith discusses how HTML was born, the ill-fated transition from HTML to XML (which never happened), the suggestion of XHTML2, and why we write “HTML5″ instead of “HTML 5″.
You might be tempted to skip straight to the second chapter, but I firmly believe that you should read this. It’s vital material, and you’ll almost certainly learn something. (I sure did!)
Chapter Two
Chapter two discusses how to convert web pages from XHTML 1 toHTML5. It also touches on elements that changed in HTML5 and some elements that are absent from the specification.
Chapter Three
In chapter three, the book delves into the realms of rich media and what it means for designers and developers. Keith hints that this chapter could have a whole book dedicated to it (perhaps hinting at an upcoming A Book Apart title?). He does a good job describing the possibilities of <canvas> and showing a few examples of its capabilities. Although some readers may wish for more depth, this book is of course written for designers, so detail is kept to a minimum.
Keith goes on to explain the possibilities of the <audio> and <video>elements, something which many argue will change the way we work with the web. Keith gives great examples on how to introduce these elements into your client work with various fallback options for browsers that lag behind.
Chapter Four
In chapter one, it’s explained that HTML5 started life as Web Apps 1.0 and Web Forms 2.0, which were later merged. So as one might imagine, Web Forms were destined to become an integral part of theHTML5 specification.
Chapter four covers the new elements and attributes for use in forms, including placeholder, required, autocomplete, datalist, new input types, sliders/spinners, and dates and times.
Chapter Five
Chapter five covers semantics (although I feel that this should have been one of the first chapters in the book). Elements discussed include <mark>, <time>, <meter>, and <progress>, as well as the usual structural elements that get used in nearly every site.
Chapter Six
Finally, chapter six discusses the most important question aboutHTML5: Can we use it today? I trust, as you are on this website, that you will already know the answer to that question.
My opinion of HTML5 for Web Designers
After finishing this book, I discovered that it is in fact quite a gem for anyone starting on their HTML5 journey.
There are undoubtedly areas that could have been expanded further, but the limitations imposed by the authors meant merciless fat-trimming. This is the type of book that you would be happy to keep on your desk as a quick reference manual, a shortcut before diving into the full HTML5 specification.
I would definitely recommend buying this book if you haven’t already. It’s true that great things come in small packages!
Download Links
Related Ebook
HTML5 Designing Rich Internet Applications
3 months ago
Four of us doctors have read this book (figure 1) and in our opinion it contains an unacceptable number of errors which makes it misleading to the reader.
- The preface claims “a group called the Web Standards project began developing HTML5 in 2007″. It didn’t; it was the WHATWG, in 2004.
- In “spring 2010 .. Microsoft formerly [sic] joined the HTML5Working Group”. Chris Wilson, then lead of Internet Explorer, was co-chair in 2006.
- Page 11 mentions the <m> element. There isn’t one; it was renamed to the <mark> element (as it’s correctly called on page 22) before June 2008, at least 2 years before this book was published July 2010.
- Page 19 discusses the <dialog> element, which was removed from the spec in September 2009.
- Page 27 tells us “The W3C had already begun modernizing the FORM element, called Forms 2.0, before HTML5″. The WHATWG started with Webforms 2; the W3C had worked on XForms 1.0.
- There is a <navigation> element used extensively in the chapter “Building a web site using HTML5 blocking elements” — this should be the
<nav>element. - Page 72 tells us “The ANCHOR element has four pseudo classes: link, active, hover and visited”, omitting the
focuspseudo-class which is vital for accessibility, as it is applied when a user navigates to a link using the keyboard rather than hovering with a mouse. - Page 73 says “New to CSS3 is a new extension called pseudo elements”. Pseudo-elements were there from CSS 1.
The book also promotes several examples of bad coding practices:
<br/><br/>pairs to force new lines- classitis (
<footer class="footerStyle">) - form
<label>s are not accessibly associated with their<input>s - not using the full vendor-prefix stack (-moz-, -ms- , -o-, -webkit-, [no prefix]) resulting in code that is neither future-proof nor cross-browser
- bad semantics, for example
<p class=mainTitleStyle>rather than using an HTML heading
Download Links
Related Ebook
Selecting The Most Effective VPN Support
3 months ago
by achmatim
in Network Posts
Receiving VPN or possibly a electronic exclusive network is going to be a thing that will be really critical in fact, in order to anyone which uses the world wide web. This is not only just an item of technologies that may one minute be necessary when you wish in order to obtain from the Peer to peer internet site along with continue being nameless however to help keep oneself and your exclusive files secure also.
There are many folks that will consider VPN doesn’t work or which it costs too much to own on a monthly basis however not of this is true; VPN can certainly set you back nevertheless the price vary from the diverse suppliers around please remember you will find diverse suppliers around to select from. The simple truth is that many are actually paying out an excessive amount of for VPN that is why you should understand how to pick the best VPN support for you personally.
It will likely be essential that you should understand how to pick the best VPN support that will doesn’t charge an excessive amount of, the cost doesn’t genuinely make any difference, as long as you obtain the best from this. You might get any VPN support nevertheless it might not be the most effective also it could possibly be useless for you personally along with the reasons you require to use this; you will need to believe for a while prior to getting VPN.
When you’re picking VPN, then you will should ask yourself numerous questions to obtain the best VPN; think of precisely why sort of VPN servers you will require. You is certain to get obviously a secure along with encoded tunel from your laptop or computer and the placed you are becoming your current VPN, it should take your current IP address along with conceal it, that may mean, should you be surviving in some country such as The us however wish to look at issues from Great britain or possibly a particular program then you will wish to look at ITV iPlayer or BBC iPlayer which are available in the UK. You will likely need to get a United kingdom VPN you can definitely the situation had been changed so you were living in britain along with planned to look at Hulu you would need a People VPN vendor.
You simply must ask yourself whether or not the VPN enables torrents or Peer to peer downloading, you could also enquire about the amount of data transfer available. You must also realize regardless if you are by using this on a Home windows gadget or possibly a Mac or A linux systemunix gadget; looking for VPN specifically a great Android mobile phone or along with i phone or apple ipad tablet instead? If therefore you’ll need to look for best vpn that may function specifically that will, additionally, you will need to look at the cost and when the actual VPN provider will offer you the money-back guarantee.
Download Links
Random Ebook
Autoepc Home
3 months ago
by achmatim
in Network Posts
On our website AutoEPC.com.ua you can find tons of information, extremely useful for beginning motorists as well as for skilled professionals. There are electronic catalogues of spare parts for vehicles manufactured in all world, their base, information on repairs and diagnosing vehicles, service, car-care centers, etc. On AutoEPC.com.ua you can find electronic original spare parts parts catalogs, the information about car repairs, repair manuals, service manuals, diagnostics and servicing. This is the only source for full information regarding spares parts and repair manuals. Electronic spare parts cataloguesavailable not only for regular cars and light trucks, but also for other types of equipment such as heavy trucks, buses, motorcycles, boat motors, fork lifts, industrial engines, tractors, dredges, building and warehouse technical equipment, etc.
In the electronic spare parts catalogues you can search for detailed information on components installed in the vehicle. With the help of the catalogues you can find out an exact release date of your vehicle, its complete set, serial numbers for spares and their cost, find out about compatibility of spares between vehicle models, get precise drawings/blueprints of the spare, study the design of units of the car, sizes and weight of spares, and such data as bonnet tables, release dates, its complete set, color, etc. Serial numbers of spares, the prices on spares change regurarly by manufacturers. Therefore it is recommended to update the catalogues when new one becomes available (or not less than 2-3 times a year).
Catalogs with repair manuals and service manuals contain most up-to-date information on procedures of servicing and diagnostics, electric schemes and description of control units, instructions with illustrations. It will allow you to perform most difficult repair procedures. The catalogues are oriented not only for auto-dealers and the car-care centers that have highly skilled specialists and special equipment, but also for the motorists who deal with repairs themselves.
We offer the information not only on automobile vehicles, but also on heavy lorries, buses, motorcycles, bikes, ATV, jet boats, snow mobiles, boat motors, hydrocycles, Caterpillar Fork Lift Trucks, Backhoe Loaders, Crawler Excavators, Loaders, Dozers, Caterpillar SIS.
andre
terima kasih banyak mas, akhirnya nemu ebook mysql bahasa indonesia. Baru ane baca sekilas ..isinya mantap sangat bermutu
2 days ago
febrian
kak mau tanya...
gimana cara upload ke blogspot, karena di blogspot itu mintanya format xml tetapi di doTemplate itu formatnya bukan […]
3 days ago
Achmad Solichin
Untuk solusi kasus tersebut, tidak bisa menggunakan trigger, tapi bisa menggunakan EVENT. Coba cek di manual: […]
3 days ago
rakhmat
saya pakai ini tapi ga bisa juga..
CREATE TRIGGER 'autoupdate'
AFTER INSERT ON `beritacamp` FOR EACH ROW
BEGIN
[…]
3 days ago