Hi, Chris!
Thanks for a great advice--and I will do just that.
Paul
Chris Snyder wrote:
Hi Paul,You always need to escape each of the user submitted values in yourSQL, in order to prevent breakage and security vulnerabilities. Themysql_real_escape_string() function is the reco
information_schema database ...
select table_schema,table_name from information_schema.tables;
- Jon
On Oct 31, 2006, at 10:29 PM, Kurt Zimmerman wrote:
> Is there a system table you can quere to see if a
> table exists? I know there is one in SQL Server.
>
> Kurt
>
>
>
> _
Is there a system table you can quere to see if a
table exists? I know there is one in SQL Server.
Kurt
Low, Low, Low Rates! Check out Yahoo! Messenger's cheap PC-to-Phone call rates
(http://voice.yahoo.com)
Quoting csnyder <[EMAIL PROTECTED]>:
> You always need to escape each of the user submitted values in your
> SQL, in order to prevent breakage and security vulnerabilities. The
> mysql_real_escape_string() function is the recommended way to do this.
>
> function dbEsc( $value ) {
> return mysql_
Thanks, Rob!
That's exactly what I was looking for.
That should let me sail through my endeavour.
Thanks!
Paul
==
Rob Marscher wrote:
"if exists" is a sql thing. i.e. DROP TABLE tablename IF EXISTS; or CREATE TABLE tablename IF NOT EXISTS;Here's one way to check if your mysql table doesn't exi
On 10/30/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> [...]
> //Add new customer to database
> function AddNewCustomer($FirstName, $LastName, $Address,
> $City, $State, $ZipCode,
> $AreaCode, $Phone, $Email,
>
"if exists" is a sql thing. i.e. DROP TABLE tablename IF EXISTS; or
CREATE TABLE tablename IF NOT EXISTS;
Here's one way to check if your mysql table doesn't exist with php:
if (mysql_query("DESCRIBE Customer_Info") === false)
{
// create the table
}
FYI, there's a nyphp-mysql list that my
Hi, Ben!
Customer_Info is a table name.
Thanks!
===Hello Paul
=== if exists(!Customer_Info) //Here it doesn't work, error===Is 'Customer_Info' a constant?===Otherwise I dont see how this works, its not a function (), its not a variable $..I'm not ===big on OOPHP some if that is some
On Mon, 30 Oct 2006, [EMAIL PROTECTED] wrote:
> class TableInfo
>{
> function _construct()//A Constructor
>{
This isn't a propos of your question, but that ain't a constructor. You
need two leading underscores:
function __construct() {
}
---
David Mintz
http:
( $db );
$errorNum = mysql_errno( $db );
$errorStr = "error($errorStr):error
no($errorNum)"; error_log("DBAS:
MySQL $errorStr"); } return
$result;}
- Original Message -
From:
[EMAIL PROTECTED]
To: talk@lists.nyphp.org
Sent:
The overhead of a table that you may not use is about zero. Why not
just create the table and assume it's already there. That way you can
forget the test all together.
Just another crazy idea! :-)
-ed
On 10/30/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Hi, everybody!
>
> I want to
Hi, everybody!
I want to ask you all to help me out in solving my database question.
Here is what I want to accomplish:
I want to add my users, one by one, to my Mysql database via a registration form.
When a user fills out a registration form, my script should gather all the information
and add th
12 matches
Mail list logo
