4
votes
1answer
56 views

Code Reiview for an PHP PDO Queries? is there a better way to do it?

so this is my code for a equipping an item in my game dev't: try { $db = getConnection(); $db->beginTransaction(); $sql_chara_gold = $db->query("SELECT chara_gold ...
1
vote
2answers
33 views

PHP PDO mysql multiple queries mak

I ran into a problem, I'm using MyIsam tables in mysql database, using PDO to connect. In all my tests (calling for 1 user everything works fine), now having around 300 users connected at the same ...
0
votes
1answer
53 views

Something wrong with this code? [closed]

Hey been at this for a day can't fix the problem. This function updates user info in the db [MySQL] it keeps throwing the exception Couldn't update user <?php function update_user($user_id, ...
1
vote
2answers
80 views

Assist cleaning up messy HTML/PHP code

I really hate messy code, but I seem to be rolling in it. I just want to see if anyone has some helpful advice on how to tidy this up. <table> <tbody> <tr> <th>Zona</th> ...
4
votes
1answer
63 views

Create a table from MySQL using PHP PDO

I am trying to simply present a table in HTML that is stored in a MySQL database. I would like to use Object Oriented PHP to access and fetch the data for the table. I have spent some time learning ...
4
votes
1answer
49 views

Thoughts on organizing code for multiple mysql queries in php scripts

I have a web application where I connect with a MySQL database using PDO and in some scripts there are a lot of queries one after the other which don't necessarily concern the same tables. i.e I will ...
2
votes
2answers
78 views

PDO database class review

I've taken this class and made it my own but I'm curious to know what other think of it? Are there things I'm missing? Anything you can recommend? class Database { private $host = ''; private ...
11
votes
3answers
2k views

PHP PDO Database Abstraction Layer

I'd like to get some feedback on a PHP Database Abstraction Layer I've created. It's a little long, but there really wasn't a way to just post part of it. Here is the base DBObject class for MySQL: ...
3
votes
2answers
232 views

Review my PHP login and register script, and profile page, and how to improve them

There are some things that I know that need to be fixed, such as mysql_* needing to be converted to PDO, and using a better hash. I am working on building a social networking site, and I've been ...
2
votes
1answer
85 views

How secure is this PDO Portfolio Script?

I was wondering if someone could take some time to look over my portfolio script and see let me know if it's secure enough to be uploaded live and connected to my database. My previous mySQL script ...
3
votes
1answer
67 views

Converting from MySQLi to PDO account activation

I had been working on a project for some time, and then it went on the way back burner after my daughter was born. I'm back to it, and now I discover that I'm best off using PDO over MySQLi. So, I'm ...
4
votes
1answer
183 views

PHP Extending PDO Class

I am trying to convert myself from using mysql extension to using PDO, with that being said I was curious if I am going about this the right way. I have a custom logging system that I built I am ...
1
vote
2answers
265 views

Basic user registration code in PHP: Part 2

Edit1: Edited in response to Corbin's feedback This is an update of my user registration code. This is continuation and implementation of feedback found in this thread: Previous codereview post. I ...
0
votes
2answers
73 views

PHP PDO Custom class ple

i created a database class from a good tutorial and wanted to put it up here so it would get in some search results. it took me about 2 days to find it. also i added a few custom functions to it.. ...
3
votes
2answers
157 views

PHP PDO Factory Classes

So, my question is more of a 'best practices' question rather than a question with a particular aim. This is my current understanding of PHP factories and how to incorporate them into a project using ...

1 2 3 4
15 30 50 per page