Another Array & MySQL Question

_troy_drunk

After reading the Sticky message at the top of this forum, I feel even more lost. I have a project I am working on that requires PHP and MySQL, and my only experience is really with HTML, and even that's not too good. I have tried reading the PHP manual a couple of times, but I'm just not getting it.

So, what I want to do is first, find out how to create the array from information in a MySQL table. I guess that's the main problem. From there I want to put the information from the arrays I will have into the three list/menu forms (depending on which table I grab from). Then, I want the user to be able to select one of the items in the lists, and use the buttons to transfer the item to another list (and pref. not have to reload the page).

Finally, I would like to make it so when an item is selected, it does a query and puts information from another table into the textbox on the bottom right (see code).

The code I am posting is HTML cause that's basicly all I know.

<form name="form1" method="post" action="">
  <table width="898" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td width="209" scope="col"><table width="209" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="205" align="center" scope="col">Allow:</td>
        </tr>
        <tr>
          <td scope="row"><select multiple NAME = "allow_users" size="12">
</select></td>
        </tr>
      </table></td>
      <td width="275" scope="col"><p>&nbsp;</p>
        <table border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="173" align="center" scope="col">Permission Controls </td>
          </tr>
          <tr>
            <td align="center" scope="col"><input type="submit" name="moveto_allow" value="Allow User"></td>
          </tr>
          <tr>
            <td align="center" scope="row"><input type="submit" name="moveto_disallow" value="Disallow User"></td>
          </tr>
        </table>        

        <table border="1" align="center" cellpadding="0" cellspacing="0">
          <tr align="center">
            <td colspan="2" scope="col">Banning Controls </td>
          </tr>
          <tr>
            <td colspan="2" scope="col"><input type="submit" name="perm_ban" value="Perm"></td>
          </tr>
          <tr>
            <td width="49" height="26" scope="row"><input type="submit" name="temp_ban" value="Temp"></td>
            <td align="center" valign="middle" scope="col"><input name="temp_ban_days" type="text" size="5" maxlength="3">
Number of Days (999 Max) </td>
          </tr>
        </table>        </td>
      <td width="209" scope="col"><table width="209" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="205" align="center" scope="col">Disallow:</td>
        </tr>
        <tr>
          <td scope="row"><select multiple NAME = "disallow_users" size="12" >
</select></td>
        </tr>
      </table></td>
      <th width="205" scope="col"><table width="205" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="205" align="center" scope="col">Temp/Perm:</td>
        </tr>
        <tr>
          <td scope="row"><select multiple NAME = "temp_perm_users" size="12" >
</select></td>
        </tr>
      </table></th>
    </tr>
    <tr>
      <td scope="row"><table width="146" border="1" align="center" cellpadding="0" cellspacing="0">
        <tr align="center">
          <td colspan="2" scope="col">Disallow All Users </td>
          </tr>
        <tr align="center">
          <th width="45" scope="row"><input name="disallow_all_once" type="submit" value="Once"></th>
          <td width="95"><input type="submit" name="disallow_all_forever" value="From Now On"></td>
        </tr>
      </table></td>
      <td>&nbsp;</td>
      <td><table width="146" border="1" align="center" cellpadding="0" cellspacing="0">
        <tr align="center">
          <td colspan="2" scope="col">Allow All Users </td>
        </tr>
        <tr align="center">
          <th width="45" scope="row"><input name="allow_all_once" type="submit" value="Once"></th>
          <td width="95"><input type="submit" name="allow_all_forever" value="From Now On"></td>
        </tr>
      </table></td>
      <td align="center" valign="bottom">User Notes:</td>
    </tr>
  </table>
  <table width="896" border="1" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <th width="222" scope="col">&nbsp;</th>
      <th width="257" scope="col">&nbsp;</th>
      <td width="409" align="right" scope="col"><TEXTAREA NAME = "users_notes" cols="64" ROWS = "8" >
</TEXTAREA></td>
    </tr>
  </table>
  <p>&nbsp;</p>
</form>

Thanks, in advance for any help.
Drunk

kburger

PHP is a server-side language, which is perfect for querying a MySQL database and populating <select> tags. Transfering items from one multiple select box to another requires a client-side language - javascript. I'm sure there are plenty of code snippets you could look at on this board that will help you with the database query. I'd suggest googling up a search for the javascript code you'll need.

_troy_drunk

Ok, so let's see if I can figure this out... I might get it, but not understand it, which is why I came here for help.

$con = mysql_connect("localhost","usernamehere","passwordhere"); 
//Ok, I think I get this.  The variable $con is used when I want to connect to the MySQL DB.

$selectdb = mysql_select_db("user_info",$con); 
//This part I am only partially sure on.  The user_info should be the table in the My SQL DB that I am trying to get the information from, right?

$query = mysql_query("SELECT * FROM usernames");      

//Does this make the variable $query an array of all the usernams stored in the user_info table? 

while($row = mysql_fetch_array($query)){
//First of all, what is $row supposed to be?  Second, how would I echo out the statements for the script I posted earlier?

So, like I said, I just can't figure this stuff out. Thanks again for the help.
Drunk!

kburger

$con = mysql_connect("localhost","usernamehere","passwordhere"); 
//Ok, I think I get this.  The variable $con is used when I want to connect to the MySQL DB.

$selectdb = mysql_select_db("user_info",$con); 
//This part I am only partially sure on.  The user_info should be the table in the My SQL DB that I am trying to get the information from, right?

Actually, it's the database name.

$query = mysql_query("SELECT * FROM usernames");      

//Does this make the variable $query an array of all the usernams stored in the user_info table?

No, not really. $query will now be the MySQL resource that will be used to reference your query results from the table named 'usernames' in the database 'user_info'.

while($row = mysql_fetch_array($query)){
//First of all, what is $row supposed to be?  Second, how would I echo out the statements for the script I posted earlier?

$row will be a single row of the returned results from the query. I don't know what your table looks like, but it sounds like it just has one column - 'usernames'. To get each of the usernames do something like this:

while($row = mysql_fetch_array($query)){
    echo $row[0] . "<br>\n";
}

If you had multiple columns in your table they would be $row[0], $row[1], etc. You could also reference them by their name like $row["username"].

I'm sure you can probably figure out where to put this loop and what to do with it.

sapoxgn

while($row = mysql_fetch_array($query)){
    echo $row[0] . "<br>\n";
}
If you had multiple columns in your table they would be $row[0], $row[1], etc. You could also reference them by their name like $row["username"].

I'm sure you can probably figure out where to put this loop and what to do with it. [/B]

Yes that´s it, and for him to understand this is simple 😃

try this out:

$row = mysql_fetch_array($query));

$rows_count = count($rows);
// count the number of rows in your array

for ($i = 0; $i <= $rows_count; $i++) {
	echo $rows[$i] . '<br>';
}
// this will print the contents of all rows ^^

just try it outr

this makes the same 😛

while($row = mysql_fetch_array($query))

I m sure you will understand😉

laserlight

this makes the same 😛

It shouldnt (for multiple rows returned) - mysql_fetch_array() retrieves a single row as an array, and advances the resource pointer to the next row.

sapoxgn

Originally posted by laserlight
It shouldnt (for multiple rows returned) - mysql_fetch_array() retrieves a single row as an array, and advances the resource pointer to the next row.

Yes.. its different.. but that was just an example cause he said that didnt undertand the mysql_fetch_array() clearly 🙂