PHP - Multiple Updates Into Mysql

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work? 
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:


$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) { 
          
   $username = $dp['username'];
 $nickname = $dp['nickname'];
 $pwd1 = $dp['password']; 
 $mail = $dp['email'];
 $ip_add = $dp['ip'];
 $wsID = $dp['userID'];
 $registerdate = $dp['registerdate'];
 $birthday = $dp['birthday'];
 $avatar = $dp['avatar'];
 $icq = $dp['icq']; 
 $hp = $dp['homepage'];
 
echo $username." = 1 username only? :(";
      

// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');
                
include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";
      
       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');        
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');
       
       }



So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

How do I get LIKE to check multiple values? It works if you type in a single word, but not multiple, which I want it to in order to get an accurate search result. Here is what I am trying to do:

$target = "siemens 6s" ;

$multis = explode(" ", $target) ;

$query = "SELECT parts_table.*, manufacturers.* FROM parts_table, manufacturers WHERE parts_table.ManufacturerID = manufacturers.ManufacturerID AND parts_table.PartNumber LIKE" ;

foreach($multis as $current) {

$queryext .= " '%$current%' OR" ;

} $queryext = substr($queryext, 0, -3) ; // Remove the last 4 charecters i.e. " AND".

$query .= $queryext ;

echo $query .= " OR manufacturers.ManufacturerID = parts_table.ManufacturerID AND manufacturers.ManufacturerName LIKE" . $queryext ;



include("dbconnect.php") ;

$result = mysql_query($query) ;

while($row = mysql_fetch_assoc($result)){

echo $row['ManufacturerName'] ;
echo $row['PartNumber'] ;

}

Hello.

I'm coding myself an small webpage, In the internet you can see that there is pages like index.php?id=223923 <- for example or index.php?=news.
 So, I'm trying to create similar to that myself. I tried googling and searching youtube how to do this but didn't really find anything.

I figured it out that it needs some database etc.

I tried myself doing some table in my mysql db. And in the table some 'id, title, content' and in the id would be the url, (index.php?='id') the title would be the <title> </title> and the content would be all the code inside the webpage. I got no idea how to link these to an php or whatever it should be done So would anyone kindly tell me howto do this or give some link to an tutorial?

I have a script that has a foreach loop. The script ususally runs for VERY VERY long time ( i have set_time_limit(0)

Now what I need it to do is to echo some string at the end of each loop. However it doesn't. The script displays everything after its finished.

That's not acceptable for me.

I'm running xampp for windows.

i dont know why it doesnt update the db..someone help??

$connection=mysql_connect("$server", "$username", "$password")
   or die("Could not establish connection");
   mysql_select_db($database_name, $connection)
   or die ("Could not select database");

   $strEditProfile = "UPDATE tblemployee SET EmployeeName='".$_POST["edit_thename"]."',
                        Address1 = '".$_POST[edit_address1]."',
                        Address2 = '".$_POST[edit_address2]."',
                        DesignationID = '".$_POST[edit_des]."',
                        Postcode = '".$_POST[edit_postcode]."',
                        State = '".$_POST[edit_state]."',
                        Country = '".$_POST[edit_country]."',
                        Tel1 = '".$_POST[edit_contact]."'            
                        WHERE EEmail='".$_POST["edit_email"]."'";
   
   $resEditProfile = mysql_query($strEditProfile);
   if($resEditProfile)
      echo "<img src=\"images/valid.jpg\" /> Profile updated!";
   else
      echo "><img src=\"images/warning.jpg\">Error!";
   

Hi, I am new to PHP and mySQL. I am working on a golf site where it will need to have the user update info through text boxes. There are two things: 1) It will need to keep an average of the last 6 rounds. The user will need to be able to input the current round score and have it bump the oldest score of the database. 2) Also, i have a database of players that will populate a <select>. Is there a way to have the user be able to add/delete player names from this database? My question is what functions are needed to get this done. And how does one go about implementing them.
Thanks in advance!
Taylor

Hi all

I am trying to take the data from a form and add into a mySQL table.

I have multiple forms on one page that uses a loop:

Code: [Select]
<?php

$textqty = $showbasket['qty'];
for ($i = 1; $i <= $textqty ; $i++) { ?>
           
<form id="texts" name="texts" method="post" action="">
             <input name="mainqty" type="hidden" value="<?php echo $textqty; ?>" />
             <input name="productid" type="hidden" value="<?php echo $showbasket['productid']; ?>" />
             <input name="productqtyid" type="hidden" value="<?php echo $i; ?>" />
              <input name="productsize" type="hidden" value="<?php echo $showbasket['size']; ?>" />
                Text:
                  <input name="text_<?php echo $i; ?>" type="text" value="<?php echo $showtext['text']; ?>" size="35" maxlength="250" />
                Colour:
                <select name="colour">
                  <?php $getcolours = mysql_query(" SELECT * FROM text_colours ORDER BY id ASC");
                   while($showcolours = mysql_fetch_array($getcolours)) { ?>
                  <option value="<?php echo $showcolours['colour']; ?>"><?php echo $showcolours['colour']; ?></option>
                  <?php  } ?>
                </select>
                 No. Characters:
<br />
<?php } ?>
               
               <input name="update" type="submit" id="update" value="Update" />
              </form>

This data is then inserted into the mySQL:

Code: [Select]
<?php

if(isset($_POST['update'])) {
$mqty = $_POST['mainqty'];
for ($i = 1; $i <= $mqty ; $i++) {
$productid = $_POST['productid'];
$productqtyid = $_POST['productqtyid'];
$productsize = $_POST['productsize'];
$colour = $_POST['colour'];
$producttext = $_POST['text_$i'];

mysql_query (" INSERT INTO emb_texts SET sessionid = '".$sessionid."', productid = '".$productid."', qtyid = '".$productqtyid."', size = '".$productsize."', colour = '".$colour."', text = '".$producttext."'") or die(mysql_error());
}
}
?>

This almost works but it adds the $productqtyid the same very time. I'm not sure if I am going about the the right way?

Each form needs to add its own values into the mySQL.

Many thanks for your help

I insert multiple id from my checkbox to mysql database using php post form. in e.x i insert id (checkbox value table test) to mysql. no i need to any function for retrieve data from mysql and print to my page with my e.x output.(print horizontal list name of table test where data = userid)

my checkbox value ( name table is test ) :
Code: [Select]
01 ---id----- name    ----
02 ---1 ----- test1   ----
03 ---2 ----- test2   ----
04 ---3 ----- test3   ----
05 ---4 ----- test4   ----
06 ---5 ----- test5   ----
07 ---6 ----- test6   ----
08 ---7 ----- test7   ----
09 ---8 ----- test8   ----
10 ---9 ----- test9   ----
mysql data Insert ( name of table usertest ):

Code: [Select]
1 ---id----- data    ---- userid -----
2 ---1 ----- 1:4:6:9 ---- 2      -----
3 ---2 ----- 1:2:3:4 ---- 5      -----
4 ---3 ----- 1:2     ---- 7      -----
example outout : ( print horizontal list name of table test where data = userid )


print?
Code: [Select]
1 user id 2 choise : test1 - test4 - test6 - test9
Thanks

Hello everyone,

Once again i need your help this time i want to know that, if I inserting multiple row by single insert query with the help of foreach (loop) then how to insert another cell value according to the name wise

so that's way i send my hole code to you.

<?php
                            //include configuration file for connection
                            include_once('config.php');
                            $sql = "select * from CLASS_STUDENT ORDER BY STUDENT_NAME ASC ";
                            $result=mysql_query($sql);
                            $count=mysql_num_rows($result);
                         ?>
                         <form name="form1" method="post" action="">
                            <table style="text-align: left; padding: 5px;" cellpadding="0px" cellspacing="0px">
                           <tbody>
                              <tr>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Name</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Class</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Section</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Current Date</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Present</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Absent</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Comment</th>
                              </tr>
                              <?php
                                 while($rows=mysql_fetch_array($result))
                                 {
                              ?>                                                   
                              <tr>                                 
                                 <td class="table1">
                                    <? $id[] = $rows['STUDENT_NAME']; ?><? echo $rows['STUDENT_NAME'];?>
                                 </td>
                                 <td class="table1">
                                    <input name="class[<? echo $rows['STUDENT_NAME']; ?>]" type="text" value="<? echo $rows['STUDENT_CLASS']; ?>">
                                 </td>     
                                 <td class="table1">
                                    <input  name="section[<? echo $rows['STUDENT_NAME']; ?>]" type="text" value="<? echo $rows['STUDENT_SECTION']; ?>">
                                 </td>
                                 <td class="table1">
                                    <input name="date[<? echo $rows['STUDENT_NAME']; ?>]" type="text" value="<? echo $rows['PRESENT_DATE']; ?>">
                                 </td>                                                                                 
                                 <td id="present">
                                    <input type="radio" name="present[<? echo $rows['STUDENT_NAME']; ?>]" checked="checked" value="PRESENT">Present           
                                 </td>
                                 <td id="absent">                                   
                                    <input type="radio" name="present[<? echo $rows['STUDENT_NAME']; ?>]" value="ABSENT">Absent
                                 </td>                             
                                 <td style="text-align: left; padding: 5px; border: 1px #000000 solid; height: 33px;">
                                    <input name="comment[<? echo $rows['STUDENT_NAME']; ?>]" type="text" value="<? echo $rows['COMMENT'];?>">
                                 </td>                                                   
                              </tr>
                              <?php }?>
                              <tr>
                                 <td colspan="7" style="vertical-align:middle; text-align: center;"><br><br>                                   
                                    <input id="Submit" type="submit" name="Submit" value="Insert" style="text-align: center; background-color: #000000; color: #ffffff; border: 1px #000000 solid;">
                                 </td>
                              </tr>                                                                                 
                           </tbody>
                        </table>
                     </form>   
                     <?php
                        if(isset($_POST['Submit']))
                        {
                           foreach($_POST['present'] as $id => $value)
                           {
                              $class=$_POST['class'];
                              $section=$_POST['section'];
                              $date=$_POST['date'];
                              $comment=$_POST['comment'];                                   
                               $sql = "INSERT INTO ATTENDANCE(STUDENT_NAME, STUDENT_CLASS, STUDENT_SECTION, PRESENT_DATE, STUDENT_PRESENT, COMMENT) VALUES ('".$id."', '$class[$value]', '$section[$value]', '$date[$value]', '".$value."', '$comment[$value]') ";
                               $result = mysql_query($sql);                           
                           }
                        }
                        if($result)
                        {
                            header("location:Tea_home.php");                                                     
                        }
                        else
                        {
                           //print_r ($_POST);
                           echo "Your entry is not completed at this time.............";
                        }
                     ?>


My result is comming just like that

STUDENT_ID ||   STUDENT_NAME || STUDENT_CLASS  ||   STUDENT_SECTION  ||   PRESENT_DATE ||   STUDENT_PRESENT    ||COMMENT
231    ||   PRASHANT KUMAR   ||                     ||                       || 1/1/0001 12:00:00 AM       ||         ABSENT                ||   
230    ||   JYOTI NANDA            ||                     ||                       || 1/1/0001 12:00:00 AM       ||            PRESENT        ||   
229    ||   TARUN NANDA          ||                     ||                       || 1/1/0001 12:00:00 AM       ||            PRESENT         ||   
228    ||   RAVI KUMAR             ||                     ||                       || 1/1/0001 12:00:00 AM       ||            PRESENT         ||   
227    ||   RAJIV KUMAR            ||                     ||                       || 1/1/0001 12:00:00 AM       ||            PRESENT           ||
226    ||   PRASHANT KUMAR    ||                     ||                       || 1/1/0001 12:00:00 AM       ||            ABSENT           ||
225    ||   JYOTI NANDA            ||                     ||                       || 1/1/0001 12:00:00 AM       ||            PRESENT           ||



can you help me where i am writing wrong code

Hello everyone,

I'm a newbie with PHP and mySQL and need some assistance with writing a php script that searches a mySQL database using a form.   The form has five fields that I want to search from and one is a required field (State).  I need to filter or narrow down the search by either two or more fields.  The problem I am having is if I used multiple WHERE clauses using the AND condition I have to enter valid information in all five fields and if I use the OR condition then my search does not produce the desired outcome (too many results).  I "think" I need to use the AND condition but I need to be able to leave some of the fields blank (except for the State field) and narrow my search with using anywhere from 2-5 search fields.

Also, another requirement is to be able to enter partial information in the search field "without" having to enter a wildcard in the search field.  Any assistance is very much appreciated and thanks in advance for your help.

Form Fields:
State                  SELECT FIELD
Lease                 TEXT FIELD
Operator Name   TEXT FIELD
County or Parish TEXT FIELD
Well No               TEXT FIELD

I have a table called well_permits and it is structure is as follows:

date            DATE
state           TEXT
county        VARCHAR
api              VARCHAR
permit_no   VARCHAR
operator      VARCHAR
phone         VARCHAR
contact       VARCHAR
lease           VARCHAR
well_no       VARCHAR
permit_for  VARCHAR
welltype      VARCHAR
wellspot      VARCHAR
lat              FLOAT
lon             FLOAT
depth         VARCHAR

This is what I have for the connecting to my database and selecting the fields:

<?php require_once('../../../Connections/Wldatabase.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$currentPage = $_SERVER["PHP_SELF"];

//Variable to store Unique_ID aka API which will be passed to the well-search-results.php page
$var_api_rs_search = $_Get['api'];

$maxRows_rs_search = 20;
$pageNum_rs_search = 0;
if (isset($_GET['pageNum_rs_search'])) {
  $pageNum_rs_search = $_GET['pageNum_rs_search'];
}
$startRow_rs_search = $pageNum_rs_search * $maxRows_rs_search;

$var_state_rs_search = "%";
if (isset($_GET['state'])) {
  $var_state_rs_search = $_GET['state'];
}
$var_lease_rs_search = "%";
if (isset($_GET['lease'])) {
  $var_lease_rs_search = $_GET['lease'];
}
$var_well_no_rs_search = "%";
if (isset($_GET['well_no'])) {
  $var_well_no_rs_search = $_GET['well_no'];
}
$var_operator_rs_search = "%";
if (isset($_GET['operator'])) {
  $var_operator_rs_search = $_GET['operator'];
}
$var_county_rs_search = "%";
if (isset($_GET['County'])) {
  $var_county_rs_search = $_GET['County'];
}
mysql_select_db($database_Wldatabase, $Wldatabase);
$query_rs_search = sprintf("SELECT DISTINCT * FROM well_permits WHERE (well_permits.`state` LIKE %s AND well_permits.county LIKE %s) OR (well_permits.lease LIKE %s) OR (well_permits.operator LIKE %s) OR (well_permits.well_no LIKE %s) ORDER BY well_permits.county", GetSQLValueString($var_state_rs_search, "text"),GetSQLValueString($var_county_rs_search, "text"),GetSQLValueString($var_lease_rs_search, "text"),GetSQLValueString($var_operator_rs_search, "text"),GetSQLValueString($var_well_no_rs_search, "text"));
$query_limit_rs_search = sprintf("%s LIMIT %d, %d", $query_rs_search, $startRow_rs_search, $maxRows_rs_search);
$rs_search = mysql_query($query_limit_rs_search, $Wldatabase) or die(mysql_error());
$row_rs_search = mysql_fetch_assoc($rs_search);
?>

This is my form:

<form action="search.php" method="GET" name="frmsearch" target="_self">

<input name="api" type="hidden" value="" />
<div>

<table width="900" border="0" align="center" cellpadding="2" cellspacing="2">
    <tr>
       <td colspan="6">
           <p style="text-align:left">Select a State then enter at least one search criteria.  State is a required field.</p>
          * Denotes a required field.<br>
   </td>
    </tr>
    <tr>
       <td align="right">* State: </td>
       <td>
          <select name="state" size="1" dir="ltr" lang="en">
     <option value="AL">AL</option>
          <option value="AR">AR</option>
          <option value="CA">CA</option>
          <option value="CO">CO</option>
          <option value="IL">IL</option>
          <option value="IN">IN</option>
          <option value="KS">KS</option>
          <option value="KY">KY</option>
          <option value="LA">LA</option>
          <option value="MI">MI</option>
          <option value="MS">MS</option>
          <option value="MT">MT</option>
          <option value="ND">ND</option>
          <option value="NE">NE</option>
          <option value="NM">NM</option>
          <option value="NY">NY</option>
          <option value="OH">OH</option>
          <option value="OK">OK</option>
          <option value="OS">OS</option>
          <option value="PA">PA</option>
          <option value="SD">SD</option>
          <option value="TX">TX</option>
          <option value="UT">UT</option>
          <option value="WV">WV</option>
          <option value="WY">WY</option>
          &nbsp;</select>
      </td>
      <td align="right">County or Parish: </td>
      <td align="left"><input name="County" type="text" value="" size="35" maxlength="40" /></td>
    </tr>
    <tr>
      <td width="63" align="right">Lease: </td>
      <td width="239"><input name="lease" type="text" value="" /></td>
      <td align="right">Well No: </td>
      <td><input name="well_no" type="text" value="" /></td>
    </tr>
    <tr>
      <td width="111" align="right">Operator Name: </td>
      <td width="261"><input name="operator" type="text" value="" /></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td align="left"><input name="search" type="submit" value="Search" /></td>
  </tr>
</table>
</form>


My Repeat Region starts here


<table width="100%" border="1" align="center" cellpadding="2" cellspacing="2">
  <tr>
    <td align="right">&nbsp;</td>
    <th align="center">Operator</th>
    <th align="center">Lease</th>
    <th align="center">Well Number</th>
    <th align="center">County</th>
    <th align="center">State</th>
  </tr>
  <tr> 
  <?php do { ?>
    <td align="center"><a href="results.php?recordID=<?php echo $row_rs_search['api']; ?>">Select</a></td>
    <td align="left"><?php echo $row_rs_search['operator']; ?></td>
    <td align="left"><?php echo $row_rs_search['lease']; ?></td>
    <td align="center"><?php echo $row_rs_search['well_no']; ?></td>
    <td align="center"><?php echo $row_rs_search['county']; ?></td>
    <td align="center"><?php echo $row_rs_search['state']; ?></td>
  </tr>
  <?php } while ($row_rs_search = mysql_fetch_assoc($rs_search)); ?>
</table>


<p align="center">Number of Wells Located: <?php echo ($startRow_rs_search + 1) ?> to <?php echo min($startRow_rs_search + $maxRows_rs_search, $totalRows_rs_search) ?> of <?php echo $totalRows_rs_search ?></p>


<table border="0" align="center">
  <tr>
    <td align="center"><?php if ($pageNum_rs_search > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, 0, $queryString_rs_search); ?>">First</a>
        <?php } // Show if not first page ?></td>
    <td align="center"><?php if ($pageNum_rs_search > 0) { // Show if not first page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, max(0, $pageNum_rs_search - 1), $queryString_rs_search); ?>">Previous</a>
        <?php } // Show if not first page ?></td>
    <td align="center"><?php if ($pageNum_rs_search < $totalPages_rs_search) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, min($totalPages_rs_search, $pageNum_rs_search + 1), $queryString_rs_search); ?>">Next</a>
        <?php } // Show if not last page ?></td>
    <td align="center"><?php if ($pageNum_rs_search < $totalPages_rs_search) { // Show if not last page ?>
        <a href="<?php printf("%s?pageNum_rs_search=%d%s", $currentPage, $totalPages_rs_search, $queryString_rs_search); ?>">Last</a>
        <?php } // Show if not last page ?></td>
  </tr>
</table>

Hi People

i'm a newb at this so bare with me but i currently have a php file called Newkpi.php which has a select statement in. this selects data from a table called "StaffList".
this then populates the page with a html table with 14 records (this will increase/decrease over time) i then have some extra text boxes to enter more detail into like service amaount service date and so on.
when i click the submit button i want it to cycle through each row and insert the data into a separate table called "Services". however i cannot for the life of me get this to work and need some help with it. people find attached the code for Newkpi and see if you can help me with this.

in total i want it to take the names from stafflist and populate Services with the names and the extra detail which is entered on the page

Much Thanx in advance

SLOWIE

Hello everyone! I'm new here on phpfreaks - Here's my problem. I get "1 <br/> 2" echoed, but not the query results. the connect() function connects and selects a table in a mysql database.

Here's the code:
Code: [Select]
<?php
connect();

$query = "SELECT `title`, `body`, `date` FROM `tutorials` ORDER BY `date` DESC" or die ("Query Error");

$counter = 0;

if ($query_run = mysql_query($query)) {

while ($query_row = mysql_fetch_assoc($query_run)) && ($counter <= 2) {
$title = $query_row['title'];
$body = $query_row['body'];
$date = $query_row['date'];
$counter ++;
echo $counter;
echo "<br/>";
echo $title;
echo $body;
echo $date;
}
}
?>
If anyone has any idea, please help! - I'm been battling this for a few hours now

I am trying to update multiple rows in a mysql db through php but I am getting an error message in this line:

$size = count($_POST['uid']);

My db field names are uid (which autoincrements and does not need to be updated), fname, lname and email fields. Here is a link for the project I need to develophttp://users.cis.fiu.edu/~vagelis/classes/COP5725/project.htm

Here is the content for the first page:

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head>
<style type="text/css">

body {
margin:50px 0px; padding:0px;
text-align:center;
font:13px Tahoma,Geneva,sans-serif
}

#content {
width:1000px;
margin:0px auto;
text-align:left;
padding:15px;
border:1px dashed #333;
background-color:#eee;
}
</style>
<link rel="icon" href="http://www.mysite.com/favicon.ico" type="image/vnd.microsoft.icon" />
</head>
<body>
<div id='content'><h3><center>Update Information</center></h3>
<?php

//create a connection
$connection = mysql_connect("localhost","root","r2d2c3po");

//test the connection
if (!$connection)
{
die("Database connection failed: " . mysql_error());
}
//select database to use
mysql_select_db("music_social_network", $connection);
//setup query
$sql = "SELECT * FROM `user` ORDER BY uid";
//get results from query or die
$result = mysql_query($sql, $connection) or die(mysql_error());
//fetch rows from query
$rows = mysql_fetch_assoc($result);
?>

<?php 

// find out how many records there are to update 
$size = count($_POST['uid']); 

// start a counter in order to number the input fields for each record 
$i = 0; 
print "<table width='100%' border='0' cellspacing='1' cellpadding='0'><tr><td>"; 
// open a form 
print "<form name='namestoupdate' method='post' action='update.php'> 
<table width='100%' border='0' cellspacing='1' cellpadding='1'><tr> 

<td align='center'><strong>User ID</strong></td> 
<td align='center'><strong>First Name</strong></td> 
<td align='center'><strong>Last Name</strong></td> 
<td align='center'><strong>Email</strong></td> 
</tr>\n"; 

// start a loop to print all of the users with their information 
// the mysql_fetch_array function puts each record into an array. each time it is called, it moves the array counter up until there are no more records left 
while ($Update = mysql_fetch_array($result)) { 
print "</tr>\n"; 
// assuming you have three important columns (the index (id), the course name (course), and the book info (bookinfo)) 
// start displaying the info; the most important part is to make the name an array (notice bookinfo[$i]) 
print "<td align='center'><p>{$Update['uid']}</p></td>\n"; 
print "<td align='center'><input type='text' fname='fname[$i]' value='{$Update['fname']}' /></td>"; 
print "<td align='center'><input type='text' size='40' lname='lname[$i]' value='{$Update['lname']}' /></td>\n"; 
print "<td align='center'><input type='text' size='40' email='email[$i]' value='{$Update['email']}' /></td>\n"; 
print "</tr>\n"; 
// add 1 to the count, close the loop, close the form, and the mysql connection 
++$i; 
} 
print "<tr> 
<td colspan='4' align='center'><input type='submit' value='submit' />"; 
print "</td> 
</tr> 
</table> 
</td> 
</tr> 
</form> 
</table>"; 
mysql_close($connection); 
?><br /><br /><div></body>
</html>

here is the content for the update.php page:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head>
<style type="text/css">

body {
margin:50px 0px; padding:0px;
text-align:center;
font:13px Tahoma,Geneva,sans-serif
}

#content {
width:1000px;
margin:0px auto;
text-align:left;
padding:15px;
border:1px dashed #333;
background-color:#eee;
}
</style>
<link rel="icon" href="http://www.mysite.com/favicon.ico" type="image/vnd.microsoft.icon" />
</head>
<body>
<div id='content'><h3><center>Success! </center></h3>
<table width='100%' border='0' cellspacing='1' cellpadding='0'><tr><td>


<table width='100%' border='0' cellspacing='1' cellpadding='1'>
<tr>

<td align='center'><strong>User ID</strong></td>
<td align='center'><strong>First Name</strong></td>
<td align='center'><strong>Last Name</strong></td>
<td align='center'><strong>Email</strong></td>
</tr>
<?php 

//create a connection
$connection = mysql_connect("localhost","root","r2d2c3po");

//test the connection
if (!$connection)
{
die("Database connection failed: " . mysql_error());
}
//select database to use
mysql_select_db("music_social_network", $connection);
//setup query
$sql = "SELECT * FROM `user` ORDER BY uid";
//get results from query or die
$result = mysql_query($sql, $connection) or die(mysql_error());
//fetch rows from query
$rows = mysql_fetch_assoc($result);




// find out how many records there are to update 
$size = count($_POST['uid']); 

// start a loop in order to update each record 
$i = 0; 
while ($i < $size) { 
// define each variable 
$uid = $_POST['uid'][$i]; 
$fname = $_POST['fname'][$i]; 
$lname = $_POST['lname'][$i]; 
$email = $_POST['email'][$i]; 

// do the update and print out some info just to provide some visual feedback 

$query = "UPDATE `user` SET `fname` = '$fname', `lname` = '$lname', `email` = '$email' WHERE `uid` = '$uid' "; 
mysql_query($sql) or die ("Error in query: $query"); 
print " 

</tr> 
<td align='left'><p>$uid</p></td> 
<td align='left'>$fname</td> 
<td align='left'>$fname</td> 
<td align='left'>$lname</td> 
</tr> 
"; 
++$i; 
} 
mysql_close($connection); 
?>
<tr>
<td colspan='4' align='center'>
</td>
</tr>
</table>
</td>
</tr>

</table></div></body></html>

Mod edit: [code] . . . [/code] tags added.

Hello Friends!.... here is the big idea. I am trying to make a form in which there will be 2 drop down lists which will be populating directly from MySQL DB ....
Actually i am developing a student management system as my first PHP project... here i want to have 2 drop down lists first is roll number and second is student name. i want that when some one select the roll number in the first drop down the student name against it is automatically populated in the next drop down.


please help me friends i am new to php and dont know soo much.! any help PLZZZZZZZZZZ

I have two drop down menus in a table side by side being populated exactly the same from a msql database.
The first menu populates fine but  the second one is blank.
They are both supposed to be identical, the same info from the same table so I assume that's my problem.
I tried moving the while loop so it encapsulates both drop downs but then it messes up the table structure.
I tried changing the name of some of the variables by adding "2" on the end  & that didn't work either.
Is it because once a while loop is executed it can't be used again on the same instance?
Heres my code so far:

      <tr>
        <td >   <select name="wall_type" size="1" style="width: 175px;" >      
<?php
while ($walls_row=mysql_fetch_array($result_walls))
 {
$type_name=$walls_row["type"];   
$type_id=$walls_row["id"];    
 ?>
  <option value="<?php echo $type_id; ?>"><?php echo $type_name; ?>   </option>
<?php
}
?>
 </select>
   </td>
 <td >
 <select name="wall_type2" size="1"  style="width: 175px;">
<?php
while ($walls_row2=mysql_fetch_array($result_walls))
 {
$type_name2=$walls_row2["type"];   
$type_id2=$walls_row2["id"]; 
 
 ?>
 <option value="<?php echo $type_id2; ?>"><?php echo $type_name2; ?>   </option>
 <?php
}
?>
 </select>
 </td>
 </tr>