13 {{ upvoteCount | shortNum }}
13 {{ upvoteCount | shortNum }}

Do I need to use SQL in order to save time?

by goonie
11 replies
I created some landing page template in which I test various products.
currently it is a .php file which I manually change each time, along with 3 other files, plus an image, and then upload all of them to my ftp, and edit the .htaccess file to beautfy the links.

It is pretty inefficient, as it wastes too much time and I guess there's a way to automate this.

basically I need a way just to update the product's price, product name, product image, products description, page title; update links in the related other 3 files; and update the .htaccess file according to the cannonical url which I choose on the product page.

Someone told me that I can use SQL in order to achieve that, is that correct?
I have 0 knowledge in SQL. he told me I can either used some designated system to update these files, or rather use something called DB.

Is this the way to go? should I try to learn it myself? from where?
or where and for how much can I hire someone to do that?

Thanks
#order #save #sql #time
  • Profile picture of the author Member8200
    Hi,

    Yes, creating a DB(Database) for your landing page information will definitely save you time.
    since your landing page was created using a PHP, and a bit of database can help you provide more efficiency on updating your landing page.

    Plus, you can store the previous information on your landing page that was saved on your database and use it anytime you want in just a click of a button.
    {{ DiscussionBoard.errors[9835046].message }}
  • Profile picture of the author goonie
    Where can I learn what to do then step by step? how does this database looks like? what program is used to edit it? what do I do on my server? does the DB sits on my server and I update it there, or does it sit on my computer and I sync it with the server everytime I want to update?
    {{ DiscussionBoard.errors[9835416].message }}
  • Profile picture of the author geekSoftware
    There is just too much of things that really you will spent much more time learning all of that than you will spent by changing manually that. With that said, I guess it's much easier to hire some coder who will do that for you really fast.

    But, if you want to do it yourself, than you have to learn PHP + MySQLi+SQL Language, PHP+HTML forms and PHP sessions. Here I just told you parts of PHP language so that you don't have to learn everything. With all previous said you can create small cpanel system for what you need and you can with few click in future add new products, remove products, change prices etc.

    If you need experienced coder you can contact me on PM, we can make a deal and I will make everything for you.
    {{ DiscussionBoard.errors[9835611].message }}
    • Profile picture of the author mikea12
      I would use sqllite3, this is a minimal way for saving data like this.

      You just need to pick whether you want to use node.js or php.
      {{ DiscussionBoard.errors[9838231].message }}
  • Profile picture of the author Devlin5
    Banned
    yes using MySQL is more efficient ans secure way to manage data in database. You need to keep the record of all your product and update it every time. So using MySQL is better idea.
    {{ DiscussionBoard.errors[9839371].message }}
  • Profile picture of the author goonie
    I have zero technical knowledge so just saying "yes that is what you need" is not very helpful.
    Where do I Start from?

    What I imagine is to have some excel sheet, to which everytime I Can add a new line, with another product name, price, htaccess value,image src, etc, and it would generate a new file instantly.

    Where can I find INFORMATION on How to achieve this - step by step?
    {{ DiscussionBoard.errors[9839965].message }}
    • Profile picture of the author clumsy
      Originally Posted by goonie View Post

      I have zero technical knowledge so just saying "yes that is what you need" is not very helpful.
      Where do I Start from?

      What I imagine is to have some excel sheet, to which everytime I Can add a new line, with another product name, price, htaccess value,image src, etc, and it would generate a new file instantly.

      Where can I find INFORMATION on How to achieve this - step by step?
      geekSoftware already pointed you in the right direction. You will not find a step by step tutorial showing you exactly what you need to do.
      Read up on what PHP is and learn the basics. Read up on what SQL is and learn the basics. Read up on what PHP + MySQL is and learn the basics.

      From what you are saying it will probably take you 3 or 4 weeks few hours a day to achieve what you are trying to do yourself.
      Unless you are actually trying to learn software development then as geekSoftware said, just hire a developer who can do it for you.

      Edit: Google is your friend.
      Signature
      //Check out these funny source code comments
      {{ DiscussionBoard.errors[9849177].message }}
      • Profile picture of the author rmcnew
        Its as simple as this:

        Code:
          = "CREATE TABLE IF NOT EXISTS `storage` (
  `name` varchar(99) NOT NULL,
  `price` varchar(99) NOT NULL,
  `htaccess value` varchar(99) NOT NULL,
  `image src` varchar(99) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

  = "INSERT INTO `storage` (`name` ,`price` ,`htaccess value` ,`image  src`) VALUES ('picture', 'free', 'htaccess_value', 'source.jpg');";

mysql_query();
mysql_query();
        {{ DiscussionBoard.errors[9849206].message }}
  • Profile picture of the author katty5005
    Yes, MySQL is better platform to store data and manage database since you may need those data in near future.
    {{ DiscussionBoard.errors[9849737].message }}
  • Profile picture of the author Tradeout
    Updating a database to dynamically change your page would be the preferred way to speed up the process.

    Giving the exact solution to your setup isn't easy without seeing it first. Why not show is your page so we can see exactly what you are doing, then you may get some more responses in 'how' to do what you need.

    The basics would be:
    Store dynamic details in table
    On page load call DB and append details to the page

    I would also create a quick admin page to update the DB tables.


    After this is setup you can then expand further and add some A/B split testing using 2 datasets in the database.
    Your imagination is the only limitation.
    {{ DiscussionBoard.errors[9850258].message }}
  • Profile picture of the author datastyling
    If you think your website doesn't require heavy contents and it's not too much static you could do it by using file handling instead of database. Other idea is you can include php files where you name it specific base on content you will put on a file.

    There are so many other way on that.
    Signature

    BOOK DESIGN & LAYOUT / WEB DEVELOPMENT
    WEBSITE: www.datastyling.com (book design & layout - $95 only) www.thorhosting.co (hosting with free fully functional website) www.infoph.com (open internet directory, jobs, classifieds & news)
    SKYPE: datastyling
    FACEBOOK: https://www.facebook.com/bookdesignservices

    {{ DiscussionBoard.errors[9856981].message }}

Trending Topics