Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New to the CF scene
    Join Date
    Jul 2013
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Sql tables / fields from old project

    Hello, I am trying to integrate a old project of mine. The issue is i cant remember the sql tables and there fields. I really could use some help. I have posted some snippets from where the tables should be named.
    Being that i haven't coded php in a year and i was new when i did this, I am having a difficult time figuring it out. Thank

    if(update_sql("CollarURL",array("URL"),array($new_URL),"id",1) == 1)

    $data_check = pull_data_from_sql(array("Masters",0),$fields,0,1,1,array("NameID"),array($user_id));

    $dataset = pull_data_from_sql(array("MasterSubs",0),$fields,0,12,1,array("MasterID"),array($master_id));

    $dataset = pull_data_from_sql(array("Subs",0),$fields,0,12,0,array(),array(),1,$where);

    $dataset = pull_data_from_sql(array("Names",0),$fields,0,12,0,array(),array(),1,$where);

    $data_check = pull_data_from_sql(array("Subs",0),$fields,0,1,1,array("NameID"),array($user_id));


    there are more parts but if i can figure a few out then ill have a refresher on what i need to look for to determine table and/or field.

    Side note: If anyone is feeling generous I would prefer to rewrite this project conforming around a php frame work (I use CI right now).

    If this is in the wrong section please move.

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,166
    Thanks
    75
    Thanked 4,338 Times in 4,304 Posts
    Use a MySQL tool--such as phpmyadmin--and it will show you all the database, all the tables, and all the fields in each table.

    I should note that update_sql() and pull_data_from_sql() are not standard functions, so likely you wrote those yourself (or got them from some other source). You'll have to look at their coding to figure out what they do.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #3
    New to the CF scene
    Join Date
    Jul 2013
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    The issue is i don't have the old database anymore so i have to make new tables/fields.
    Also ya the functions you mentioned are custom like a small php frame work i had used.

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,166
    Thanks
    75
    Thanked 4,338 Times in 4,304 Posts
    Wish you luck. If you don't remember how that framework code works, and you don't have the DB any more, I'd guess you'd do well to just throw it all away and start over.

    If you were new when you were doing it, chances are it's not really worth salvaging, anyway.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • Users who have thanked Old Pedant for this post:

    tommy2toe (07-09-2013)

  • #5
    New to the CF scene
    Join Date
    Jul 2013
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Old Pedant View Post
    Wish you luck. If you don't remember how that framework code works, and you don't have the DB any more, I'd guess you'd do well to just throw it all away and start over.

    If you were new when you were doing it, chances are it's not really worth salvaging, anyway.
    You know what i think your absolutely right. And that is probably best. I think i will look for someone that is willing to teach me along the way to. I need a Jedi lol.
    Thank you for your input probably saved me a huge headache.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •