Please Help My Terrible Mind....

Peredy

Hello again. I cant seem to find the answer to this or find what I need anywhere. My brain just doesnt want to register in I guess... If someone could have a look at this: http://pastebin.com/330111 The page that the script is on has an error that says: Could not do a mysql query. Reason why: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''database','localhost','username','password') values Any help is greatly appreciated.

If you dont want to see the script there, it is below with the html that is in it too.

<?php 
if (isset($_POST['submit'])) 
{ 
$getdbname=$_POST['dbname']; 
$getdbhost=$_POST['dbhost']; 
$getdbuser=$_POST['dbuser']; 
$getdbpswd=$_POST['dbpswd']; 
}



if(!empty($getdbname) && !empty($getdbhost)&& !empty($getdbuser) && !empty($getdbpswd) ) {
echo $getdbname."<br>".$getdbhost."<br>".$getdbuser."<br>".$getdbpswd ;

$query = "insert into schedule (`$getdbname`, `$getdbhost`, `$getdbuser`, `$getdbpswd`) values ('$dbname', '$dbhost', '$dbuser', '$dbpswd')"; 

$db = mysql_connect($dbhost,$dbuser,$dbpswd) 
or die("could not connect to MySQL server!"); 
mysql_select_db($dbname) 
or die("Something went wrong. Please check to see if you have the correct information."); 
$result = mysql_query($query)or die("Could not do a mysql query. Reason why: ".mysql_error());
echo "<meta http-equiv=\"refresh\" content=\"0; URL=installcomplete.htm\">";
if(!$query){echo "something screwed up! try again"; }




mysql_close(); 






}



?>

Here is the html that is at the top of the page:

<html>
<head>
<title>Band Schedule Install</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<style type="text/css"> 
BODY          {scrollbar-face-color: #020302; scrollbar-shadow-color: #020202; scrollbar-highlight-color: #000000; 
                scrollbar-3dlight-color: #333333; scrollbar-darkshadow-color: #020202; scrollbar-track-color: #333333; 
                scrollbar-arrow-color: #660000}
</style>
<body bgcolor="#000000" text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"><body> 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td height="36"> 
      <table width="100%" border="0" background="images/headerback.gif" cellspacing="0" cellpadding="0">
        <tr> 
          <td height="60" width="6%">&nbsp;</td>
          <td height="60" width="94%"> 
            <div align="center"><font face="Arial, Helvetica, sans-serif"><b><font color="#CCCC00">Concert 
              Schedule V: 1.2</font></b></font></div>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td height="2"><font color="#CCCC00" face="Arial, Helvetica, sans-serif">Database 
      connection setup<br>
      <font color="#000000">. </font></font></td>
  </tr>
  <tr> 
    <td height="2"> 
      <div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="#CCCCCC"><b><font color="#DFDFDF">Next 
        we need to set up connection to the database. Enter the information below 
        and click on enter.</font></b></font></div>
    </td>
  </tr>
</table>
<form action="" method="post">
  <table width="70%" border="1" align="center" bordercolorlight="#333333" bordercolordark="#666666">
    <tr> 
      <td width="39%"><font size="2" face="Arial, Helvetica, sans-serif"><b>Name 
        of Database:</b><br>
        <font color="#CCCCCC">(Ex: mydomain_database Seen when setting up)</font></font></td>
      <td width="31%"> 
        <input type="text" name="dbname" size="" value="" />
      </td>
      <td width="30%">&nbsp;</td>
    </tr>
    <tr> 
      <td width="39%"><font size="2" face="Arial, Helvetica, sans-serif"><b>Name 
        of Database Host:</b><br>
        <font color="#CCCCCC">(Almost always: localhost if not then erase and 
        replace it)</font></font></td>
      <td width="31%"> 
        <input type="text" name="dbhost" size="" value="localhost" />
      </td>
      <td width="30%">&nbsp;</td>
    </tr>
    <tr> 
      <td width="39%"><font size="2" face="Arial, Helvetica, sans-serif"><b>User 
        Name: </b><br>
        <font color="#CCCCCC">(Typically the name you gave when setting up the 
        database)</font></font></td>
      <td width="31%"> 
        <input type="text" name="dbuser" size="" value="" />
      </td>
      <td width="30%">&nbsp;</td>
    </tr>
    <tr> 
      <td width="39%"><font size="2" face="Arial, Helvetica, sans-serif"><b>Password: 
        </b><br>
        <font color="#CCCCCC">(Typically the password you gave when setting up 
        the database) </font></font></td>
      <td width="31%"> 
        <input type="text" name="dbpswd" size="" />
      </td>
      <td width="30%"> 
        <div align="center">
          <input type="submit" name="submit" value="Enter" />
        </div>
      </td>
    </tr>
  </table>
  </form> 
</body>
</html>

The objective is to have the form do two things... To connect to the database, and also enter the information that is used to connect to it to certain fields of the database table. The table is already installed.

Much appreciation for any help. I know this seems a repeat, but I have got a little further in it.

Peredy

leatherback

Have you echoed the query?

Also..
this line:

'$dbname','$dbhost','$dbuser','$dbpswd'

serves no purpose

toplay

You got to make sure that you specify the right number of column names with the right number of values. Use backtick marks around the column names and not single quotes.

Change this:

$query = "insert into schedule ('$getdbname','$getdbhost','$getdbuser','$getdbpswd') values (NULL,'$dbname','$dbhost','$dbuser','$dbpswd',NULL)";

To this:

$query = "insert into schedule ($getdbname, $getdbhost, $getdbuser, $getdbpswd) values ('$dbname', '$dbhost', '$dbuser', '$dbpswd')";

Delete this:
'$dbname','$dbhost','$dbuser','$dbpswd'

Peredy

That seemed to fix that problem, now I have a new one... I get this error:

Could not do a mysql query. Reason why: Unknown column 'blysterc_stcontest' in 'field list'

blysterc_stcontest is the name of the database I specify in the form.

It is supposed to read the database from the form and enter it in the correct field as info... dbname

Massive appreciation for all the help I get!

Peredy

leatherback

Well, you have it in the wroong place then.

And I repeat my TWO comments I have regarding this script:

Do you sincerely think you are the right person to create an interface so people who know no PhP can maintain their website (As you posted in a previous thread with similar problems)
Did you echo the query

Peredy

Well, the reason I am making this is because it's realy targeted for bands and entertainers. We have on our site a real good schedular, but everyone else started wanting it. Trouble is I dont know how to make an installer (I dont have the time to manually set all of it up for everyone), so it is a real slow process. No, I wont say that I am the perfect one for this, but I am the free and available one.... or at least the one they know. They will have to know how to at least set up the database. I have the table installer and what not, but if they cant do that I cant help them.

As far as your other question.... I have no idea what you mean. I am going to adit what I now have in the post above so you can see what I have now.

Peredy

leatherback

What I mean is:

echo $query;

so you SEE what is being passed to the script.

ok. Maybe I am a bit curt on my opinion on creatiung this. It is just that I see too many people geting in over their heads. I get people sending me PM on how to do pagination, useronlinedb, shoppingcarts, this and that, and when you ask them to create a table in the database, they ask "How do I create a table?". So every once in a while i get a bit disappointed in the amount of people expecting to come to a forum,a nd have their code created, while they take no effort. So, please.. See it in that light. And remain realistic about the can / cannot's of skills.

Back to your problem.

If you have problems with a query, it is <stress>always</stress> a good idea to echo the querystring. 9 out of 10 times you will see the problem straight away.

Another thing I like to to, is structure the query when they become longer / don't function as I expecvt:

insert into table
                 (field1, field2, field3)
values ('$field1', '$field2', '$field3') where somecondition

this give you better insight in which variable is inserted in which field.

Hope it helps.

toplay

Peredy wrote:
Could not do a mysql query. Reason why: Unknown column 'blysterc_stcontest' in 'field list'

You're taking the input values from the form and using them as the values but also for column names. This part:

$getdbname=$POST['dbname'];
$getdbhost=$POST['dbhost'];
$getdbuser=$POST['dbuser'];
$getdbpswd=$POST['dbpswd'];

Those are used as column names. So, you had better have a table with those column names that were entered. If not, you'll have to create the table first before trying to insert. The error message is basically saying that there is no column by that name in the table you're trying to insert into.

Of course I doubt that's what you meant to do. The table schedule already has predefined column names. So, use those predefined column names in the insert all the time, and use the values from the form to insert the data. Something like so:

$query = "insert into schedule (column_for_dbname, column_for_dbhost, column_for_dbuser, column_for_pswd) values ('$dbname', '$dbhost', '$dbuser', '$dbpswd')";

hth.

Peredy

The column names for those in the table "schedule" are: dbuser, dbname, dbpswd, dbhost

The table is already set up and installed.

Okay, yes I have the echo. It shows up on the page after submitted. I have I think what you have escept the WHERE part. I wouldnt know what to do there.

On your point.. believe me I understand. Up to this point I have had given alot of advice on other things besides PHP. Unfortunately I am the only one that could even get a head start of the people that know know that requested it. Thats why I'm giving it way and giving vredits in the script budle so that people know I am not the only one that did this. Believe me, I am looking for a fix, and it would be fantastic to copy and paste them, but I dont believe that I an come up with it on my own, although I have learned quite a bit with the posts and answers to my problem.

Now the thing I am still getting is it thinks I am sking it to put in a field calle dthe database when it is info that I want added.

if you go to: http://www.blyster.com/bschedule/bsadmin/connectionsettings.php And put in the following:

blysterc_stcontest
localhost
blysterc
password

then hit enter, you can see what I mean. The info for those form fields are supposed to conect to the database and also add those entries to the database table fields: dbhost, bdname, dbuser, dbpswd (not necessaril in that order in the table).

There are other fields in the table, but I only want those fields entered because with the last step of the bundle, the settings.pgp page (which is what all the pages call to to get the connection to the database info) will read those entries filled out by this form so that they dont have to edit a php page.

If you want to see what I have that people want to install on their site... go to: http://www.blyster.com/bschedule/index.php and check it out.

Hope this will give some insight on what is going on in case anyone is getting frusterated with me if I am unclear.

Many many thanks for all the help I can get.

Peredy

leatherback

The info for those form fields are supposed to conect to the database and also add those entries to the database table fields: dbhost, bdname, dbuser, dbpswd (not necessaril in that order in the table).

THis is not logical. You want to connect to the database with YOUR settings, and use them to insert into the table, right?

Anyway.. Maybe it is time to see what your last code looks like, and get an idea of the specific problem you have now.

Peredy

okay, I know I am vague with my intensions. Many appologies. What I am trying to do is this...

1- have the form in which they fill out to connect to the database (Already installed by a previous step in the installation)

2- have the information they entered in this form entered in the 4 fields of the table in the database

3- have the settings.php page read those entries for the connection so they can use the schedule bundle.

I am using my information to test all this. But it's not entering it in the database.

See, the form on the page has to do two roles, the first is to connect to the database, and the second is to take that connection info and enter it in the database so it can be called back to for the schedule bundle.

Peredy

toplay

Peredy wrote:
The column names for those in the table "schedule" are: dbuser, dbname, dbpswd, dbhost

Then use:

$query = "insert into schedule (dbname, dbhost, dbuser, dbpswd) values ('$dbname', '$dbhost', '$dbuser', '$dbpswd')";

leatherback

But HOW can you connect to the database with settings which were just created by the user? For YOUR database you need to use YOUR settings.

Peredy

TOPLAY got the right one. Many thanks o wise one.

Leatherback.... there is another page the user goes to before this. The page installs a table with all those fields in it. I am using MY settings cause I am testing it on my site. When they use it, it will be their settings.

Many thanks and appreciation to both of you.

Peredy

toplay

From what I understand Peredy, you need a place to store other users database settings. I don't know why you're trying to do that to a table called "schedule".

Create a table and call it something like db_connections or user_db_connections or anything meaningful. There would be one row per user. You can use the HTML form to populate this table with.

Create the schedule table using the DB settings specific for that user.

EDIT:

OK, I just read your last post.

Peredy

Your exactly right! What is wrong though is I managed to figure out how to install one table in the database, but not two with one php page. I'll ahve to try that out after my bands concert tonight.

Peredy

toplay

Peredy wrote:
Your exactly right! What is wrong though is I managed to figure out how to install one table in the database, but not two with one php page. I'll ahve to try that out after my bands concert tonight.

Peredy

Since you're using different user settings to connect to MySQL, you will have to close the connection each time (mysql_close), and then reconnect with the next users DB settings (using mysql_connect and mysql_select_db).

Peredy

That worked. I guess the last step is getting the settings page to read the conection info in the database. Thats gona take some digging. Thanks for the help. It's massively appreciated.

Peredy