/    Sign up×
Community /Pin to ProfileBookmark

Creating a database search using PHP + mySQL

Hi everyone,

I’m a new member here but I plan on sticking around if I find that this is an active community. I’m a front-end dev currently working on my own project and was wondering if anyone could point me in the right direction.

I’m looking to build a site that has a search box in the middle of the home page. The search box should search a database for companies, then return all the results (with images, sorting options, ratings, etc) on a NEW page in nicely formatted HTML with pagination.

My question is: what technologies would be best to create this? Everywhere I look people are using PHP and storing the data in a mySQL database.

Websites like apartments.com doesn’t seem to list your results on a PHP page, nor does Dice.com.

Thoughts?

to post a comment
PHP

5 Comments(s)

Copy linkTweet thisAlerts:
@ginerjmDec 12.2015 — How does one 'know' whether the web page produced is created by php?

As a front-end dev - what technologies/languages are you used to using?

Yes - PHP is very popular. Of course you have to know how to write sql for queries, how to write HTML and CSS to design and layout your page(s) and of course PHP or whatever "tool" you wish to use as a higher-level development tool/language. And of course - be aware of the need for security when capturing user input, when using user input in queries and keeping your sensitive code(?) away from prying/hacking eyes.
Copy linkTweet thisAlerts:
@NogDogDec 12.2015 — PHP is one of many possible server-side languages you could use, and MySQL is one of several database engines you could use. Each of the many possibilities has its advocates and detractors, and pretty much any of them can get the same jobs done more or less equally well. One thing the PHP/MySQL combo has going for it is ubiquity: almost any non-Windows-based web hosting plan you can get includes both of them as part of the base package.

As far as knowing what technology different web sites use on the server side, while seeing a URL with a file name ending in ".php" or ".asp" might be a good indicator of what they're using, file name suffixes are configurable in the web server configuration, plus URL rewriting at the web server level can call a PHP (or whatever) file behind the scenes without any evidence of it to the user.

Anyway...which technology is best for you? The one you prefer to use. Really. They all get the job done, and 99%* of the time, it's what can get the job done fastest -- which is usually the one you know best.

__________________
  • * Remember that 63.4% of all statistics are made up.
  • Copy linkTweet thisAlerts:
    @AllegedlySpiffyauthorDec 13.2015 — How does one 'know' whether the web page produced is created by php?

    As a front-end dev - what technologies/languages are you used to using?

    Yes - PHP is very popular. Of course you have to know how to write sql for queries, how to write HTML and CSS to design and layout your page(s) and of course PHP or whatever "tool" you wish to use as a higher-level development tool/language. And of course - be aware of the need for security when capturing user input, when using user input in queries and keeping your sensitive code(?) away from prying/hacking eyes.[/QUOTE]


    Thanks! I suppose I was just making a noob guess because the URL didn't display .php at the end.

    My front-end skills are up to date. I'm using HTML5, CSS3 (SASS/LESS), Bootstrap, Javascript, etc.

    I just wasn't sure what developers are using nowadays to create database search queries and display paginated results.

    Thanks for the insight!
    Copy linkTweet thisAlerts:
    @AllegedlySpiffyauthorDec 13.2015 — PHP is one of many possible server-side languages you could use, and MySQL is one of several database engines you could use. Each of the many possibilities has its advocates and detractors, and pretty much any of them can get the same jobs done more or less equally well. One thing the PHP/MySQL combo has going for it is ubiquity: almost any non-Windows-based web hosting plan you can get includes both of them as part of the base package.

    As far as knowing what technology different web sites use on the server side, while seeing a URL with a file name ending in ".php" or ".asp" might be a good indicator of what they're using, file name suffixes are configurable in the web server configuration, plus URL rewriting at the web server level can call a PHP (or whatever) file behind the scenes without any evidence of it to the user.

    Anyway...which technology is best for you? The one you prefer to use. Really. They all get the job done, and 99%* of the time, it's what can get the job done fastest -- which is usually the one you know best.[/QUOTE]


    Ah, okay that makes sense. I was just not sure about what technologies are "modern" and what are out of date since I've never really worked with backend data retrieval.

    I'll have to do some more research. Thanks for the insight!
    Copy linkTweet thisAlerts:
    @ginerjmDec 13.2015 — Still curious about "choice" of web-development languages? Google gave me this link right away:

    http://www.sitepoint.com/whats-best-programming-language-learn-2015/
    ×

    Success!

    Help @AllegedlySpiffy spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 BETA 5.18,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @AriseFacilitySolutions09,
    tipped: article
    amount: 1000 SATS,

    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,
    )...