Is there any easy to use librart for php to work with mysql ? [Need Suggestions]

Question

i am having trouble connecting to MySQL database with php.
the queries and mysqli connection (especially this "->" ) frustrates me a lot.
it's also very tough to check for errors etc.
I am already trying MEDOO library but that too isn't working great for me.
so if you guys know any easy to use library, plz recommend me
thanks.

Answer 1

what is your new problem , tell me ,I can definitely solve it..

Answer 2

I m sorry Aman..

I am really very sorry..

Answer 3

For not solving your problem..

Answer 4

yes..it is

Answer 5

Kapil Sharma ??

btw my problem is solved now

also got new problem

Answer 6

Kapil Sharma oh really ! it's in PHP actually.
I am creating a social site (like Facebook) for my own practice of coding skills.
now I am having problem with message storing and retrieving systems.
the main problem is that if number of users is more , then on each sent message my php script will open a connection to my SQL database and query the table and store the message and close the connection. and same on message receiving too.
the problem is that the frequency of queries will be soo high that repeatedly opening and closing the MySQL connection will surely blow the server (and it's slow) .
now how can I fix that
I need a php script which can continuously run on the server and create a persistent connection to the database and at the same time being able to serve the query to other php scripts or respond to ajax upon request. this will lower the burden on server.
now how can i accomplish that ?
i am using php only in the server side also i am not good at any other server side language.

Answer 7

Kapil Sharma why ?