Tutorial Searching / Pencarian Data dengan PHP dan Mysql

Studi Kasus : Membuat script untuk pencarian data dalam database
Kebutuhan : Webserver Packages, already installed.

Searching, merupakan fasilitas yang hampir selalu ada dalam setiap aplikasi, baik aplikasi berbasis web ataupun desktop. Setiap halaman web/ blog juga akan ditemukan fasilitas ini. Tutorial berikut akan memberikan konsep dasar dari searching, dengan melakukan pencarian pada data terstruktu (database).

Ok, langsung praktik saja.

Step 1 : Persiapkan Database

  1. Buat database dengan nama db_tutorial
  2. Siapkan tabel dengan nama tb_student, dengan struktur tabel seperti gambar dibawah ini.
  3. Insert-kan beberapa sample data, misal seperti gambar dibawah,
  4. Done with the database!

Step 2 : Persiapkan Folder Kerja

  1. Buat folder dengan nama searching dalam document root anda
  2. Simpan semua file dalam praktikum ini dalam folder tersebut.

Step 3 : Membuat script koneksi ke DB

  1. Ketikkan script berikut,
    [sourcecode language=”php”]
    $host = "localhost";
    $user = "root";
    $pass = "";
    $dbName = "db_tutorial";
    mysql_connect($host, $user, $pass);
    or die ("Connect Failed !! : ".mysql_error());
  2. simpan dengan nama connect.php
  3. Penjelasan : Script ini akan digunakan untuk menghubungan aplikasi kita dengan database db_tutorial. Sesuaikan username dan password dengan setting-an mysql anda.

Step 4 : Membuat form pencarian

  1. Ketikkan script berikut,
    [sourcecode language=”php”]
    <title> Halaman Pencarian </title>
    <form name="formcari" method="post" action="search_exe.php">
    <table width="330" border="0" align="center" cellpadding="0">
    <tr bgcolor="orange">
    <td height="25" colspan="3">
    <strong> Student Searching ! </strong>
    <tr> <td> Name </td>
    <td> <input type="text" name="name"> </td>
    <td> <input type="SUBMIT" name="SUBMIT" id="SUBMIT" value="search" > </td>
  2. simpan dengan nama formsearching.php
  3. Penjelasan : script diatas adalah HTML script biasa yang akan menampilkan form. Perhatian bagian action="search_exe.php", bagian ini dimaksudkan bahwa form akan diproses oleh script search_exe.php

Step 5 : Membuat script pemrosesan dan menampilkan hasil searching

  1. Ketikkan script berikut,
    [sourcecode language=”php”]
    include "connect.php";
    $name= $_POST[‘name’]; //get the nama value from form
    $q = "SELECT * from tb_student where name like ‘%$name%’ "; //query to get the search result
    $result = mysql_query($q); //execute the query $q
    echo "<center>";
    echo "<h2> Hasil Searching </h2>";
    echo "<table border=’1′ cellpadding=’5′ cellspacing=’8′>";
    echo "
    <tr bgcolor=’orange’>
    <td>Nama Mahasiswa</td>
    while ($data = mysql_fetch_array($result)) { //fetch the result from query into an array
    echo "
    echo "</table>";
  2. simpan dengan nama search_exe.php
  3. Penjelasan dapat dilihat di script comment

Step 6 : Testing Code

  1. Pergi ke http://localhost/searching/formsearching.php. Anda akan melihat form seperti dibawah,
  2. Masukkan nama pada field nama (misal nama yang telah diinsert ke DB, yaitu june)
  3. Klik tombol search dan anda akan melihat hasilnya

Selamat berkreasi dengan PHP 😀 Happy Coding..

Oleh littleflow3r

obviously, a girl. with sweet smile, off course. turning her 21 years trapped on Informatics departement and just started to having some crush with it lately. she uses wordpress. she loves php. she loves to satisfied her shopping hobbies just via looking around in online shop. oh yeah, she got an A for her english subject^^

204 replies on “Tutorial Searching / Pencarian Data dengan PHP dan Mysql”

Apkunder website offers you many different applications and games for free. You can quickly start downloading hundreds of games and applications for free using the apkunder.com website. Now visit apkunder.com website and get all apk files for free.

Userbola Agent Sportsbook Trusted
The particular football gambling game is very popular in Indonesia.
Besides being able to play sports betting, you can also play Online casino, and slots.

Userbola as an official and trusted Indonesian gambling website and bookmaker provides fast and free list services.

We provide the best service so that you can be able to play gambling easily
without having to get applications, for sbobet the ball can be accessed via sbobet mobile or wap, while sbobet casino is equipped with HTML5 features.

And we also provide customer support services, if you have trouble logging in or don’t have the latest sbobet link or alternative,
you can contact us via live chat, WhatsApp, We Chat,
and Line.

Game Userbola Online Gambling
The userbola site also offers ibcbet / maxbet ball gambling
games, joker slots gaming gambling, live casino, s128 and sv338 cockfighting, fielding balls (tangkasnet, tangkas88, tangkas1).

For those of you who like various online gambling video games, the userbola site is he best option for you for you
Indonesian gambling online players. The maxbet program can play ball betting, live casino allbet,
keno, and amount games. Also there are slots and seafood taking pictures games that are extremely famous from joker gaming.

If you like bets fighting, you can gamble and watch live streaming through the SV128 or SV338 providers.

Userbola Internet gambling Internet site

Userbola is an online betting site that has an official permit from
PAGCOR, so you don’t have to think twice to produce a finance transaction and use our site, and your
data will be safe. Userbola as a trusted wagering
site, we pay your succeed no matter how fast you play wagering in only 3 minutes for the process of withdrawing cash, and for
the process of depositing money for around one minute. Userbola provides purchase services from 9 banks namely Financial institution BCA, BNI, BRI, Mandiri, CIMB Niaga, Danamon, Panin, OCBC NISP.
You can also get alternative transaction services such as OVO,
Credit. Register now and get the satisfaction and convenience of playing gambling on the
Userbola site.
You must first register to become a member of a soccer gambling
agent. After that you will be given a consumer ID to log in to enter the web gambling game.

Make a deposit of funds immediately to the bank account quantity of the
Trusted Sports Agent if you need to play immediately.
The steps to produce a deposit are as comes after:

Submit Deposit Form
Ask for via our SMS MIDDLE at + 62-821-6182-5555
Request via Whatsapp + 62-821-6182-5555
Request via Live Conversation Userbola straight
Please use the steps above to avoid irresponsible persons on behalf of Userbola.
Be careful to avoid things we don’t want together.
Congratulations on joining the Indonesian Trusted Football Wagering Agent community.

Userbola is for those of you who are serious about actively playing with us.
Have a good bet.

List of Indonesia’s Latest Online Slots Gambling SiteUsernesia is a place to list Indonesian on-line slot gambling balances using the latest video games.

The Usernesia internet site being an Indonesian slot machine gambling site will
certainly give you the best experience in playing online slots.
Various advantages and services have become the icon of
theUsernesia Site. All the slot machine game gambling display
functions that we provide are the many sophisticated.

With simply once registering because a member, you can enjoy almost all types
of slot games provided simply by this site. Each game is
risk-free since it has received a special permit from the
local gambling authority and has met international
standards, equipped with the latest technology that may spoil you with outstanding graphic pictures and blaring sound.

How to sign up for online slot IDs on the Usernesia website
For anyone who want to right away join the finest online slot gambling gYou then may be immediately taken up the registration webpage where you will certainly find a registration contact form which you
should fill in together with your personal
information completely and appropriately.ame on the site ofUsernesia, the method is
incredibly easy. You simply must visit the particular site
at www. SiteUsernesia. com plus enter the registration page by
pressing the button positioned at the top right of the key page.

24-hour online slot site and online online casino – JudiUsernesia
JudiUsernesia is a site for playing online slot gambling and online casino that has 24-hour service.
All online gambling games on the JudiUsernesia site can certainly be utilized anytime and anyplace.
The JudiUsernesia site is also the best online gambling agent in the country because it
is dedicated to serving Indonesian online gambling members.
We, as the best online slot and casino game providers, will also continue to
provide improvements on the latest betting games
every week.
Online Slot machine Gambling Agent with a Deposit of 25 Thousand
Regarding lovers of online slot gambling video games throughout Indonesia, you
could have faced a similar problem where you want
to play the slot betting you want but are required to keep back because
you don’t have an satisfactory budget to play it.
If that is the problem that has been bothering you all
this time, then JudiUsernesia brings very good news to all of you.Now you no longer need to think about big money to be able to
play online gambling, with only twenty-five thousand rupiahs, you can immediately play
the game you want. The video games available here are also not human judgements games because they come from well-known providers such as Habanero Systems, Practical Play, Microgaming, and many more.

Choosing the best and most trusted place to piece of legislation online gambling has become the main requirement if
you want to be well-to-do in this business. It doesn’t issue what
game you play, be it soccer gambling, lottery gambling, casino gambling,
online slots or even cockfighting. If you can’t pick a trustworthy gambling site, next you will end
going on in failure.

Therefore, it is entirely important for those of you who are further to the online
gambling industry to know what criteria a site must meet suitably that
it can be said to be the best and most trusted online gambling site.

Are you a fan of online slot gambling games? This game has been on the
subject of for hundreds of years but is still one of the favorite games in Usernesia even in luxury gambling places taking into consideration Las Vegas or Macau, slot machines are always swiftly lined taking place waiting for
fans to pull levers and win jackpots that reach billions
of rupiah. .

But, did you know if this game was initially considered a flop game?
Yes, at the arrival of this game created by its
creator named Charles August Fey in 1894 in the associated
States, this robot was expected as an automatic poker game robot that could be
moved using coins.

For anybody who have merely joined the planet of online gambling, it is
very important know of which to play internet gambling
in Indonesia you need to opt for the best internet gambling site.

The Agenusernesia site acts since a portal that connects you as a player with the best games provided by Indonesia’s best online gambling site.

A single of the on the internet gambling agents that provides access in order to the very best online betting games in Indonesia is Usernesia.
Via its website from http://www.agenusernesia.com, you could find different types of well-liked
gambling online games such as soccer wagering, casino, online slots and so on and play these people
with just one single enrollment.

Since it premoere appearance, the Usernesia gambling online agent
site has been able to supply the best support for its clients with international
standard games and specialist service. Apart through that, there are several additional features that may provide you many
advantages. Consequently , register oneself now.

The Most Gacor Online Gambling Site
For professional online gambling players, of course , they already realize that determing the best and
most trusted internet gambling site is a single of the
total requirements to become successful in the online betting
industry. Consequently , picking an online gambling site should
not necessarily be arbitrary. There are many items to consider and it can be very time intensive to find
typically the most appropriate internet site.

The most well-liked online gambling internet site and
provides many advantages is Usernesia. Through this website a person will be
in a position to enjoy a number of00 the best wagering games created by
simply well-known providers. Here are some on-line gambling
games that you can pick and play in Usernesia.

Probably the most Trusted Soccer Gambling Real estate agent in Indonesia Serving Listings of Gambling and Online
casino Gambling
Userbola is the particular Most Trusted and Official SBOBET Agent in Indonesia.
We serve bets that provide soccer gambling online games, online
gambling games, on line casino gambling agents, poker and online lottery.

We will wholeheartedly always be prepared to help anything you want and help you
when there are difficulties in generating SBOBET Online
Betting Balances, MAXBET Agents or previously referred to as IBCBET, Serba4d or even KLIK4D lottery.

New twenty percent Member Bonus with the particular Best and a lot Dependable Sports Gambling Broker
Userbola is the Best SGD777 Agency as well as the Greatest Football
Agency in Dalam negri, always supplying 24-hour online service without stopping at the same time of
registering, lodging, withdrawing and responding
to be able to your every complaint.

Regarding more information, please go directly to livechat plus chat directly
with the friendly CS

Register for Sbobet right this moment!

Complete Selection for Reliable Sports Betting and
Casino Agents
With regard to you fans of gambling soccer matches both overseas and
domestic, reliable football gambling provides various complements from around the
globe. Not really simply that, basketball,
rugby in addition to eSports tournaments may
also be right here.

Especially for connoisseurs regarding Casino Providers,
we have got one of the most complete range of online games
starting from Baccarat, Poker, Keno, Slot machine game and numerous more.

Userbola is 1 of the trusted football gambling sites that acts as a realtor
of the particular planet’s major soccer bookies such as SBOBET,
Ibcbet plus Mahabet Sport. You may definitely get a pleasurable
experience while betting due to the interesting features provided by this web site.
Userbola has a specialist services when you make down payment
transaction until withdrawing money.
Before you enter the football gambling game on Userbola you must register first and become a consumer.
The method is very simple, all you have to do is click on the list and get into the registration form
webpage and you will go directly to our primary website.

Ruangkongsi is a discussion board for providing details on a collection of business profiles in Philippines from the hottest to the the majority of complete.

Built upon the basis of rendering it easier regarding information seekers and personnel who want to find information on one of the
particular companies that these people are ogling.
Ruangkongsi combines company details from company explanation, company address, company size to the particular
income provided by the company. Ruangkongsi Unlike other
business profile information supplier sites, all this particular company profile information is shared simply by those
who know typically the company best

Online Slots Demo Web site No. 1 Indonesia – Demopedia

Demopedia is the recognized provider of On-line Demo Slot games that was established
in Indonesia. Currently Demopedia has presented a good online demo game, which means
a person can all play demo games along with us. The Demopedia party presents greater than tens or even hundreds of types associated with demo slot video
games whose absolute goal will be to provide pleasure
to online slot machine game site lovers. You will always make updates
and continue to be able to help the launch of the latest online games on the Demopedia site.
The point to keep in mind is of which to play on this website you do not necessarily need to sign up and will not be charged a cent.
Almost all games on Demopedia can be played for free or at
no cost, and could be played about all types of smartphones, tablets, personal
computers and laptops. Typically the demo game can of course be played anywhere and there is no
time limit to try out. All the facilities offered by Demopedia and also
the particular convenience you acquire when you are all playing, this
particular site has gained the nickname as the No.

1 Slot machine Demo Site within Indonesia.

To choose an online gambling site that can be reliable and provide the
best service, you must know and know first with the betting
website that you will choose. Also make sure the web betting that you find meets
the conditions because the best online gambling site.

Do Research in Forums

The simplest way to make sure you can properly use a gambling site or not
is to see or participate in discussions with people in gambling online forums.
Those in the gambling forum are usually experienced players and know which wagering sites offers the best

Ask the Player

If speaking about in a community forum is difficult that you should do or do not know
which forum you can visit to do research, we advise that you directly
ask the more experienced players. In addition you
can also request tips and tricks on the best strategies which can be applied in the

Option Link l69
L69 is one of the official sites that supply the most recent alternative link trusted online betting sites.
L69 provides more than 1 alternative link from each betting site, and all of us here have become the most comprehensive alternative link providers
and the L69 web site includes a responsive display of which makes it easy so that you can access our site from the display of your current gadget or laptop.

In addition to what you need to know is that we here have
only one official link, l69. myself and if there
are usually other websites that provide information or call the website
is not the official site.
Ball betting and casino gambling are usually varieties
of games that are very well-liked by the folks of
Indonesia. Why l69? Since we’ve been here for a lot more than five a number of have become
the trust of the folks of Philippines as a location to
perform soccer gambling and in addition on-line casino gambling.
Itself has additionally obtained a license coming from the Asian and Western governments
last season to become an online gambling gambling provider site in Parts of
asia and Europe. By offering lots of different types of wagering bets
that can be played about one ID, much more the particular members feel happy actively playing in your bookie.

Advantages of Alternative Links l69
Nevertheless however lately there usually are many members who encounter problems and problems any time entering into their Bola tangkas game since
the Sbobet internet site is normally blocked and lots of aged sites have been clogged by the Indonesian authorities and not a few are usually also affected by what is called
the Newsletter Job. The Indonesian government recently is struggling to get rid of links or paths to
get into sites that smell associated with pornography, gambling and right now there
are many other content that will is deemed inappropriate.

Are you a fan of gambling online games? Here we suggest not to choose a
sports agent carelessly, because presently there are many
online soccer providers who impersonate official agents to request
you to make a profit from you.

Depobola is surely an online soccer agent that has passed the test from World gambling experts, and already has
an official permit obtained from an official online gambling company in Asia,
besides that Depobola is one of the agents that
provides complete products and products that already have official permit from the world gambling company.

Depobola is also one of the sites that provides the
best service for you, here we provide all services from professional customer support
who will serve you, our top concern is the safety of our members’ personal data privacy.
The reason being the Depobola site is one of the recommended sites from online wagering
centers as a trusted online wagering site.

How to Register Depobola
Here Depobola will provide you with instructions for how to register
on the Depobola website, here there are only 3 steps so that
you can claim your IDENTITY at Depobola.

there are not many wagering sites in Dalam negri that could hold the particular title as the greatest slot gambling internet site.

One of them is BandarUsernesia. This specific site presents numerous types of slot
machine gambling games through well-known providers these kinds of as Pragmatic Perform, Habanero Systems, Microgaming, and so about for slot betting fans in Philippines.

With a fantastic visual display and razor-sharp and attractive colours, BandarUsernesia has prevailed in providing the particular
maximum online gambling encounter for its
faithful customers. Not in order to mention the great bonuses
and promos that you can get on many events. The more frequently you
play, the higher your chance of getting these promotions and bonuses.

BandarUsernesia is equipped with unique features
that are prepared in order to keep players comfy that are attached to this site each day.
Are as follows.

Complete Game
Although it is more generally known as a web based gambling slot internet site, BandarUsernesia also offers other types regarding gambling games this kind of as soccer betting, casino gambling, online poker, and many
other exotic gambling games that you can find on this specific site.

Depobola is one of the intermediary agents working with
the top online bookies sites. You can expect various
products that may be accessed by online gamblers
such as sbobet, maxbet, klik4d, cockfighting, agile basketball, shooting fish, internet casino,
and many others. Depobola as a provider site for online gambling gambling has been founded since 2014, we are already very experienced in large
purchases and provide playing satisfaction to online soccer betting lovers.

Advantages of Choosing a Depobola Site as a Football Broker
In the deal process, storing money or withdrawing money is
processed quickly in minutes.
Supplying the best service, served by customer service who are able to be contacted anytime during 24 hours online.

Members can enjoy attractive promos and jackpot prizes from many products we provide.

Has good security standards, so there is no need
to worry about personal data signed up by members on our site.

Any winnings will be paid without a lowest or maximum amount.

Complete features, Depobola makes it easy for its people to contact us
via livechat or messenger, we also make sure you provide an alternative site in the form of a mirror site so that it can be seen by its users.

Are you currently a lover of online slot betting games? This game has existed for hundreds
of years but continues to be one of the favourite games in Usernesia even in luxury gambling places like Las Vegas or Macau, slots are always neatly aligned
waiting for enthusiasts to be able to levers
and win jackpots that reach billions of rupiah..

However performed you know if this game was at first considered a flop game?
Yes, at the beginning of this game created by its creator named Charles August Fey in 1894 in the
United States, this machine was intended as an programmed poker game machine that could be moved using coins.

After attempting to build his idea into reality,
Fey finally quit and considered his discovery
a failing. But who would have thought that this machine turned out there to be one of the most widely used online
games in the world. Not only in slot gambling games provided by
gambling houses but also the concept utilised by
various games as a “bonus game”.

This is where the game relating to the RNG or Random
Number Generator was initiated, where the machine will give
random values ​​that will determine what you will get each and
every round of the overall game. Not only slots but in addition online games
like virtual sports activities or bonus online games like gacha also
use this kind of concept.

Sbobet Casino is a form of online casino gambling game that has mushroomed in Indonesia.
Players no extended need to move from their benches to play on line casino gambling, because now
with the advancement in technology the gambling industry has now entered a new phase known as online gambling.
Present Sbobet provider as the best betting promoter in Asia with the
internet betting method certainly provides more advantages because it is
readily available to you wherever and when you want it.

View the Best Movie associated with All Time
What film do you want to watch today? Sniper films may be required on your list.
This is the most exciting shooting fight, where every
sniper activity is always interesting to watch.

I have to thank you for the efforts you have put in penning this blog.
I really hope to see the same high-grade blog posts
from you in the future as well. In truth, your creative writing abilities has inspired me to get my own website now

Tyre of Fortune: The show biz industry Edition

Wheel regarding Fortune is one of the best online casino games
you can enjoy in 2019, also it was developed
simply by a company often cited because the
best casino developer, IGT. If you’ve observed the Wheel associated with Fortune show before, you probably know how it performs.
In this game, you play typically the role of among the contestants,
and it’s your decision how very much money
you would like to gamble on each spin.

this game lets a person win a whole lot of money in case you are lucky.
The income may be huge, but a person will need to bet some cash to have this.

this game will be amazing for everybody who is playing the overall game and wants
in order to be a part of the display rather than just viewing it on TV,
watching other people get excited while they are sitting
at home. When you have actually desired to be the part of the Wheel of Fortune, this
online casino may be actually looking for!

How Does Wheel of Fortune: Hollywood Version Work?

This sport is in fact a representation of the famous TV SET
show, where an individual wager the guess and spin the particular
wheel. Your revenue increase according to just how
much money you bet, however they are also
tied to the payoff a person get.

As well, this specific game has far more features to provide.
A person get a chance to get yourself a random jackpot bonus.

This will be seen once you spin and rewrite the jackpot wheel
and an image appears in your screen – with each spin is made, the particular
jackpot increases.

I’m amazed, I have to admit. Seldom do I come across a blog that’s
equally educative and entertaining, and without a doubt,
you’ve hit the nail on the head. The issue is an issue that too few men and women are speaking intelligently about.
Now i’m very happy that I stumbled across this in my search for something regarding this.

Betberry is one of the best online betting broker sites in Dalam negri which has already been established since last year.
Along with the particular increasing number of online casino websites, many of all of them have decided to close due
to hard competition. For 9 years Betberry has been established plus
trusted as a new safe destination to wager, you can expect
the best service for our users. The good information is that we have been here that Betberry has used a good updated system to play all online games at once within 1
id. You no longer require to change your ID,
if you need to be able to play at some other providers and the funds are already using seamless
wallet technologies.

Indonesia’s Best and The majority of Complete Online Slot
machine game Gambling Bookies

The Userbolavip site provides also been furnished with various features that are intended for the particular safety and comfort and ease of loyal clients
throughout Indonesia. By simply registering as a member an individual
can immediately like a variety of complex and attractive functions that this best plus
most trusted on-line slot gambling internet site Userbolavip

Complete type of game
By becoming a new member of typically the Userbolavip online wagering site,
you may find various varieties of internet gambling video games.

Not only slot machine games, here you may also find other popular types associated with games such
because soccer gambling or perhaps sports betting, online casino gambling, poker, etc.
All games may also be guaranteed quality because they are provided by the particular best
gambling online websites in the world.

The way to Register for a Userbolavip Account

To be able to register as a member about the Userbolavip
internet site, the method will be very easy, the first step you have to perform
is visit typically the official website or perhaps through the most recent alternative link provided by Userbolavip: Bukauserbolavip.

Via the option link above an individual will go straight to the
main page as well as in the upper proper corner, click on the ‘REGISTER’ button to get into the
registration webpage. Then you may look for a page together with several fields
of which must be completed with your individual data completely in addition to

After generating sure that just about all fields are stuffed
in appropriately and correctly, complete the registration process simply
by pressing the ‘REGISTER’ button that is in the bottom regarding the registration web page.
Within a few minutes you will get confirmation that the account you created is usually active.

Userbolavip Online game Login

After signing up, you will obtain a user ID in addition to password which you can use to login the online game.
To do therefore, go back to the primary web page
from the userbolavip site and at the top you will discover two columns of which say the username plus password.

Enter your username and pass word in both career fields and press the
particular sign in button next to them. When successful, you will be
able to be able to access gambling online video games provided by Userbolavip.

Indonesia’s Best and Many Complete Online Slot machine game Gambling Bookies

The Userbolavip site provides also been pre-loaded with various features that are intended for the safety and
convenience of loyal customers throughout Indonesia. Simply by registering as a
part you can immediately have a variety of superior and attractive features that this best plus most trusted online slot gambling site
Userbolavip has.

Full type of online game
By becoming the member of the particular Userbolavip online betting site, you could find various varieties of gambling online games.
Not only slots, here you can also find other popular types associated with games such as soccer gambling or
perhaps sports betting, on line casino gambling, poker, etc.
All games will also be guaranteed quality because they are provided by the particular
best internet gambling internet sites in the globe.

Betberry is one of the top sites in typically the online gambling market
in Indonesia of which provides slots, online casino,
sportsbook, shooting seafood, money claws, holdem poker, cockfighting and lotto.
We have released seamless technology that will provides a fairly easy remedy for gambling
online players. With just one IDENTITY, you can appreciate all the online games from various providers without needing to move money from provider in order to another.
Betberry alone is certified by simply the Nexus Powerplant, which means we all offer services to players for all
Indonesian players legally.

How to Login Sbobet Dalam negri
If a fellow member already has an official Sbobet bank account, it is very an easy task to log inside to Sbobet Dalam negri.
We provide many official alternative links that can be
accessed all over the world. Logging in for the very first time on our established site requires a new password confirmation and password change to preserve your security.
For members who have logged in a lot more than once, presently there
is no require to confirm as before. Members may immediately log in to Sbobet Philippines to try out the
game they want.

Opportunities to Win Playing from Sbobet Indonesia
We are the largest service provider who is one of the most courageous in offering winning opportunities regarding members.
Of all the games, the margin that Sbobet gets is a few.
4%. Therefore , bettors benefit greatly whenever playing on the sbo site.
The greater usually the bettors wager, the more most likely it is to get even even more wins.
Below is usually the margin attained by the sbo sportsbook
from the particular betting turnover associated with all bettors who may have joined us.

Indonesia’s Best and Most Complete Online Slot Gambling Bookies

The particular Userbolavip site provides also been pre-loaded with various features that are intended for
typically the safety and comfort and ease of loyal consumers throughout Indonesia.
Simply by registering as a part you can immediately
have a variety of superior and attractive
features that this best plus most trusted online slot gambling web site Userbolavip has.

Total type of game
By becoming a new member of the particular Userbolavip online betting site,
you can find various sorts of internet gambling games.
Not only slot machines, here you can also find other popular types associated with games such as soccer gambling
or even sports betting, online casino gambling, poker,
and so forth. All games will also be guaranteed quality since they are provided by the particular best online gambling internet sites
in the world.

Trustworthy Indonesian Online Slot List Site

Bandaruserbolavip is a site that provides a listing of the very
best online slots in Indonesia in addition to slot bookies that have trusted transaction services.
Set of slots upon the Bandaruserbolavip internet site provides benefits in order to members in quickly
playing all video games with just one ID and without needing to move balances.

Bandaruserbolavip also provides the best service within online slot lists by filling out there forms or getting in touch with our cs that
are ready to serve members day to day. Through the Bandaruserbolavip web site you could
find various sorts of quality plus well-known slot wagering games.
The Bandaruserbolavip site has collaborated with many regarding the leading gambling game providers inside Asia and even the particular world

Best On-line Slot Provider
Calling Bandaruserbolavip as the best and reliable online slot gambling site is regarding course not without reason, here is a website worked
with with various top online betting online game providers in typically
the industry. below are a few associated with our official providers.

Probably the most Trusted Online Gambling Web site

Online soccer gambling sport is still one of the best gaming categories which has never been lacking
of bettor. One regarding them is SBOBET Indonesia’s gambling site, which is usually loved by most Indonesian persons combined with the popularity of soccer in this country.

This specific also makes the on the internet provider sites mushroom inside the natural world.
Even though Indonesia is known as a country that will prohibits gambling
activities, that does not mean that will its citizens who
usually are fans of online gambling games cannot access
these types of games.

Due to rapidly developing internet technology you can now directly place various types of bets on online football gambling sites such since Asian Handicap,
HT / FT, Parlay, etc. A person can safely access almost all of these games via gambling services provided by simply Depobola.

Depobola is a trusted agent site of which provides various types associated with options including soccer
gambling. Sportsbook games provided by simply
Depobola all come coming from leading gambling providers
these kinds of as SBOBET and CASINO.

In other words, almost all the games you can find on Depobola are regarding international standard with rivalling odds.
And here depobola as an online soccer agent
acts as the portal that connects fans of sportsbook games within Indonesia with the greatest gambling services in Parts
of asia and also the world.

Trusted SBOBET and IBCBET Football Gambling Sites
The a couple of best gambling companies of which provide soccer gambling video games to date are SBOBET and

Founded 7 years ago, SBOBET is a company that has the
base in Asia. Working in the Asian location with a CEZA-First Cagayan license obtained from the particular Philippines and an OGRA license from the Department of Man. SBOBET had been a sponsor of England’s top football teams such as West Ham Usa, Cardiff Cityy, Swansea Metropolis, Southampton and many more.

Last season and 2010 SBOBET Indonesia received an prize as “Asian Operator of the Year” from
eGaming Review Magazine and came into into the list
of typically the 50 most influential businesses by EGR Magazine from
number 11.

IBCBET better known by the name of Maxbet is the major operator
in Asia and a single in the most significant bookmakers within the world.
It has been extensively recognized throughout the globe thanks to quite
high gambling limits and offers survive betting
with very aggressive odds.
Provides the greatest online sportsbook game upon the market and
there are a lot more than 20 sports of which players can use since betting objects in typically the game.

Advantages of Depobola as a Football Gambling Web site
Choosing a sports agent being a play partner can not be arbitrary because it must pay out attention to some important standards that must end up being met as the greatest
and most trusted soccer agent. Therefore, your work when choosing a partner
site will be not an easy job and can consume a lot regarding energy.

To simplify your current work, we recommend typically the Depobola site being a
gambling agent site that has been tested to serve an incredible number of customers professionally and meet important
conditions as the finest official gambling agent within Indonesia, including:

Online customer support 24 hours a day time, 7 days
a few days. players need not worry whenever facing difficulties or misunderstandings during play
because they will can always contact our customer service for help or guidance.

The minimal deposit is low thus there’s no need to hesitate when the player will certainly try
the game. In addition , the available deposit procedures also provide maximum comfort
and ease and security for customers. With regard to players who will be not
comfy making deposits through accounts, players can opt for the deposit method through the
OVO service.
Variants of typically the game are incredibly complete to ensure players do not experience
boredom while playing with us. There are many types of exciting on-line betting options provided by simply
well-known gambling sites.
The best bonuses and advertisements that will give an individual more
profit when playing with us. You are able to adhere to these
bonuses and promotions in a fairly easy and absolute, wholehearted
All betting sport products provided by Depobola are fully secure and have
been officially licensed by SBOBET and IBCBET.

Ion Casino

Ion casino is a trusted and best online casino site from 2010 which includes offered millions of players in Asia.

Ion casino or also referred to as Ionclub
is the particular top ranking option site because that provides the finest experience for gambling online players in Philippines.

With an recognized license to function, this provider assures that players help to make bets
without risk, credibility and can be trusted.

Did you know messages that come through on your website contact form can actually be a great way to get more sales for your online business? How do we do this? Simple, we craft an ad for you and we mass post it to hundreds of thousands website contact forms on any website and in any business category or area you need. Does this work? Of course they do! You’re reading this now aren’t you? The best part is, you can do this for less than a hundred bucks a month! Want to get more info? shoot us a quick email to: HardinJakobev58771@gmail.com

Daftar Situs Judi Online Terbaik in Indonesia
Situsalternatif are the collection of lists of the finest online gambling sites from all well-known bookies / providers in Indonesia.
Home elevators online gambling sites listed on this particular page
is obviously transforming, because we just provide sites that
get good reviews. Each site provides some informative concerning
the games accessible, deposit transaction alternatives,
and alternative links.

Collection of Situs Alternatif and Daftar Judi Online Terbaik
Actively playing on gambling internet sites is not really completely clean,
one of many problems frequently through players is usually
difficulty accessing the site where to play due to internet site blocking.
Therefore, the Alternative Site collects option links here which usually are incredibly useful in order to help gamblers in order to easily login and daftar judi online.
Within addition, you don’t need to bother about the link jalan keluar judi that we provide, needless to say an individual can access that easily and regarding free.

Listing of Alternative Linksbo Links
Today is increasingly developing, making it less difficult
for individuals to access computerized networks. Till now there are numerous on-line gambling games that can be played by anyone online.
Therefore, gambling lovers no extended require to
the casino to play gambling, this is very effortless for them to play
anytime in addition to anywhere without restrictions.

Mabosbola is an established internet casino agent that provides
access regarding online casino fans in Indonesia to the best online on line casino
gambling games. Mabosbola acts as a connecting portal by giving full
accessibility for you fans associated with casino gambling games towards the best online casino
game provider sites for example Sbobet or Nova88. Started in 2018, Mabosbola has
an incredible number of users from all over Dalam negri.
Every day there are hundreds of men and women connected to
the video games given by Mabosbola. Despite the fact
that this site is nevertheless relatively young,
this site has been verified to end up being
able to supply professional services for every customer and get an official certificate from PAGCOR.

The Best Types of Online Casino Games
Not only does it provide full access to various types of complete online
casino online game collections, Mabosbola also provides quality and international standard games served by the
best internet casino gambling providers within their class.
The following usually are some of the provider companies
who have collaborated with Mabosbola in providing the
best online on line casino gambling in Philippines.

Many of the sites that provides the best online gambling sport services
in Dalam negri is Promosbobet. On-line bookie sites that can offer direct
access from home via typically the internet network plus will be a great alternative to boost bettors’ income without having to shell out a lot
associated with capital.

Imagine, with only relatively inexpensive
capital, members may play the most exciting betting
games of which members want this kind of as
soccer betting, online casino, or even actual money online slot machines, not to mention get typically the financial benefits that will members need.

Every thing a member can achieve just by turning into an official member regarding the
best and most trusted online bookmaker site Promosbobet.

The greatest Online Gambling Promotion
Bettors can obtain various types regarding benefits by getting a member of the
Promosbobet gambling site. This web site always provides amazing promotions achievable consumers and loyal consumers who have selected Promosbobet as a
new betting partner regarding years.

Deposit Added bonus – the first bonus that a new member can get simply by
becoming a associate of Promosbobet is usually when the
fellow member makes a deposit with a minimum of IDR 100, 500 only!
Bettors could get bonuses of up to almost 2 mil rupiah.

Winning Reward – just by playing online football gambling that you want or enjoying the fun plus challenges of shooting fish games,
you have a possiblity to win a winning bonus of up to 50%.

Cashback and Rebate Bonus – by working with Sbobet and Maxbet, Mabosbet gives you
the opportunity to get an immediate 5% cashback and 75% rebate!

Thank you, I’ve just been searching for information about this subject for a long time
and yours is the best I have came upon till now. However, what in regards to the conclusion? Are
you sure in regards to the supply?

As an online gambling player, it is important to know
what sites are fine to visit and can be used as a area to perform online gambling.
neglectfully choosing a site is tantamount to wasting capital for free.
Not and no-one else you will lose but next waste era and opportunity to succeed in this business.

Not a few people make mistakes with this until they finally drop into the abyss of bankruptcy / exterminate because they can’t win even in all game they do.
Unfortunately, most people who experience this blame the game then again of introspecting on what they have done.

In essence, if you produce an effect gambling inattentively and without preparation,
when any supplementary thing in the world, of course, you will end occurring in failure.
Therefore, we want to give recommendations for the best online gambling sites that you can visit and become cronies playing online gambling to achieve capability in this industry.

The post of the site is Mabosway, a site that provides
various types of definite and best-in-class online gambling games.
upon the Mabosway site you can pick various types of games ranging from popular gambling games such as online poker, online casino gambling like various variants, as capably as sports gambling games
that are well-liked similar to people in Indonesia.

There are many more important features that the Mabosway site
has, however, there are several important features that you infatuation to know that make Mabosway the best site and
many online gambling players trust in Indonesia.

Sbobet is a trusted gambling site that operates to relieve every fans of online gambling in the world.
Founded in 2010, it didn’t resign yourself to long for Sbobet to become the biggest online site in Asia and
as soon as it comes to the amount of betting keep that rotates all week, Sbobet is in addition to one of the biggest sites
in the world.

Sbobet is definitely popular, especially in the course of Asian bettors, the
reason is that the site has been awarded as the best gambling operator for two years in a row.
It offers a variant of football betting bearing in mind unquestionably low margins similar to compared to additional sites in its class.

okay and thank you for visiting online casino agents for Indonesia.

Here we are here to present access for fans of sbobet casino
who want to connect the international agent site Promosbobet.

The products offered are certainly diverse and are enormously the best choice.
Derived from providers that have credibility and have
been proven to have the best predicate in serving their
customers. Providers in the manner of Sbobet, Maxbet and many more.

As the best online casino and soccer gambling site in Indonesia.

We present maximum minister to in the same way as customer support
that works online 24 full hours all day. for that reason members can ham it up whenever and wherever without
fearing to incline the possibility of difficulties or confusion.

Option Link l69
L69 is one of the official sites that offer the most recent
alternative link reliable online betting sites. L69 provides
more than just one alternative link from every betting site,
and we here have become the most comprehensive alternative link
companies and the L69 web site has a responsive display that will makes it easy that you should access
our site coming from the display of your current device or laptop.
In addition to what you need to understand is that we here only have one official link, l69.
myself and if there are other websites that provide information or call the website is not our official site.

Ball betting and casino gambling usually are forms of
games that are incredibly popular with the men and women associated with Indonesia.
Why l69? Because we’ve been here for more than five
years and possess become the trust of the individuals of Indonesia as a location to play soccer
gambling and also on the internet casino gambling.
Itself in addition has obtained a license from the
Asian and European governments in 2009 to become an online gambling gambling provider site in Parts of asia and Europe.
By providing lots of different types of wagering bets
that can be played on one ID, much more the members feel happy enjoying in your bookie.

Great things about Alternative Links l69
But regrettably lately there are many members who knowledge problems and problems any time entering into their Sbobet game since the Sbobet
internet site is usually blocked and many old sites have been clogged by the Indonesian federal government
and never a few are usually also afflicted in what is called the Newsletter Job.
The Indonesian government lately is struggling to
get rid of links or paths to gain access to sites that smell regarding
pornography, gambling and right now there are many other content that is deemed inappropriate.

kalau kasusnya begini Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\NAJA\search_exe.php on line 15
apa yang harus dilakukan?

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\cari\connect.php:6 Stack trace: #0 C:\xampp\htdocs\cari\search_exe.php(2): include() #1 {main} thrown in C:\xampp\htdocs\cari\connect.php on line 6


include "koneksi.php";

$tanggal_daftar = date("Y-n-d");
$nama_lengkap = $_POST['nama_lengkap'];
$jenis_kelamin = $_POST['jenis_kelamin'];
$TTL = $_POST['TTL'];
$agama = $_POST ['agama'];
$golongan_darah = $_POST ['golongan_darah'];
$alamat = $_POST['alamat'];
$kelurahan = $_POST['kelurahan'];
$kecamatan = $_POST['kecamatan'];
$kota = $_POST['kota'];
$provinsi = $_POST['provinsi'];
$kode_pos = $_POST['kode_pos'];
$no_telp = $_POST['no_telp'];
$asal_sekolah = $_POST['asal_sekolah'];
$alamat_sekolah = $_POST['alamat_sekolah'];
$jurusan = $_POST['jurusan'];
$nilai_SKHU= $_POST['nilai_SKHU'];
$nama_ayah = $_POST['nama_ayah'];
$pekerjaan_ayah = $_POST['pekerjaan_ayah'];
$penghasilan_ayah = $_POST['penghasilan_ayah'];
$nama_ibu = $_POST['nama_ibu'];
$pekerjaan_ibu = $_POST['pekerjaan_ibu'];
$penghasilan_ibu = $_POST['penghasilan_ibu'];
$alamat_ortu = $_POST['alamat_ortu'];
$nama_wali = $_POST['nama_wali'];
$alamat_wali = $_POST['alamat_wali'];
$program_studi = $_POST['program_studi'];
$foto_warna = $_POST['foto_warna'];
$fotocopy_ijazah = $_POST['fotocopy_ijazah'];

$query_insert = "insert into datacalonmahasiswa(tanggal_daftar, nama_lengkap, jns_kelamin, TTL, agama,
golongan_darah, alamat, kelurahan, kecamatan, kota, provinsi, kode_pos, no_telp, NISN, asal_sekolah, alamat_sekolah, jurusan, nilai_SKHU
nama_ayah, pekerjaan_ayah, penghasilan_ayah, nama_ibu, pekerjaan_ibu, penghasilan_ibu, alamat_ortu, nama_wali, alamat_wali,
program_studi, foto_warna, fotocopy_ijazah, SKBS)

values('$tanggal_daftar', '$nama_lengkap', '$jenis_kelamin', '$TTL', '$agama', '$golongan_darah', '$alamat', '$kelurahan', '$kecamatan', '$kota', '$provinsi', '$kode_pos', '$no_telp', '$NISN', '$asal_sekolah', '$alamat_sekolah',
'$jurusan', '$nilai_SKHU', '$nama_ayah', '$pekerjaan_ayah', '$penghasilan_ayah', '$nama_ibu', '$pekerjaan_ibu', '$penghasilan_ibu', '$alamat_ortu', '$nama_wali', '$alamat_wali', '$program_studi', '$foto_warna', '$fotocopy_ijazah', '$SKBS');";

$insert = mysql_query($query_insert);


echo "Gagal update … ";
echo "”;


mas kok gagal terus ya inputan data saya… padahal udah terhubung semuanya. lihatdata.php nya juga udah terkoneksi ke phpmyadmin lo ? tolong bantuannya. terimakasih

Tanks infonya. Hanya saja saya masing bingung bagaimana caranya “Pencarian Data” seperti kasus di atas kalau dibuat di blogspoot, yang tidak mengenal PHP dan Mysql.
Apakah bisa dengan menerapkan fungsi IF..? Mohon bantuan scrift html nya. Please….
Terima kasih

Saya pendatang baru di blog ini ingin mengucapkan terima kasih banyak kepada MBAH KUNTORO karna berkat bantuan Nomor togel 4D yang MBAH KUNTORO berikan ternyata benar2 tembus, saya tidak tau harus berbuat apa untuk membalas kebaikan MBAH KUNTORO,Awalnya saya kurang yakin dengan angka yang MBAH berikan, Tapi ternyata alhamdulillah saya menang 4D, Sudah berapa banyak peramal yang saya hubungi tidak ada satupun yang tembus malahan hutang-hutang saya bertambah banyak,kini kehidupan saya jauh lebih sukses dari pada sebelumnya ini semua berkat bantuan MBAH KUNTORO, Bagi teman-teman penggila kupon putih yang tidak pernah merasakan kemenangan 4D silahkan hubungi MBAH KUNTORO di 085-242-222-796 dan angka yang di berikan MBAH dalam 7X putaran ini tidak pernah meleset,anda jangan mudah tergiur dengan janji-janji saatnya kita perlu bukti hanya MBAH KUNTORO yang menjamin 100% kemenangan.Kalau mau bukti hubungi sekarang…!!!


NOMOR TELPON : 085 242 222 796

saya atas nama cahyo dari ciparay. Saya bekerja sebagai tukan kebun jagung & saya hidup bersama istri serta ke 3 anak saya.sayapun digaji untuk mengurus kebun orang. itupun hasilnya harus di bagi lagi kepada pemilik kebun.biasanya sy hanya dapat 400 ribu satu kali panen itupun tergantung dari banyak nya hasil dari panen jangung.kalau hasil panennya bagus maka bagian saya pun banyak.tapi kalau hasilnya sedikit maka sedikit pula bagian kami.kalau dipikir-pikir itu belum mencukupi untuk makan kami sekeluarga. dan adapun kawan menawarkan sy main togel tp sy juga berpikir dengan angka yg mau pasang, sedangkan sy tdk bs rumus.tp kawan bilang tdk usah bingung dengan angka nya karna katanya MBAH TOGEL mahir mengeluarkan angka & sy pun di berikan nope MBAH TOGEL dan sy hubungi untuk minta angka. alhamdulillah baru pertama di kasih angka ehhh sy menang 8 jt. terimakasih MBAH TOGEL; ats bantuan angkanya. YG BERMINAT ANGKA KEMENANGAN HUBUNGI NOMOR HP MBAH TOGEL DI 081998357939ato invite pin bbm mbah togel 28236645

Neither the lottery nor the stock market or commodities are EXEMPT from the Law of Belief (aka Law of Attraction).
99% losing percentage) and “all even number” combinations “hit” only 49 times over the 5-year period (a 97.
The final number, called the Powerball, falls between one and forty-two.

Kalau cara menampilkan hasil pencarian ke url permalink bagaimana ya?
Misalnya mencari “June”, maka hasil pencarian misalnya menjadi : namadomain.com/june.php
Kalau tidak ketemu, maka url diarahkan ke halaman 404.

Terima kasih, saya tunggu jawaban dan bantuannya.

gan mau tanya,,?
gimana caranya menampilkan data(record) yang kosong, di tampilkan ke tabel dan kolom yang kosong(tidak ada record nya) menjadi berwarna di setiap kolom yang kosong…contoh scrip nya gimana gan..? mohon solusinya gan..:D

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\searching\search_exe.php on line 15
No Nama Mahasiswa Alamat

setelah saya praktekan hasilnya seperti yang diatas itu mass… gmn cara nya agar bisa searching mas?

mas mau tanya
kl pencarian data lebih dari 1 table (dbs) kemudian data tersebut akan di tampilakn ke dalam table (html) gmn ya mas?
sedangkan data dari table (dbs) itu berbeda dengan isi data dari table B (dbs)
misal :
> table A : nama,alamat,telp
> table B : nama,alamat,jenis

Gan, kalo mau nampilin gambar dari database ke php pas fungsi cari, kodingnya gimana gan? Kalo pake echo”$hasil[gambar]”;
Hasilnya yg muncul cuma nama file potonya doang??

assalaamualaikum kak maaf boleh bertanya bagaimana coding query search yang di seleksi nya semua fieldnya jadi ga cuman name nya ajh kayak ini select * from data_pkl Where nama_siswa %name% kan itu hanya menyeleksi nama_siswa ajh

Thank’s Bro,,,,,sangat membantu,,,,,
saya mau tanya ni,,,,bgmn caranya buat pesan untuk admin,,,,misalnya kalau ada 3 sampai 4 user yang baru daftar, pesanx akan di sampaikan ke admin,,,jd otomatis admin akan tau berapa user yg telah mendaftar hari ini,,,jd si admin ga perlu cek lagi berapa user yang hari ini mendaftar……Mohon bantuannya

thank’s Bro sangat membantu,,,,,aku mau nanya tentang pembuatan script pemberitahuan untuk admin,,,,misalnya kalo ada user yang baru mendaftar, si admin akan di beri tau ada berapa user yang daftar hari ini,,,jd si user ga perlu cek lagi…..mohon bantuan nya,,,,sekali lagi thank’s,,,,,

tutorial searching anda bagus, sudah saya coba, memuaskan, terimakasih……..
Oya, anda punya juga gak tutorial untuk software chatting seperti di ym dan fb itu….?
mohon petunjuknya ya…..!

maaf saya mau nanya nih..
saya belum sukses bikin fungsi search, padahal saya sudah sama seperti script di atas.
pada saat di load terdapat error seperti ini “Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\PL\search.php on line 21”. On line 21 scriptnya adalah ini–> while ($data=mysql_fetch_array($result)) .
itu kira2 apanya ya yang salah.. mohon bantuannya kaka 🙂

saya mau bertanya code pencarian data dengan 2 kata kunci menampilkan alamat dan nama yang sama ..? gimana scriptnya yaa…. help me

Bro numpang nanya, kalo gw mau supaya yang di-bold hasil pencariannya ga case sensitive gmn.. karena kasusnya kaya gini: kalo gw search dengan kata kunci “Janet” sedangkan di hasil search nya ada “janet”, dia ga di-bold karena Janet berbeda dengan janet (di PHP case sensitive, di MySQL ga case sensitive), nah gmn caranya kl gw mau hasil janet jg di bold… thanks jawabannya… 🙂

mas mau nynya klo udh berhasil membuat tapi waktu diketik nama lalu di searc muncul Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\searching\search_exe.php on line 18 nnnnn mksd pa n tolng bantuANYA

klo eror’a kyk gni knp mas?
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\iq\search_exe.php on line 15

ini saya punya form pencarian yang menggunakan list menu…tpi kenapa klo listnya gak diselect tetep membaca
tolong bagaimana caranya klau list menu g di select jadi ia otomatis g ada valuenya

Form Tenaga Kerja

Pencarian Data Karyawan


contoh untuk yang multiple keyword bukan di namanya aja lho …

if (isset($_POST['search'])) {
if ($_POST['keyword'] !='' ) {
$keyword = trim($_POST['keyword']);

$sql = "SELECT * FROM pegawai WHERE nik LIKE '%" .$keyword. "%' OR nama LIKE '%" .$keyword. "%' OR tempatlahir LIKE '%" .$keyword. "%' OR tanggallahir LIKE '%" .$keyword. "%' OR divisi LIKE '%" .$keyword. "%' OR alamat LIKE '%" .$keyword. "%' ";
$query = mysql_query ($sql);
$countData = mysql_num_rows ($query);

//dicek apkah data ada atau tidak ada
//jika data ada atau lebih dati nol, lakukan looping data
echo "”;
echo “”;
echo “NO\n”;
echo “NIK\n”;
echo “NAMA\n”;
echo “TEMPAT LAHIR\n”;
echo “DIVISI\n”;
echo “ALAMAT\n”;

if( $countData > 0 )
while($data = mysql_fetch_assoc($query)) {
echo “”;
echo “”.$i.”\n”;
echo “”.$data[‘nik’].”\n”;
echo “”.$data[‘nama’].”\n”;
echo “”.$data[‘tempatlahir’].”\n”;
echo “”.$data[‘tanggallahir’].”\n”;
echo “”.$data[‘divisi’].”\n”;
echo “”.$data[‘alamat’].”\n”;
echo “”;
} else {
echo “”;
echo “– data tidak ditemukan –“;
echo “”;

echo “”;
echo “ ditemukan data “.$countData.” record“;
echo “”;
echo “”;
} else {
echo ‘– silahkan masukkan keyword –‘;



sy ikut nanya…..
sy udah ikuti cara yg diterangkan diatas ..tapi gambar yang upload tidak masuk ke C:\xampp\htdocs\halloMobile\image\ …tp gambar hasil upload ada ke folder E:/DocumentRootTuni/helloMobile/image/ Tolong pencerahan … Trm ksh:?: ❓

Tolong bantu dong..
Gimana codingnya kalo hasil pencariannya tetap di halaman yang sama, jadi gak perlu bolak-balik gt. Udah kucoba tp fatal error.

ak mau nanya…gmana ya mau search data di dlm dbase sekalian ama picturenya..ak berhasil menyimpan data ke dbase dan picture ke folder..tapi bila ak mau search base on ID…kok hanya data aja terpapar…piturenya enggak…g mna ya kak…terima kasih ya atas bantuan.

malaysia user

Nah, kalo sistem pencarian dengan multi kata & lebih detail dengan menggunakan array gimana Mba?
Misalnya :
dimana rumah kamu

yang kita cari :
* dimana rumah kamu
* dimana rumah
* rumah kamu
* dimana kamu
* dimana
* rumah
* kamu

trus masing-masing diberikan nilai & dicari modusnya. Ini implementasi untuk pencarian lebih detail. Bisa dibantu? tolong send email ke gotechidna@gmail.com

(Dulu pernah bikin tapi ilang karena hd keformat T_T)

Bos klo databsenya dari ms access gmn ? konek… ok tapi mentoknya selalu di ” Fatal error: Call to undefined function odbc_query() “.
Tolong dong bos…. udh diotak atik…. blom nemu nih…

mau tanyaknih lagi bingung.
gimana cara untuk menyimpan data record pada tabel.

table disini fieldnya dinamis, misal pada tabel mhs filednya ada idmhs,nama;

sehingga perintah sqlnya:
insert into mhs (idmhs,nama) value (\\\\\\\’$idmhs\\\\\\\’,\\\\\\\’$nama\\\\\\\’);

bagaimana jika ada penambahan filed kelas. sehingga filed table pada mhs menjadi (idms,nama,kelas); untuk penambah field itu saya sudah bisa. yang jadi permasalahan bagaimana cara menginputkan data yang fildnya bertambah secara dinamis. skrip penyimpanannya bagaimana.

mohon bantuan pra programer.

Mas, kalau mau buat pencarian dgn multi kolom dan hasilnya ditampilkan dalam bentuk tabel, terus tiap hasil pencarianya bisa ditampilkan detil infonya gimana Mas? Misalnya pencarian berdasarkan provinsi, rentang usia, kemudian hasil pencariannya bisa ditampilkan detilnya satu-satu.
Maklum Mas, msh baru..

bos aq buat web kan nggak pakek php cuma css dan html…. trs cara buat searchnya gmn soalnya ni tinggal searchnya aja yang g fungsi….

saya nak buat carian nama sekolah dengan cara yang mudah sekiranya tidak ingat kod sekolah tersebut.saya guna combobox..help me plissssss 🙁

gan codingnya error pas ane klik cari
“Warning: include(koneksi.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\SKRIPSI\test2\search_exe.php on line 2

Warning: include() [function.include]: Failed opening ‘koneksi.php’ for inclusion (include_path=’.;C:\xampp\php\PEAR’) in C:\xampp\htdocs\SKRIPSI\test2\search_exe.php on line 2

Warning: mysql_query() [function.mysql-query]: Access denied for user ‘ODBC’@’localhost’ (using password: NO) in C:\xampp\htdocs\SKRIPSI\test2\search_exe.php on line 5

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\SKRIPSI\test2\search_exe.php on line 5
Hasil Searching

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\SKRIPSI\test2\search_exe.php on line 15”

mas mw tanya dong,
bikin search tapi ketika disearch data yg muncul bisa di update sma di delete, terus jika data yg di panggil tidak ada harus mengeluarkan pesan, itu gimana mas? 😥

saya lagi merancang aplikasi alkitab online menggunakan php dan my sql,,mohon sarannya yaa,,buat pemanggilan dan menampilkan pasal,ayat dan isi setelah dipilih dari combobox. juga pencarian kata dalam alkitab.

oke banget nih … aku sudah coba dan sukses … tapi ada kendala nih… (thinking) gimana kalau kita mau memasukkan data ke tabel yang sudah dibuat? tanpa perlu repot2 masuk ke databasenya? maksud saya form untuk pengisian data sekaligus untuk meng edit data tersebut jika ada kesalahan penginputan?! ….. wah jadi pengen belajar terus nih kalo gini nih….

ilmu yang sangat bermanfaat! 🙂 makasih sebelumnya & permisiii untuk copas nyang diatass

Hi mau nanya donk kk..

kok saya malah jadi tampil semuanya yg ada di database padahal udah di sesuaikan semuanya..
gimana ya?

saya mau nanya ada ndag script buat mencari file berdasarkan kata2 yang ada di dlam file tersebut…?
klo ada bagi donk

ini sdah berhsil, sudah ada tmpilan nya,tapi susunan data yang tmpil tdak berurut,,
terus pda saat saya mengklik tmbol hlman dua kok nggak ada tampilannya seeh,,,
kira2 itu pnybab nya apa yach…?

itu khn script utk proses di satu halaman saja.
halaman dua dst ya butuh pemroses lagi dong.

coba deh googling tentang LIMIT dan ORDER BY di mysql.

$conn = mysql_connect("localhost", "root", "admin");
//mencari banyak data yang ada dalam tabel
$sqlCount = "select count(id) from upload";
$rsCount = mysql_fetch_array(mysql_query($sqlCount));
$banyakData = $rsCount[0];
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$limit = 10;
$mulai_dari = $limit * ($page – 1);
$sql_limit = "select * from upload order by keterangan limit $mulai_dari, $limit";
$hasil = mysql_query($sql_limit);
//menampilkan data
echo '

Data Arsip
while($data = mysql_fetch_array($hasil)){
echo ”;
echo ”.$data[‘id’].”;
echo ”.$data[‘keterangan’].”;
echo ”.$data[‘bagian’].”;
echo ”.$data[‘tanggal’].”;
echo ”.$data[‘name’].”;
echo ”;
echo ”;
//membuat pagination
$banyakHalaman = ceil($banyakData / $limit);
echo ‘Halaman: ‘;
for($i = 1; $i <= $banyakHalaman; $i++){
if($page != $i){
echo '[‘.$i.’] ‘;
echo “[$i] “;

di address bar dah ada tampilan nya cuman tampilan nya itu ndag berurut,,,
terus klo di saya kli hlman ke dua, ke tiga dst..
itu tidak ada satu pun data yag nampil sma klom nya sja
dan untuk menampilkan data pada halaman brikut nya saya pakai script
(echo ‘[‘.$i.’] ‘;)

saya sudah berhasil mbak tapi saya mau mnta scriptnya lagi buat menambahkan tombol sebelumnya dan selanjutnya
krna sya takut kan nnti kalau data ku udah bnyak nnti halaman nya tambah panjang lagi]
tq before

blum ada mbak,,,
dsni mmng sudah tercetak nmor2 hlman brikut nya tapi tmbol untuk next dan previous nya nggak ada
sya mau nya itu sprti ini
prev 1 2 3 4 5 6 7 8 9 10 ….30 next
model nya seperti itu mbak
krna skrng itu tmpilan nya hnya sprti ini
1 2 3 4 5 6 7 8 9 10 dst sampai data itu brkhir,,,
kan klo gtu mbak kan ribet jadi nya,,,
krna klo data semakin bnyak masa urutan hlman jga akan semakin pnjang gtu

kak bagaimana cara membatasi hasil pencarian.misalnya: hasil pencarian sebanyak 20 baris.. kemudian kita akan menampilkan 10 baris terlebih dahulu lalu 10 baris yang lain ditampilkan di halamn yang laen.. mis pake kode ?page=2. tolong balas ke email ya kaks plese codenya ditunggu..

bisa minta script untuk memberi peringatan apabila ada user langsung mengklik tmbol login tanpa mengisi username dan passwrd nya,,,?
mis : peringatan bahwa “Anda belum memasukkan username dan password
bgtu jga klo cma pass atau email yg di isi

ternyata sya yg slah sya lupa memberikan koneksi nya,,,
tapi ndag ada tmpilan nya,,,
data yg di cari nggak muncul,,,

data di dalamnya memang ada atau tidak?

kalo dicoba querynya “SELECT * from tb_student where name like ‘%$name%’ ” langsung di phpmyadmin hasilnya gimana?

ia sya sudah coba dengan menggunakan script sprti itu,tapi msih blum ada hsil nya,brhbung dgn saya mau mencari data brdsrkan keterangan bkan nama,
jadi sya pkai seperti ini “SELECT * from upload where keterangan like ‘%$keterangan%’ “;
udah cocok,ato gmna,,,?

hey mbak ayhu,,,!!!
ngpaen kmu nulis prtnyaan km d form sya,,,?
jgn replay dsni mbak,buat kolom bru donk,,,
tpi nggak pa2 dech, kbtulan sya jga mmpnyai mslah sprti itu, dri kmrin sya msih blom jga menampilkan isi file yg di cari

masalah memang banyak, jadi jangan ragu mencoba.

tool yg wajib dipunyai: phpmyadmin, kalo gak tahu apa disearch aja.

checklist dulu:
tabelnya udah diisi data belom?

iya sya sudah mengisi tabel database nya,
mkanya itu sya heran kok,msih ndag bsa nampilin isi data yg di cari

di bawah kode ini:
$result = mysql_query($q);

echo $q;

ntar khn keluar querynya apa. trus query tsb dicopas dan dijalankan ke SQL-nya phpmyadmin, trus lihat hasilnya. hal ini utk mengetahui apakah querynya udah bener apa blm.

di saat saya mencari keterangan yg brjudul “qwerty”
muncul sperti ini SELECT * from upload where keterangan like ‘%qwerty%’
mksudnya itu apa…?

sql yg mna yg hrus sya jlan kan di phpmyadmin sya…
sql yg ini $q = “SELECT * from upload where keterangan like ‘%$keterangan%’ “;(sql yg di dlam file)
atau yg ini SELECT * from upload where keterangan like ‘%asd%’ (sql yg muncul pda saat setelah menklik tmbol search)

sql yg ini $q = “SELECT * from upload where keterangan like ‘%$keterangan%’ “;(sql yg di dlam file)
saya sudah coba menjlan kan di phpmyadmin tapi kok mncul eror,,
sql yg ini SELECT * from upload where keterangan like ‘%asd%’ (sql yg muncul pda saat setelah menklik tmbol search)
saya sudah coba menjlan kan di phpmyadmin jga klom field keterangan da klom “asd” (isi keterangan) seperti terblok

k’ saya sudah bisa menampilkan data yang di cari,,,
tapi saya mau kalau kolom search tidak di isi,ada muncul peringatan bhwa harus mengisi klom search,,,
karna saat ini, mmg sya sudah bisa menampilkan data yang di cari,,tpi saya coba dengan tidak mengisi kolom search nya kok lngsung mncul semua data yg ada di dlam database saya,,,

mksud nya gini k’,,,
sya kan mencri data berdasarkan keterangan,,,
trus sya buat kan form untuk mencari data,,,
yang sya ingin kan itu bgmna script nya untuk memberi peringatan apabila mengklik tombol search lantas tidak ada kata atau tulisan yang di ketik di dlam form pencarian (dlam klom keterangan),,,
karna sekarang ini saya sudah coba untuk mencari data sudah berhasil,,,
tapi di saat sya coba mengklik tombol search,tanpa mengetik kata atau kalimat, hasil nya itu semua data-data yang di dalam database saya muncul

btw kmaren tuh kesalahan di mana?

kalo mo melakukan sesuatu jika tidak ada input. tinggal tambahkan if sebelum proses.
misalnya letakkan kode berikut setelah $name= $_POST['name']; //get the nama value from form

if(!$name) die('Kata pencarian belum dimasukkan');

OK dech kk…!!!
mksih atas bntuan nya,,,
tapi saya mau nanya lagi kak,,,
gini saya kan buat kan hlman login untuk msuk ke dalam form dan itu sudah brhasil tapi ada satu mslah ketika saya sudah login dan sudah berada di form yang di tuju kenapa pda saat saya mengklik tmbol back kok bsa kmbli ke hlman login,,,
nah,, yang saya mau itulah bgmna script nya agar tmbol back itu tidak brfngsi bgtu pula pda saat setelah logout,,,krna logout nya jga mnglmi hal yg sama sprti itu
saya sudah login tpi kok msih bsa kmbli lagi ke hlman form,shrusnya kan login dlu bru bsa msuk
thanks sblmnya

kak saya sudah sisip kan session ke dlam file form saya dan script nya itu sprti ini

tolong coba cek script saya itu kak,,sbnrnya yg slah itu apa krna script itu saya sudah gnakan di dua form sya yg lain nya dan hasil nya sukses,tapi pda saat sya gunakan lagi di fom sya yg satu kok pda saat mmbuka form login kok lngsung mnju ke form yang di tuju stlah login (formupload.php),,,?

kok search saya ndag skses seeh,apanya yg slah yah,,
setiap sya mngklik tmbol search mncul peringtan seperti ini
“Connect Failed !! : Access denied for user ‘www-data’@’localhost’ (using password: NO)”
apanya yg slah yach…?

menggunakan fungsi str_replace, jadi hasilnya nanti ditambahi suatu tag.
contohnya sebelum $data[‘name’] di-echo, diproses dulu:
[sourcecode]$data[‘name’]=str_replace($_POST[‘name’],'<span class="blue">’.$_POST[‘name’].'</span>’,$data[‘name’])[/sourcecode]

kasus nya gimana dulu?

search dari banyak tabel.. asal dari berbagai tabel tersebut ada relasinya, tinggal ganti script ini –> $q = “SELECT * from tb_student where name like ‘%$name%’ ”

sesuaikan saja dengan kebutuhan 😀

Jika mas mau menggunakan banyak Tabel maka hanya ada satu masalah yaitu kriteria yang di cari ad di tabel” yang berbeda,, Oleh karna itu mas bisa merubah Query nya dengan menjoin kan Table” itu.
Semoga bermanfaat 🙂

Butuh Konsultasi Silah kan VIA email adiba.faiqa@gmail.com
atau boleh hub saya di 0852 8888 8696

Tinggalkan Balasan ke Promosbobet Batalkan balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

This site uses Akismet to reduce spam. Learn how your comment data is processed.