SEOClerks

Clear
Sign In Join

Need Simple PHP Code to Search a Data from MY SQL

Need Simple PHP Code to Search a Data from MY SQL

I have a MySQL Database with theses five columns

1. Unique ID
2. Name
3. Exam
4. Score
5. Global Rank
6. Remarks

I want a PHP code where I will input unique ID and press ok then it will search the database and show the details like this in simple way


Unique ID : XTY123
Name :Name of the user from the database
Exam :Exam name
Score :Score in Number
Global Rank :Global rank in Number
Remarks : Remarks any







else it will show " No ID Found "

That's all

Requirements

You must have the knowledge of php and mysql and html

You can copy the code anywhere from internet , but give me the desired output

Skills Required

php html mysQl

Bids

PHP Work i will give in just short time $4

hello , i have vast experience in php and mysqli i can make your this simple code in just short time

  • Media
    noumanali360 Level 2
    • order now!

    write php script for search from database $4

    respected client,

    i am a professional web developer ( laravel expert). i have vast experience using html5, css3, bootstrap, javascript, jquery, php, vue js, node js ,wordpress and laravel . i’ve worked on so many website like blog ,newspaper ,erp, betting,personal , travel , and other before, and from my experience, i can do your job succe

  • Media
    nahid2hassan Level 1
    • order now!

    I will provide the PHP/MYSQL search query $4

    hello, i have read through your request and i will provide the php/mysql search query in less than 30 min.

  • Media
    HoneyTee Level 1
    • order now!

    I will give you 200 YouTu ... Likes nondrop guarantee $1

    100% nondrop guarantee
    fast delivery as soon as possible.
    professional service
    money back guarantee

  • Media
    Blackfighter2 Level 1
    • order now!

    I am web developer. You c ... feel free to place order. $5

    i can do this task dear feel free to place order for me. can you please share your website link. i am web developer

  • Media
    desingbyafzal Level 3
    • order now!

    I can make PHP Code to Se ... Data from MySQL Database $12

    i can make php code to search a data from mysql database system. i can fulfill your requirements with best service. i think you know better about me and my service. i waiting for your response.

    best regards,
    itmaster

  • Media
    itmaster Level 3
    • order now!

    I have the Php code I can ... show you demo as example. $5

    you can see the example of the pup code and then you confirm me for your requirements. i sure you will get 100% satisfaction

  • Media
    techbizon Level 1
    • order now!
    Bid On Listing Created 6 years ago in Programming

    Other jobs by nadiaonline

    • Top Sellers

    New Services

    Top Services

    Order Now
    Process Time: 0.18231201171875

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    		/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

    SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='72316' AND A.category=B.CATID AND A.USERID=C.USERID1SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating, C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='72316' AND A.category=B.CATID AND A.USERID=C.USERID

    		/opt/clerks-staging/docroot/viewwant.php 163 () ()

    SELECT * FROM seoclerks.members_recommendations WHERE USERID=488757 AND status=1 ORDER BY MRID DESC limit 11SELECT recommendation_text, FROMID, time_added FROM seoclerks.members_recommendations WHERE USERID=488757 AND status=1 ORDER BY MRID DESC limit 1

    		/opt/clerks-staging/docroot/include/functions/main.php 21955 getLastRecommendation() ()

    SELECT * FROM seoclerks.members WHERE USERID='812751'1SELECT username FROM seoclerks.members WHERE USERID='812751'

    		/opt/clerks-staging/docroot/include/functions/main.php 1577 insert_get_username_from_userid() ()

    SELECT * FROM ratings_buyer WHERE USERID=4887571SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=488757

    		/opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()

    SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 72316 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%php html mysQl%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 72316 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%php html mysQl%' ) LIMIT 4

    		/opt/clerks-staging/docroot/viewwant.php 551 () ()

    SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 72316 AND A.category=B.CATID AND A.active=1 AND A.USERID=488757 LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 72316 AND A.category=B.CATID AND A.active=1 AND A.USERID=488757 LIMIT 4

    		/opt/clerks-staging/docroot/viewwant.php 568 () ()

    SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='72316' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc1SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture FROM wantcomments a, seoclerks.members b WHERE a.PID='72316' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc

    		/opt/clerks-staging/docroot/viewwant.php 835 () ()

    UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='72316'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='72316'

    		/opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() ()

    SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='72316' ORDER BY w.bidid ASC 1SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='72316' ORDER BY w.bidid ASC

    		/opt/clerks-staging/docroot/viewwant.php 1192 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=7678311SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=767831

    		/opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=5219621SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=521962

    		/opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=8030761SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=803076

    		/opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=7245601SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=724560

    		/opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=8734521SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=873452

    		/opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=8879611SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=887961

    		/opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=9228191SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=922819

    		/opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM categories_wanttobuy1SELECT * FROM categories_wanttobuy

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    SELECT * FROM posts WHERE USERID=4887571SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=488757

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()

    SELECT * FROM categories1SELECT * FROM categories

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * from categories_software order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

    select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

    select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

    SELECT * FROM seoclerks.members WHERE USERID='767831'1SELECT profilepicture FROM seoclerks.members WHERE USERID='767831'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='521962'1SELECT profilepicture FROM seoclerks.members WHERE USERID='521962'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='803076'1SELECT profilepicture FROM seoclerks.members WHERE USERID='803076'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='724560'1SELECT profilepicture FROM seoclerks.members WHERE USERID='724560'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='873452'1SELECT profilepicture FROM seoclerks.members WHERE USERID='873452'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='887961'1SELECT profilepicture FROM seoclerks.members WHERE USERID='887961'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='922819'1SELECT profilepicture FROM seoclerks.members WHERE USERID='922819'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='488757'1SELECT profile_data FROM seoclerks.members WHERE USERID='488757'

    		/opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.1083471SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 72316 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%php html mysQl%' ) LIMIT 40.1083470.108347