(delete - update - insert) easy using the MYSQL

Discussion in 'PHP' started by astkboy2008, Jan 2, 2010.

  1. #1
    today i get simple mysql php class
    PHP class to help you connect to MySQL. It is easy to use (easier than the classic way). It is fast and it helps you if you forget to escape some strings before inserting or things like those.

    i can delete,insert,update fast
    quick view the example

    how i can use it?
    you should first start the connection
    $connection_information = array(
    	'host' => 'localhost',
    	'user' => 'root',
    	'pass' => '',
    	'db' => 'test'
    );
    $m = new mysql($connection_information);
    
    PHP:
    simple and complex query (I recommend you use the select method of the class rather than this

    
    $result = $m->query('SELECT * FROM `users`');
    var_dump($result);
    
    PHP:
    this will output an array like this: $array[$count][$table][$field]

    simple execute command (I recommend using the delete and the insert and the update methods of the
    class)
    $result = $m->execute('DELETE FROM `pages` WHERE `id`=5');
    var_dump($result);
    PHP:
    returns true if ok and false if not
    method to select (clean and beautiful)
    $result = $m->select(array(
    	'table' => 'users',
    	'condition' => 'active=1 AND type=1'
    ));
    var_dump($result);
    
    PHP:



    download
    Mbe.MySQL-1.56.zip [2.4 KB]
    or quick view
    mbe.mysql.php [3.76 KB]
     
    Last edited: Jan 2, 2010
    astkboy2008, Jan 2, 2010 IP
  2. JAY6390

    JAY6390 Peon

    Messages:
    918
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Seriously how many of these things are you going to put? Surely one of the other 9 billion classes you've posted will do this
     
    JAY6390, Jan 2, 2010 IP
  3. astkboy2008

    astkboy2008 Peon

    Messages:
    211
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #3
    yes
    thanks for saying that
    alll the class i posted make the same job
    and how any one choose the class what he will use?
    it see the usage method if he like it he wil get it
    i working on post all classes i know to help people
     
    astkboy2008, Jan 2, 2010 IP
  4. JAY6390

    JAY6390 Peon

    Messages:
    918
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    0
    #4
    No, youre just spamming links to your website. It's pathetic to be honest
     
    JAY6390, Jan 2, 2010 IP
  5. astkboy2008

    astkboy2008 Peon

    Messages:
    211
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #5
    no its not spaming
    becuase all files in the server
    how i can put the post without the download links
     
    astkboy2008, Jan 2, 2010 IP
  6. JAY6390

    JAY6390 Peon

    Messages:
    918
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Post a link to the ORIGINAL code developer, and some code on how to use it in a post on here. Why does it have to be on your website and linked to it?
     
    JAY6390, Jan 2, 2010 IP
  7. astkboy2008

    astkboy2008 Peon

    Messages:
    211
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #7
    but this class not have any original download links
    i collect it and upload
     
    astkboy2008, Jan 2, 2010 IP
  8. JAY6390

    JAY6390 Peon

    Messages:
    918
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Well you must have collected it from somewhere. It didnt just appear from nowhere
     
    JAY6390, Jan 2, 2010 IP
  9. astkboy2008

    astkboy2008 Peon

    Messages:
    211
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #9
    ok mr.JAY6390 i want tell you an important thing this site
    the job of this site is store the scripts
    now mr nikini come
    and upload his class
    this mean i dont know the source page to get
    this mean the source page is this
    because if some one has not a site it can upload his script
    and the site made for that
     
    astkboy2008, Jan 2, 2010 IP
  10. JAY6390

    JAY6390 Peon

    Messages:
    918
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    0
    #10
    hmm, really...and amazingly another two links to your site...incredible...
     
    JAY6390, Jan 2, 2010 IP
  11. astkboy2008

    astkboy2008 Peon

    Messages:
    211
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #11
    lol
    you dont under stand
    ok tell me
    how i can add the class here?
    and tell me if some one dont have website
    how i can add the script
    form where
    he come and upload it from his pc
     
    astkboy2008, Jan 2, 2010 IP
  12. JAY6390

    JAY6390 Peon

    Messages:
    918
    Likes Received:
    31
    Best Answers:
    0
    Trophy Points:
    0
    #12
    No it's you who doesn't understand. you have the author's link in the class you've posted today
    (Ciprian Mocanu <http://www.mbe.ro> <ciprian@mbe.ro>)
    and yet you've not referenced it anywhere
    Also for your submission form do you have a field where the author can put a link to the original code/his website?
     
    JAY6390, Jan 2, 2010 IP
  13. astkboy2008

    astkboy2008 Peon

    Messages:
    211
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #13
    yes i have 2
    first in the submit script home
    he can add his original link if he like
    but if he dont like becuse he dont have its ok

    and second in the profile it appear in the profile
    but now the php programming of the profile links is bad and i will updating soon
    thanks
     
    astkboy2008, Jan 2, 2010 IP