1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

php mysql to php mysqli

Discussion in 'PHP' started by xbat, Sep 29, 2013.

  1. #1
    I'm looking to sharpen my mysqli skills... Anyone have any suggestions on sites videos ?? I know php mysql somewhat well but I want to improve my skills to php mysqli. I guess I am looking for a site that will more likely closely relate one another maybe or a better type of a break down.
    Solved! View solution.
    xbat, Sep 29, 2013 IP
  2. xbat

    xbat Member

    Messages:
    193
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #3
    I have been up and down php.net a bunch of times. The af-design.com is something what I was looking for. Thank you
    xbat, Oct 7, 2013 IP
  3. sabato

    sabato Member

    Messages:
    410
    Likes Received:
    6
    Best Answers:
    1
    Trophy Points:
    43
    #4
    I would go for PDO if i was you.
    sabato, Oct 8, 2013 IP
  4. Strider64

    Strider64 Member

    Messages:
    40
    Likes Received:
    13
    Best Answers:
    1
    Trophy Points:
    25
    #5
    I started out with mysqli, but switched over to PDO. Start with PDO is the best option, unless you know that you will never use any other kind of database. PDO prepared statements are also nicer, you don't have remember the number of ???? placeholders, which can be annoying if you have many.
    Strider64, Oct 8, 2013 IP
    ryan_uk and HolyRoller like this.
  5. xbat

    xbat Member

    Messages:
    193
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #6
    yea thats been the big thing.. However with everything I have never ran into over the years there has been very few times where I would have need pdo maybe once but then we ended up switching back.. How often have you guys have it popup where you had to switch the database type?
    Last edited: Oct 8, 2013
    xbat, Oct 8, 2013 IP
  6. sabato

    sabato Member

    Messages:
    410
    Likes Received:
    6
    Best Answers:
    1
    Trophy Points:
    43
    #7
    Hi,
    I don't really understand this part. If you use mysql you can use PDO in any applications. Why would you switch? switching back what? mysqli?
    Apart from that pdo supports many other databases like :
    CUBRID (PDO)
    MS SQL Server (PDO)
    Firebird (PDO)
    IBM (PDO)
    Informix (PDO)
    MySQL (PDO)
    MS SQL Server (PDO)
    Oracle (PDO)
    ODBC and DB2 (PDO)
    PostgreSQL (PDO)
    SQLite (PDO)
    4D (PDO)
    sabato, Oct 8, 2013 IP
  7. xbat

    xbat Member

    Messages:
    193
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #8
    Sorry that was a spelling mistake. ever=never... I was saying I never really ran into the point where we had to switch databases. However we did end up switching databases. We went from mysql but then a few months later back to mysql again.. Thats all I was saying..
    xbat, Oct 8, 2013 IP
  8. ThePHPMaster

    ThePHPMaster Well-Known Member

    Messages:
    595
    Likes Received:
    30
    Best Answers:
    18
    Trophy Points:
    100
    #9
    I never ran into the issue where I had to switch from MySQL to a different SQL engine. I think that MySQL engine is by far the most efficient engine (along with Percona DB cluster, I really don't see such change).

    I do end up using memory key/value storage to make things faster on busy environments, but that is nothing something you can replace in PDO.
    ThePHPMaster, Oct 8, 2013 IP
  9. articlesdirectory

    articlesdirectory Greenhorn

    Messages:
    57
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    18
    #10
    I am also searching the same contents..Please provide me the best link that will be beneficial for learning
    articlesdirectory, Oct 8, 2013 IP
  10. nico_swd

    nico_swd Prominent Member

    Messages:
    4,119
    Likes Received:
    331
    Best Answers:
    17
    Trophy Points:
    325
  11. PoPSiCLe

    PoPSiCLe Well-Known Member

    Messages:
    1,224
    Likes Received:
    109
    Best Answers:
    51
    Trophy Points:
    160
    #12
    Seriously? MySQL-engine the most efficient engine? In some cases, yes, but that depends entirely on the amount of data, cluster-availability, types of data etc. I think you'll learn that MySQL is more of a bastard child that can do most things okay-ish, than a really good DB-engine. Albeit, with the latest releases, they've jumped ahead a few miles - problem is, hardly any hosts and environments have implemented these versions yet.
    PoPSiCLe, Oct 9, 2013 IP
  12. xbat

    xbat Member

    Messages:
    193
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #13
    thanks guys You have a website for Albeit?
    xbat, Oct 9, 2013 IP
  13. nico_swd

    nico_swd Prominent Member

    Messages:
    4,119
    Likes Received:
    331
    Best Answers:
    17
    Trophy Points:
    325
    #14
    Not sure if trolling or not.
    nico_swd, Oct 9, 2013 IP
  14. John Michael

    John Michael Banned

    Messages:
    155
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    43
    #15
    My sqli has more great then simple sql. sqli has come with new improve then the old sql. read more on www.php.net
    John Michael, Oct 10, 2013 IP
  15. ryan_uk

    ryan_uk Prominent Member

    Messages:
    3,943
    Likes Received:
    991
    Best Answers:
    33
    Trophy Points:
    365
    #16
    I like MySQL and mostly use it, so I am not an anti-MySQL person. However, depending on how you define efficient, PostgresSQL has the edge regarding efficiency.
    ryan_uk, Oct 10, 2013 IP
  16. deathshadow

    deathshadow Prominent Member

    Messages:
    5,980
    Likes Received:
    827
    Best Answers:
    144
    Trophy Points:
    395
    #17
    Or Oracle which costs a fortune, but scales up better... or msSQL which some dumbass suit writing the checks might force you to deploy on, the kick-ass leanness of sqLite with it's miniscule system requirements, etc, etc...

    Simply having the option is hard to turn down.

    Though I prefer PDO over mysqli because it doesn't have the dumbass functional fallback wrappers encouraging the use of more overhead (since they are literally just wrappers to the object version)... Well, and I prefer "lazy variables" over bindParam, particularly being able to build multiple result arrays before running multiple execs of the same query.
    deathshadow, Oct 11, 2013 IP