1
2
3
4
             #insert new record if it dosent already exist
             if !dbh.select_one('SELECT Salenm FROM Auctions Where Salenm LIKE "%' + c.attributes["href"][/....$/] + '%"')
                dbh.do("INSERT INTO Auctions (Salenm, Date, Location) VALUES (?, ?, 1)", 
...

Ruby Insert new record if it dos...

by bain19.myopenid.com, June 24, 2010 04:33, 1 refactoring, tagged with if, mysql, select, bain19, sql injection

Is there a safer way to-do ...

642d333608cc3483f64dba38cb81bdd2 Talk
1
2
3
<?php
function clean($string){ 
...

PHP Register/Login Script

by penaf.myopenid.com, March 12, 2010 23:45, 13 refactorings, tagged with login, register, mysql, php

Hello People,

This websi...

84c8afb06eeacbf350b5b42cb795f195 Talk
1
2
3
4
<?php
/**
 * Database: MySQL connection
...

PHP MySQL database class

by lukas, September 02, 2009 20:20, 5 refactorings, tagged with php, database, mysql

This is a class to do all t...

A54000a44341dc35ab30a332a49784d3 Talk
1
2
3
4
<?php

public static function addUser($username, $email, $password)
...

PHP User Registration Function

by gwrtheyrn, July 24, 2009 20:05, 3 refactorings, tagged with php, registration, user, mysql, real_escape_string

Is this user registration f...

D3bd7339e1941bc25c05110b69a82721 Talk
1
2
3
4
<?php

if (!defined('ANTIHACK'))
...

PHP php mysql wrapper begginer

by fantomel, April 03, 2009 14:33, 5 refactorings, tagged with php, mysql, mysql wrapper, wrappers, wrap, simple

Hello ppl i'm new to php\\O...

8bdcb8b82adf1dd562970b22d3458d7d Talk
1
2
3
4
<?php

abstract class mySQL // abstract => cannot be instanciated
...

PHP MySQL original PHP 5 wrappe...

by TiTi, August 01, 2008 20:44, 9 refactorings, tagged with mysql, wrapper, object, php5, static, const, student, titi

Typical MySQL wrapper writt...

1e6b9d50678a0cc32d98aa1dd1ec3846 Talk
1
2
3
4
function db_cache_2($query)
 {
  // Query cache table
...

PHP DB Cache

by ellisgl.myopenid.com, January 14, 2008 22:48, 8 refactorings, tagged with php, cache, mysql, update

It's a DB caching scheme th...

8bba46dba9043c254e6eef1aa664e6f0 Talk