Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 8 of 8
  1. #1
    Junior Member estes53's Avatar
    Join Date
    May 2007
    Location
    Colombia
    Posts
    7
    Member #
    15258
    The following was posted here earlier-

    "phpMyAdmin ... It can even translate from php to sql and sql to php!"

    I was hoping this meant converting sql to php code, but have been all over phpMyAdmin and can find nothing that seems to be related to that or to the statement above.

    Can anyone clarify or make a suggestion about automatic sql to php code options.

    Thanx, Alan

  2.  

  3. #2
    Senior Member Steax's Avatar
    Join Date
    Dec 2006
    Location
    Bandung, Indonesia
    Posts
    1,207
    Member #
    14572
    SQL to PHP? Well, perhaps it meant that phpmyadmin can turn a database to its raw "constructing" queries. SQL and PHP are totally different languages and can't exactly be transfered like that...
    Note on code: If I give code, please note that it is simply sample code to demonstrate an effect. It is not meant to be used as-is; that is the programmer's job. I am not responsible to give you support or be held liable for anything that happens when using my code.

  4. #3
    Junior Member estes53's Avatar
    Join Date
    May 2007
    Location
    Colombia
    Posts
    7
    Member #
    15258
    Found this commercial software which seems to be what I might need.

    MSSQL2MySQL Pro
    is a reliable bi-directional database migration tool which allows you to convert from ...MySQL to PHP Script

    Anyone used it and have a comment.

    Alan

  5. #4
    Senior Member leprechaun13's Avatar
    Join Date
    May 2005
    Location
    Northampton
    Posts
    487
    Member #
    10058
    not sure but i think all that will do is take an SQL query and gice you the PHP to run that query
    Regards Phil,


  6. #5
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    And if you need a tool to do that, you shouldn't be writing code. Ever.
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  7. #6
    Senior Member leprechaun13's Avatar
    Join Date
    May 2005
    Location
    Northampton
    Posts
    487
    Member #
    10058
    I wouldnt say ever but what I think he is trying to get at is when you run a query for insance
    Code:
    <span class="syntax">SELECT  * 
    FROM  `sometable` 
    LIMIT 0 , <span class="syntax_digit syntax_digit_integer">30
    it give you a link called "CREATE PHP CODE" whcih gives you
    PHP Code:
        $sql  'SELECT * FROM `sometable`   LIMIT 0, 30 '
    Regards Phil,


  8. #7
    ljm
    ljm is offline
    Senior Member ljm's Avatar
    Join Date
    Aug 2006
    Location
    Manchester, England
    Posts
    284
    Member #
    13684
    Liked
    1 times
    All that is is the same SQL, but put inside a PHP variable. No difference. You can't convert SQL to PHP because they're not the same. You can use PHP along with SQL to communicate with a database though, which is what phpMyAdmin does; it's just an interface after all.

  9. #8
    Senior Member Steax's Avatar
    Join Date
    Dec 2006
    Location
    Bandung, Indonesia
    Posts
    1,207
    Member #
    14572
    "MSSQL2MySQL Pro" Sounds more like converting between MSSQL and MySQL, two different database types.

    There's just no such thing as "MySQL to PHP script!" PHP has to talk to databases via SQL, there's no other way.
    Note on code: If I give code, please note that it is simply sample code to demonstrate an effect. It is not meant to be used as-is; that is the programmer's job. I am not responsible to give you support or be held liable for anything that happens when using my code.


Remove Ads

Posting Permissions

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

Search tags for this page

www

Click on a term to search for related topics.
All times are GMT -6. The time now is 06:03 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com