Re^4: MySQL Table adding with Perl

If you use the following to connect to the database, DBI will tell you more about where things (maybe) go wrong:

my $connect = DBI->connect(
    "dbi:mysql:database=Champ;host=localhost", 'root','pass',
    { RaiseError => 1 },
);
[download]

This saves you adding the error checking in every situation.

A bit more advice - I like to read passwords from a separate file, or from %ENV or anywhere else. That way, I can't inadverently post the database password when posting (or printing) my script.

Comment on Re^4: MySQL Table adding with Perl Select or Download Code

Replies are listed 'Best First'.
Re^5: MySQL Table adding with Perl by Anonymous Monk on Mar 06, 2013 at 21:17 UTC
Unfortunately with the addition of that line, there was no output. The scripts runs without error. Thanks Corion for the advice about the passwords, I will definitely keep that in mind.	[reply]
Re^6: MySQL Table adding with Perl by Corion (Patriarch) on Mar 06, 2013 at 21:22 UTC
Your code cannot run at all: `$maketable = ("CREATE TABLE $newuser (A,B,C,D,E)");` [download] This is not valid SQL (except maybe in SQLite). But that doesn't matter because you never run that statement. `$sth = execute();` [download] This should never work. You need to call the `->execute()` method on your statement handle. Unless you also have defined (but not shown to us) a subroutine with the name `execute`.	[reply] [d/l] [select]
Re^7: MySQL Table adding with Perl by Anonymous Monk on Mar 06, 2013 at 21:27 UTC
After the change it is responding with errors. Sorry, beginner Perl programmer mistake. Thanks for the answer!	[reply]

• hippo

‥ epoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!

• erzuuli

‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.


Clear questions and runnable code get the best and fastest answer
	PerlMonks