Reply to thread

Message

<blockquote data-quote="indi8305" data-source="post: 23452830" data-attributes="member: 58128">&lt;?php&nbsp; &nbsp; mysql_connect(&quot;localhost&quot;, &quot;lanka83_inc&quot;, &quot;paba832205&quot;) or die(&quot;Error connecting to database: &quot;.mysql_error());&nbsp; &nbsp; /*&nbsp; &nbsp; &nbsp; &nbsp; localhost - it's location of the mysql server, usually localhost&nbsp; &nbsp; &nbsp; &nbsp; root - your username&nbsp; &nbsp; &nbsp; &nbsp; third is your password&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if connection fails it will stop loading the page and display an error&nbsp; &nbsp; */&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; mysql_select_db(&quot;lanka83_pnts&quot;) or die(mysql_error());&nbsp; &nbsp; /* tutorial_search is the name of database we've created */?&gt;&lt;?php&nbsp; &nbsp; &nbsp; &nbsp; $query = $_GET['customerid']; &nbsp; &nbsp;&nbsp; $query = $_GET['username'];&nbsp; &nbsp; // gets value sent over search form&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; $min_length = 1;&nbsp; &nbsp; // you can set minimum length of the query if you want&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; if(strlen($query) &gt;= $min_length){ // if query length is more or equal minimum length then&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $query = htmlspecialchars($query); &nbsp; &nbsp; &nbsp; &nbsp; // changes characters used in html to their equivalents, for example: &lt; to &gt;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $query = mysql_real_escape_string($query);&nbsp; &nbsp; &nbsp; &nbsp; // makes sure nobody uses SQL injection&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $raw_results = mysql_query(&quot;SELECT * FROM loyalty&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE (`customerid` LIKE '%&quot;.$query.&quot;%') and (`username` LIKE '%&quot;.$username.&quot;%')&quot;) or die(mysql_error());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // * means that it selects all fields, you can also write: `id`, `title`, `text`&nbsp; &nbsp; &nbsp; &nbsp; // articles is the name of our table&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // '%$query%' is what we're looking for, % means anything, for example if $query is Hello&nbsp; &nbsp; &nbsp; &nbsp; // it will match &quot;hello&quot;, &quot;Hello man&quot;, &quot;gogohello&quot;, if you want exact match use `title`='$query'&nbsp; &nbsp; &nbsp; &nbsp; // or if you want to match just full word so &quot;gogohello&quot; is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query'&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(mysql_num_rows($raw_results) &gt; 0){ // if one or more rows are returned do following&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($results = mysql_fetch_array($raw_results)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loop&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;p&gt;Your Points Balance and Details&lt;h3&gt;&quot;.$results['name'].&quot;&lt;/h3&gt;&lt;p&gt;Points Balance -&quot;.$results['points'].&quot;&lt;p&gt;Customer ID -&quot;.$results['customerid'].&quot;&lt;/p&gt;&lt;hr&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // posts results gotten from database(title and text) you can also show id ($results['id'])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; else{ // if there is no matching rows do following&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;No results&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; else{ // if query length is less than minimum&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&quot;; &nbsp; &nbsp; }?&gt;mata ona customer id ekai username or pass word gahuwama customer ge points data base eken search karala bala ganna ..kauru hari php waddek meka balanawada</blockquote>

[QUOTE="indi8305, post: 23452830, member: 58128"] <?php mysql_connect("localhost", "lanka83_inc", "paba832205") or die("Error connecting to database: ".mysql_error()); /* localhost - it's location of the mysql server, usually localhost root - your username third is your password if connection fails it will stop loading the page and display an error */ mysql_select_db("lanka83_pnts") or die(mysql_error()); /* tutorial_search is the name of database we've created */ ?> <?php $query = $_GET['customerid']; $query = $_GET['username']; // gets value sent over search form $min_length = 1; // you can set minimum length of the query if you want if(strlen($query) >= $min_length){ // if query length is more or equal minimum length then $query = htmlspecialchars($query); // changes characters used in html to their equivalents, for example: < to > $query = mysql_real_escape_string($query); // makes sure nobody uses SQL injection $raw_results = mysql_query("SELECT * FROM loyalty WHERE (`customerid` LIKE '%".$query."%') and (`username` LIKE '%".$username."%')") or die(mysql_error()); // * means that it selects all fields, you can also write: `id`, `title`, `text` // articles is the name of our table // '%$query%' is what we're looking for, % means anything, for example if $query is Hello // it will match "hello", "Hello man", "gogohello", if you want exact match use `title`='$query' // or if you want to match just full word so "gogohello" is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query' if(mysql_num_rows($raw_results) > 0){ // if one or more rows are returned do following while($results = mysql_fetch_array($raw_results)){ // $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loop echo "Your Points Balance and Details<h3>".$results['name']."</h3>Points Balance -".$results['points']."Customer ID -".$results['customerid']."<hr>"; // posts results gotten from database(title and text) you can also show id ($results['id']) } } else{ // if there is no matching rows do following echo "No results"; } } else{ // if query length is less than minimum echo ""; } ?> mata ona customer id ekai username or pass word gahuwama customer ge points data base eken search karala bala ganna ..kauru hari php waddek meka balanawada [/QUOTE]

Verification

Asuwa dahayen wadi kalama keeyada?

Search

Latest ads

Reply to thread