PHP - Problem In Mysqli - Email Is Sent Withou The Correct Values

Hi I'm trying to insert unique info retrieved to my database but seems like I'm doing something wrong with my quary my current setup is as follow   mxit.php

<?php
$con=mysqli_connect("*****","*******","*******","******");


// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}


mysqli_close($con);
?>


<?












define('TIMEZONE', 'Africa/Harare');
date_default_timezone_set(TIMEZONE);




$ip = $_SERVER["REMOTE_ADDR"];
$post_time = date("U");
$mxitua = $_SERVER["HTTP_X_DEVICE_USER_AGENT"];
$mxitcont = $_SERVER["HTTP_X_MXIT_CONTACT"];
$mxituid = $_SERVER["HTTP_X_MXIT_USERID_R"];
$mxitid = $_SERVER["HTTP_X_MXIT_ID_R"];
$mxitlogin = $_SERVER["HTTP_X_MXIT_LOGIN"];
$mxitnick = $_SERVER["HTTP_X_MXIT_NICK"];
$mxitloc = $_SERVER["HTTP_X_MXIT_LOCATION"];
$mxitprof = $_SERVER["HTTP_X_MXIT_PROFILE"];


if(!isset($mxitid))
{
$mxitid = "DEFAULT";
}










                mysqli_query($con,"INSERT INTO mxit (ip,time,user_agent,contact,userid,id,login,nick,location,profile) VALUES ($ip,$post_time,$mxitua,$mxitcont,$mxituid,$mxitid,$mxitlogin,$mxitnick,$mxitloc,$mxitprof)");
  mysqli_close($con);


?> 

              

Hello guys, i'm currently building my own cms, a personal project, and now im stucked on an  error "Call to a member function query() on a non-object in.. please help    after creating this function.. I know the db connection and everything else worked out because i have a similar function that works just without the switch or the numrow if statement.

	protected function _pageStatus($option, $id){ //check if page exists, if it does return the status, or return 404
		switch($option){
			case 'alpha' : $sql	= "SELECT status FROM pages WHERE nick = '$id'"; break;
			case 'num' : $sql	= "SELECT status FROM pages WHERE id = '$id'"; break;
		}
		if($result = $this->_db->query($sql)){ //<--- THE ERROR WAS ON THIS LINE. 
			if($result->num_rows > 0){
    			while ($status = $result->fetch_object()) {
        			return $status;
    			}
				return $status;
				$result->close(); 
			} else {
				return 404;	
			}	
		}
	}

I've been starting to play around the mysqli class and I've been having trouble using it due to various error it gives me from simple queries like this one. I'm not sure what the error is really, I've been following the php manual. Any help would be greatly appreciated.



Code: [Select]
<?php 


$mysqli = new MySQLi('localhost', 'root', 'root', 'jaipai');

if ($mysqli->connect_errno)
{
echo "There was a connection error: ". $mysqli->connecterrno;
}



class testClass 

{

private $db;


function __construct($mysqli)
{
$this->db = $mysqli;
}

public function pageInfo()
{
$query = "SELECT * FROM users WHERE username = jaipai";
$results = $this->db->query($query);

$result = $this->db->fetch_assoc($results);

return $result['username'];

}

}

$testClass = new testClass($mysqli);

echo $testClass->pageInfo();


?>
This gives me this error:
Code: [Select]
Fatal error: Call to undefined method mysqli::fetch_assoc() in /Users/JPFoster/Sites/Research & Development/Programs/Object Sandbox/DatabaseConnection.php on line 30



Just to be a little more informative I've also tried this method
Code: [Select]
$results = $this->db->query($query);

$result = $results->fetch_assoc();

return $result['username'];

This gives me an error:
Code: [Select]
Fatal error: Call to a member function fetch_assoc() on a non-object in Sites/Research & Development/Programs/Object Sandbox/DatabaseConnection.php on line 30

I'm not sure which is on the best path to go. Any help would be greatly appreciated.

Hi I have an infuriating problem which is stalling me with two large projects for a well known NGO right now.

I am using mysqli and bound variables where the number of variables to bind is dependent on user input. I have a version of the code below working in php 5.2 but as of php 5.3 this method is no longer valid, specifically due to a change in the behavior of call_user_func_array with bound variables as arrays. I have read about this problem eslewhere but cannot get any of the workarounds to work with my example. Any help would be greatly appreciated.

Code: [Select]
# $parts    is an array with variable number of values
# $type     is an array with variable number of values
# $params   is an array with variable number of values



$query = 'SELECT SQL_CALC_FOUND_ROWS DISTINCT
 taxon.TaxonID,
FROM taxon
WHERE
. join('', $parts) .
" ORDER BY taxon.TaxonID";



# Prepare stmt
if ($stmt = $mysqli->prepare($query)) {


   call_user_func_array (array($stmt, 'bind_param'),array_merge(array(join('', $type)), $params));


# execute
$stmt->execute();


# bug info
echo $stmt->errno, ':', $stmt->error;

        #store result
$stmt->store_result();

# bind results
$stmt->bind_result($ID);

        # fetch values
        while ($stmt->fetch()) {

      # results code goes here!
   
        }

       # free memory
       $stmt->free_result();

       # close statement
       $stmt->close();
}

Hi, During post of my form I am trying to send some table values.  The three field values (DATE, SITE, PRICE) that I want to send are attached to the id field (RID) in the daterange table.  The variable $FTGRID is attached to the RID field.  Here is the structure of the daterange table and the code from the php page related to the email is below.  Do I need to pre-define variables for these three field values?

daterange Table:
RID
DEND
MONTH
DATE
SITE
PRICE
STATUS

Code: [Select]
if ( $validationFailed === false ) {

 # Email to Form Owner
 
 $emailSubject = FilterCChars("Your Reservation");
 
 $emailBody = "Reservation Date : \n"
  . "Site : \n"
  . "Price : \n"
  . "Fname : $FTGFNAME\n"
  . "Lname : $FTGLNAME\n"
  . "Addr1 : $FTGADDR1\n"
  . "Addr2 : $FTGADDR2\n"
  . "City :  $FTGCITY\n"
  . "State : $FTGSTATE\n"
  . "Zip : $FTGZIP\n"
  . "Phone : $FTGPHONE1"
  . "- $FTGPHONE2"
  . "- $FTGPHONE3\n"
  . "Email : $FTGEMAIL\n"
  . "Payment Method : $FTGPM\n"
  . "Last Four CC : $FTGC4\n"
  . "";
  $emailTo = 'u@yahoo.com';
   
  $emailFrom = FilterCChars("inquiry@c.com");
   
  $emailHeader = "From: $emailFrom\n"
   . "MIME-Version: 1.0\n"
   . "Content-type: text/plain; charset=\"UTF-8\"\n"
   . "Content-transfer-encoding: 8bit\n";
   
  mail($emailTo, $emailSubject, $emailBody, $emailHeader);
 
 
 # Confirmation Email to User
 
 $confEmailTo = FilterCChars($FTGEMAIL);
 
 $confEmailSubject = FilterCChars("Confirmation of Reservation");
 
 $confEmailBody = "Reservation Date : \n"
  . "Site : \n"
  . "Price : \n"
  . "Fname : $FTGLNAME\n"
  . "Lname : $FTGLNAME\n"
  . "Addr1 : $FTGADDR1\n"
  . "Addr2 : $FTGADDR2\n"
  . "City : $FTGCITY\n"
  . "State : $FTGSTATE\n"
  . "Zip : $FTGZIP\n"
  . "Phone : $FTGPHONE1"
  . "- $FTGPHONE2"
  . "- $FTGPHONE3\n"
  . "Email : $FTGEMAIL\n"
  . "Payment Method : $FTGPM\n"
  . "Last Four CC : $FTGC4\n"
  . "";
 
 $confEmailHeader = "From: inquiry@c.com\n"
  . "MIME-Version: 1.0\n"
  . "Content-type: text/plain; charset=\"UTF-8\"\n"
  . "Content-transfer-encoding: 8bit\n";
 
 mail($confEmailTo, $confEmailSubject, $confEmailBody, $confEmailHeader);

Im having a little trouble with the script below.  I get my three sql values returned fine, without a problem.
The problem is that Im not sending any emails with it.

Wether this is a problem with my syntax, headers, code ??? i dont know.
Please go easy on my scripts, im a learning newbie.

<html><body>
<?php
mysql_connect("***","***","***"); 
mysql_select_db("***") or die("Unable to select database"); 

$code = $_GET['postcode'];
$message = $_GET['message'];
$shortcode = substr($code,0,2);
$subject = "subject here";
$result = mysql_query("SELECT email FROM treesurgeons WHERE postcode like '%" . $shortcode . "%' ORDER BY companyName LIMIT 3")
or die(mysql_error());  
echo "<h2>Business Names:</h2>";                     
while($row = mysql_fetch_assoc($result)) 
{$message .= "\r\n". $row['email'] ;}
{$value = $row['email'].',';}
rtrim($row, ',');
$i = 0;
{$i++; switch($i)
{case 0:$value1 = $row['email']; break;
 case 1:$value2 =$row['email']; break;
 case 2:$value3 =$row['email']; break; }}
$to = "$value1, $value2, $value3";
echo nl2br ($message); 
$headers = 'From: me@me.com' . "\r\n" .
    'Reply-To: me@me.com' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();
mail( "$to", "$subject","$message", "$headers");
echo "<br>" . "Thank you for using our mail form.";
?></body></html>

<?php

if (isset($_POST['reset-submit'])) {
    $selector = $_POST['selector'];
    $validator = $_POST['validator'];
    $password = $_POST['password'];
    $password2 = $_POST['password2'];

    // probably better to check this earlier
    if (empty($password) || empty($password2)) {
        header("Location: ../create-new-password.php?newpassword=empty&selector=$selector&validator=$validator");
    } elseif ($password !== $password2) {
        header("Location: ../create-new-password.php?newpassword=passwordsnotmatch");
    }

    $currentDate = date("U");

    require "dbh.inc.php";
    
    $sql = "SELECT * FROM reset_password WHERE selector=? AND expires >= $currentDate";
    $stmt = mysqli_stmt_init($conn);
    if (!mysqli_stmt_prepare($stmt, $sql)) {
        echo "SQL error 1";
        exit();
    } else {
        mysqli_stmt_bind_param($stmt, 'ss', $selector, $currentDate);
        mysqli_stmt_execute($stmt);
        $result = mysqli_stmt_get_result($stmt);
        
        if (!$row = mysqli_fetch_assoc($result)) {
            echo 'You need to re-submit your reset request.';
            exit();
        } else {
            $tokenBin = hex2bin($validator);
            $tokenCheck = password_verify($tokenBin, $row['token']);

            if (!$tokenCheck) {
                echo 'You need to re-submit your reset request.';
                exit();
            } else {
                $email = $row['email'];
                $sql = "SELECT * FROM users WHERE email = $email";
                $stmt = mysqli_stmt_init($conn);
                if (!mysqli_stmt_prepare($stmt, $sql)) {
                    echo "SQL error 2";
                    exit();
                } else {
                    mysqli_stmt_bind_param($stmt, 's', $email);
                    mysqli_stmt_execute($stmt);
                    $result = mysqli_stmt_get_result($stmt);
                    if (!$row = mysqli_fetch_assoc($result)) {
                        echo "SQL error 3";
                        exit();
                    } else {
                        $sql = "UPDATE users SET password=? WHERE email=?";
                        $stmt = mysqli_stmt_init($conn);
                        if (!mysqli_stmt_prepare($stmt, $sql)) {
                            echo "SQL error4 ";
                            exit();
                        } else {
                            $hashed_password = password_hash($password, PASSWORD_DEFAULT);
                            mysqli_stmt_bind_param($stmt, 'ss', $hashed_password, $email);
                            mysqli_stmt_execute($stmt);
                            $sql = 'DELETE FROM reset_password WHERE email=?';
                            $stmt = mysqli_stmt_init($conn);
                            if (!mysqli_stmt_prepare($stmt, $sql)) {
                                echo 'SQL error5';
                                exit();
                            } else {
                                mysqli_stmt_bind_param($stmt, 's', $email);
                                mysqli_stmt_execute($stmt);
                                header("Location: ../signup.php?newpassword=updated");
                            }
                        }
                    }
                }
            }
        }
    }
    mysqli_stmt_close($stmt);
    mysqli_close($conn);

    header('Location: ../reset-password.php?reset=success');
} else {
    header('Location: ../index.php');
}

I always get this errors:

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in C:\xampp\htdocs\php_login_system-master\includes\reset-password.inc.php on line 26

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\php_login_system-master\includes\reset-password.inc.php on line 30
You need to re-submit your reset request.

 

But i dont find the mistake in the Code. Can someone help me please

Hi

I am gathering numbers in an array and then want to add together all the numbers attached to the same email so I end up with the Grand totals of each email address.

Below is the code I am using to pull out the email and attached values
Code: [Select]
$getcashdonationsdb = $wpdb->get_results("SELECT * FROM cashdepo WHERE cause='$causename' AND status='2' ORDER BY user DESC");
$i = 0;
while($i < $count2) {
foreach($getcashdonationsdb as $getcashdonationsdb){
$dataa[$i]['email'] = $getcashdonationsdb->email;
                $dataa[$i]['cost'] = $getcashdonationsdb->cost;
         }
}

Anyone have any suggestions how I can achieve this most efficiently.

It's pretty simple to see what I am trying to do here. For some reason all results in the table are the same exact cityName replacing all existing records. The echoed results are correct. I've include a small dump of my table as well.

$query = "SELECT cityName FROM sys_city_dev_2";
      $resource = mysqli_query($cxn, $query) or die("MySQL error: " . mysqli_error($cxn) . "<hr>\nQuery: $query");
      
  while($result = mysqli_fetch_assoc($resource)) {

          $nox = $result['cityName'];

          $toUpper = ucfirst($nox);
  echo "$toUpper" . "<br />";

          $setString = "UPDATE sys_city_dev_2 SET cityName = '" . $toUpper ."' WHERE cityName != ''";
          mysqli_query($cxn,$setString);


      } 

100 Records of table dump (pre running my script above):

--
-- Table structure for table `sys_city_dev_2_backup`
--

CREATE TABLE IF NOT EXISTS `sys_city_dev_2_backup` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Mid` int(11) NOT NULL DEFAULT '0',
  `cityName` varchar(30) NOT NULL DEFAULT '',
  `forder` int(4) NOT NULL DEFAULT '0',
  `disdplay` int(4) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=113970 ;

--
-- Dumping data for table `sys_city_dev_2_backup`
--

INSERT INTO `sys_city_dev_2_backup` (`ID`, `Mid`, `cityName`, `forder`, `disdplay`, `cid`) VALUES
(84010, 1, 'dothan', 0, 0, 0),
(84011, 1, 'alabaster', 0, 0, 0),
(84012, 1, 'birmingham', 0, 0, 0),
(84013, 2, 'flagstaff', 0, 0, 0),
(84014, 1, 'auburn', 0, 0, 0),
(84015, 1, 'florence', 0, 0, 0),
(84016, 1, 'gadsden', 0, 0, 0),
(84017, 1, 'huntsville', 0, 0, 0),
(84018, 1, 'mobile', 0, 0, 0),
(84019, 1, 'montgomery', 0, 0, 0),
(84020, 1, 'tuscaloosa', 0, 0, 0),
(84021, 2, 'mohave valley', 0, 0, 0),
(84022, 2, 'phoenix', 0, 0, 0),
(84023, 2, 'prescott', 0, 0, 0),
(84024, 2, 'sierra vista', 0, 0, 0),
(84025, 2, 'tucson', 0, 0, 0),
(84026, 2, 'yuma', 0, 0, 0),
(84027, 3, 'bakersfield', 0, 0, 0),
(84028, 3, 'chico', 0, 0, 0),
(84029, 3, 'fresno / madera', 0, 0, 0),
(84030, 3, 'gold country', 0, 0, 0),
(84031, 3, 'humboldt county', 0, 0, 0),
(84032, 3, 'imperial', 0, 0, 0),
(84033, 3, 'inland empire', 0, 0, 0),
(84034, 3, 'los angeles', 0, 0, 0),
(84035, 3, 'alhambra', 0, 0, 0),
(84036, 3, 'merced', 0, 0, 0),
(84037, 49, 'fayetteville', 0, 0, 0),
(84038, 49, 'fort smith', 0, 0, 0),
(84039, 49, 'jonesboro', 0, 0, 0),
(84040, 49, 'little rock', 0, 0, 0),
(84041, 49, 'arkadelphia', 0, 0, 0),
(84042, 49, 'texarkana', 0, 0, 0),
(84043, 3, 'modesto', 0, 0, 0),
(84044, 3, 'alta sierra', 0, 0, 0),
(84045, 3, 'alpine', 0, 0, 0),
(84046, 3, 'pedley', 0, 0, 0),
(84047, 3, 'redding', 0, 0, 0),
(84048, 3, 'alondra park', 0, 0, 0),
(84049, 3, 'sacramento', 0, 0, 0),
(84050, 4, 'canon city', 0, 0, 0),
(84051, 3, 'san luis obispo', 0, 0, 0),
(84052, 3, 'santa barbara', 0, 0, 0),
(84053, 3, 'stockton', 0, 0, 0),
(84054, 3, 'aliso viejo', 0, 0, 0),
(84055, 3, 'visalia', 0, 0, 0),
(84056, 3, 'yuba city', 0, 0, 0),
(84057, 4, 'boulder', 0, 0, 0),
(84058, 4, 'colorado springs', 0, 0, 0),
(84059, 4, 'denver', 0, 0, 0),
(84060, 4, 'applewood', 0, 0, 0),
(84061, 4, 'pueblo', 0, 0, 0),
(84062, 4, 'air force academy', 0, 0, 0),
(84063, 5, 'avon', 0, 0, 0),
(84064, 5, 'hartford', 0, 0, 0),
(84065, 5, 'new haven', 0, 0, 0),
(84066, 5, 'ansonia', 0, 0, 0),
(84067, 5, 'fairfield', 0, 0, 0),
(84068, 7, 'daytona beach', 0, 0, 0),
(84069, 7, 'sebastian', 0, 0, 0),
(84070, 5, 'wallingford center', 0, 0, 0),
(84071, 8, 'belvedere park', 0, 0, 0),
(84072, 7, 'sarasota springs', 0, 0, 0),
(84073, 7, 'sandalfoot cove', 0, 0, 0),
(84074, 7, 'san carlos park', 0, 0, 0),
(84075, 7, 'st. augustine', 0, 0, 0),
(84076, 7, 'tallahassee', 0, 0, 0),
(84077, 7, 'safety harbor', 0, 0, 0),
(84078, 7, 'ruskin', 0, 0, 0),
(84079, 8, 'athens-clarke county', 0, 0, 0),
(84080, 8, 'atlanta', 0, 0, 0),
(84081, 8, 'augusta-richmond county', 0, 0, 0),
(84082, 8, 'brunswick', 0, 0, 0),
(84083, 8, 'columbus', 0, 0, 0),
(84084, 8, 'americus', 0, 0, 0),
(84085, 8, 'acworth', 0, 0, 0),
(84086, 8, 'valdosta', 0, 0, 0),
(84087, 10, 'boise', 0, 0, 0),
(84088, 10, 'ammon', 0, 0, 0),
(84089, 10, 'moscow', 0, 0, 0),
(84090, 10, 'blackfoot', 0, 0, 0),
(84091, 10, 'twin falls', 0, 0, 0),
(84092, 10, 'meridian', 0, 0, 0),
(84093, 10, 'jerome', 0, 0, 0),
(84094, 10, 'idaho falls', 0, 0, 0),
(84095, 11, 'addison', 0, 0, 0),
(84096, 10, 'garden city', 0, 0, 0),
(84097, 10, 'eagle', 0, 0, 0),
(84098, 10, 'chubbuck', 0, 0, 0),
(84099, 10, 'caldwell', 0, 0, 0),
(84100, 12, 'bloomington', 0, 0, 0),
(84101, 12, 'evansville', 0, 0, 0),
(84102, 12, 'fort wayne', 0, 0, 0),
(84103, 12, 'indianapolis', 0, 0, 0),
(84104, 12, 'muncie / anderson', 0, 0, 0),
(84105, 12, 'lafayette / west lafayette', 0, 0, 0),
(84106, 12, 'south bend / michiana', 0, 0, 0),
(84107, 12, 'terre haute', 0, 0, 0),
(84108, 12, 'northwest indiana', 0, 0, 0),
(84109, 13, 'ames', 0, 0, 0);

Hello, any help would be greatly appreciated. I have two dropdowns with 2 options in each. Customer picks one option from each dropdown and the form gets emailed to addresses from the two selections. The code below gives and error.

My form:
<form method="POST" action="quote.php" onsubmit="return checkform(this)">
<input type="hidden" name="agent" value="recipient_1,recipient_2">
<input type="hidden" name="office" value="recipient_3,recipient_4">
<select name="agent" id="agent">
<option value="recipient_1">Agent1 </option>
<option value="recipient_2">Agent2 </option>
</select>
<select name="office" id="office">
<option value="recipient_3">Location1  </option>
<option value="recipient_4">Location2 </option>
</select>
<input type="submit" name="submit" value="Submit">
</form>

quote.php is below:
$recipients = array(

'recipient_1' => 'email_1@yahoo.com',
'recipient_2' => 'email_2@yahoo.com',
'recipient_3' => 'email_3@yahoo.com',
'recipient_4' => 'email_4@yahoo.com',
);
$exploded_recipients = explode(",",$_REQUEST['agent']);
foreach($exploded_recipients as $value)
{
$my_email = $recipients[$value];
$success = mail($my_email, $Subject, $Body, "From: <$EmailFrom>");
}


Thanks in advance

Hi..

I have problem in getting the DemandedQty that was input. Only in the Demanded Qty of P28 items was read.

For example I input 21 in Demanded Qty of P28 and then It alerts 21, but when I input 2 in Demanded Qty of P30 the alert was 21. It means only the P28 Demanded Qty was get.

here is my code:


<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
?>
<html>
<title>Stock Requisition</title>
<head>
<link rel="stylesheet" type="text/css" href="kanban.css">


<script type="text/javascript">
function showSum(element) {
 
 var clickElement = element.value;
 var click_id = element.id; 
   
 var Table = document.getElementById('list'); 

 var rows = Table.rows;   
 
 var strSelect = document.getElementById(click_id).value;
 alert(strSelect); // i tried to alert to check if he gets the correct value, but I found that only the Demanded Qty of P28 was read. And when I try to input on another Demanded Qty like in P30 the alert was blank.
 
 for (var i = 0; i < rows.length; i++) {      
      var row = rows[i];      

    
    if (row.id.substr(0,3) == strSelect) {
    
    }
  
 
 }  
   
}
</script>

</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<div>
<table id="list">
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php

$DemandedQty = $_POST['DemandedQty'];

$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);
$rowCounter = 1;
while($row = mysql_fetch_assoc($res_bom)){
    
    $Items = $row['Items'];
    $Items_ = substr($Items, 12, 3);
    
echo "<tr>
        <td style='border: none;font-weight: bold;'>&nbsp;<input type='name' value='$Items_' name='Items_[]' id='Items_[$rowCounter]' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border:none;'>&nbsp;</td>
        <td style='border:none;'>&nbsp;</td> 
        <td style='border: none;'><center><input type='text' style='text-align: right;' name='DemandedQty[]' id='DemandedQty' value='' size='12' onkeyup ='showSum(this);'></center></td>     
        </tr>"; 
             
$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation, Quantity FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);  
 $rowCounter = 1;
 while($row_sub = mysql_fetch_assoc($res_sub)){

     $Items = $row_sub['Items'];
     //$Items_ = substr($Items, 12, 3);
     $SubItems = $row_sub['SubItems'];
     $ItemCode = $row_sub['ItemCode'];
     $UoM = $row_sub['UoM'];
     $Class = $row_sub['Class'];
     $Description = $row_sub['Description'];
     $BINLocation = $row_sub['BINLocation'];
     $Quantity = $row_sub['Quantity']; 
 
    echo "<input type='hidden' name='Quantity' id='Quantity' value='$Quantity'>";
    echo "<tr>
        <td style='border: none;'>&nbsp;<input type='hidden' value='$Items' id='Items[$rowCounter]' name='Items[]'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='SubItems[]' value='$SubItems' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='ItemCode[]' value='$ItemCode' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border: none;'><center><input type='text' name='SubQty[]' id='SubQty[$rowCounter]' value='' size='12' style='border:none;text-align: right;'></center></td>
        <td style='border: none;' size='3'>&nbsp;<input type='text' name='UoM[]' value='$UoM' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Class[]' value='$Class' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Description[]' value='$Description' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size= '30'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='BINLocation[]' value='$BINLocation' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>     
        </tr>";    
     $rowCounter = $rowCounter + 1;
}
$rowCounter = $rowCounter + 1;
} 
                 
?>
</table>
</div>
</form>
</body>
</html>



Thank you so much

I have a script that runs a query against a MySQL database, then, if it returns a resultset, it takes the 'freindly name from an array containg the database connections, then adds the data for the resultset.
Unfortunately at the minute, it doesn't quite work the way that I want.

So far I have:

//get list of servers to query, and choose them one at a time
for($a = 0; $a <sizeof($slaveRes_array); $a++)  {
$con = mysql_connect($slaveRes_array[$a]['server'], $slaveRes_array[$a]['user'], $slaveRes_array[$a]['password']); 
mysql_select_db($dbs, $con);
//get list of MySQL Queries, and run them against the current server, one at a time        
for($b = 0; $b <sizeof($query_array); $b++) {
$SlaveState = mysql_query($query_array[$b]['query1'], $con); 

// 1st Query
// If there is a resultset, get data and put into array
while($row = mysql_fetch_assoc($SlaveState)) {  
for($c = 0; $c <mysql_num_rows($SlaveState); $c++) {
$slave_array[]['name'] = $slaveRes_array[$a]['database'];
for($d = 0; $d <mysql_num_fields($SlaveState); $d++) {
$slave_array[][mysql_field_name($SlaveState,$d)] = mysql_result($SlaveState,$c,mysql_field_name($SlaveState,$d));  
}}
}
}
// Run Query2...Query3....etc.
         }


The problem is that at the minute it puts each field into a separate part of the array e.g.

Array (
        => Array ( [name] => MySQL02_5083 ) [1] => Array ( [Slave_IO_State] => Waiting for master to send event )
   [2] => Array ( [Master_Host] => localhost )
   [3] => Array ( [Master_User] => root )

Whereas what I am trying to achieve is more like:
Array (
        => Array ( [name] => MySQL02 ) [Slave_IO_State] => Waiting for master to send event )
   [Master_Host] => localhost )
   [Master_User] => root )...
           [1] => Array ( [name] => MySQL03
etc. etc.

But I can't see how to achieve this?

Can someone tell me why my php code isn't inserting users into the database. My database is made and table is made. I created a register form so my visitors can register but im getting a blank page.

I has something to do with the following code

 

$statement = $connection->prepare('INSERT INTO users (username, email, password) VALUES (:usernamebox, :emailbox, :passwordbox)');
if($statement){
$result = $statement->execute([
':usernamebox' => $data['usernamebox'],
':emailbox' => $data['emailbox'],
':passwordbox' => $data['passwordbox'],
]);

if ($result) {
$_SESSION['messages'][] = 'Thanks for registering. Check your email to confirm your email';
header('Location: register.php');
exit;
}

 

Why is there the " : "  before the usernamebox

 

Heres how my form looks like

 

<form action="register-clicked.php" method="POST">
Username:
<input type="text" name="usernamebox" placeholder="Enter Username Here">
Email:
<input type="text" name="emailbox" placeholder="Enter email here">Password:
<input type="password" name="passwordbox" placeholder="Enter password here">
Confirm Password:
<input type="password" name="passwordconfirmbox" placeholder="Re-enter password here">
<input type="submit" name="submitbox" value="Press to submit">
</form>

i wanting users to be able to update there email address and check to see if the new email already exists. if the email is the same as current email ignore the check.
i have no errors showing up but if I enter a email already in the db it still accepts the new email instead of bringing the back the error message.
Code: [Select]
// email enterd from form //
$email=$_POST['email'];


$queryuser=mysql_query("SELECT * FROM members WHERE inv='$ivn' ") or die (mysql_error());
 while($info = mysql_fetch_array( $queryuser )) {
  $check=$info['email'];
 // gets current email //
}


if($check!=$email){
// if check not equal to $email check the new email address already exists//
$queryuser=mysql_query("SELECT * FROM members WHERE email='$email' ");
//$result=mysql_query($sql);
$checkuser=mysql_num_rows($queryuser);
if($checkuser != 0)
{
$error= "0";
header('LOCATION:../pages/myprofile.php?id='.$error.'');


}
}

cheers

I'm having a problem getting my contact form information  to arrive in the desired email account. The email account itself if provided by my web host. It has the ability to send and receive emails.

The validation works perfectly eg when i type in incorrect/ miss out information it displays the appropriate error message.

When i put in the proper information it displays the "Thank you for contacting us. We will be in touch with you very soon" message but no email arrives in the specified email account.

Could someone please check over my code and see if there is something that I am missing? Its driving me mental!

Below are the html form and php codes.
Code: [Select]
<form action="send_form_email.php" method="post" >


<table width="400" border="0">


<tr>
 <td width="150" valign="top">
  <label for="first_name">*First Name:-</label>
 </td>
 <td valign="top" align="right">
  <input  type="text" name="first_name" maxlength="50" size="37">
 </td>
</tr>
 

<tr>
 <td width="150" valign="top">
  <label for="last_name">*Last Name:-</label>
 </td>
 <td valign="top" align="right">
  <input  type="text" name="last_name" maxlength="50" size="37">
</td>
</tr>


<tr>
 <td width="150" valign="top">
  <label for="email">*Email Address:-</label>
 </td>
 <td valign="top" align="right">
  <input  type="text" name="email" maxlength="50" size="37">
</td>
</tr>

<tr>
 <td width="150" valign="top">
  <label for="phone">Telephone Number:-</label>
 </td>
 <td valign="top" align="right">
  <input  type="text" name="phone" maxlength="50" size="37">
</td>
</tr>



<tr>
 <td width="150" valign="top">
  <label for="contact">Contact Time:-</label>
 </td>

 <td valign="top" align="right">
  <select name="contact">
  <option value="Anytime from 9am - 9pm!">Anytime from 9am - 9pm!</option>
  <option value="9am - 1pm">9am - 1pm</option>
  <option value="1pm - 2pm">1pm - 2pm</option>
  <option value="2pm - 6pm">2pm - 6pm</option>
  <option value="6pm - 9pm">6pm - 6pm</option>
  <option value="Please do not contact me by phone!">Please do not contact me by phone!</option>
  <option value="">_________________________________</option>
  </select>
</td>
</tr>


<tr>
 <td width="150" valign="top">
  <label for="find">How did you hear about MPM?</label>
 </td>

 <td valign="top" align="right">
  <select name="find">
  <option value="Search Engine">Search Engine</option>
  <option value="Facebook Ad">Facebook Ad</option>
  <option value="Facebook Profile">Facebook Profile</option>
  <option value="Gumtree Ad">Gumtree Ad</option>
  <option value="Recommendation">Recommendation</option>
  <option value="">_________________________________</option>
  </select>
</td>
</tr>

<tr>
 <td colspan="2" valign="top">
  <br>
 </td>
</tr>

<tr>
 <td colspan="2" valign="top">
  <label for="comments">*Enquiry:-</label>
 </td>
</tr>

<tr>
 <td colspan="2" valign="top">
<center>
  <textarea  name="comments" maxlength="1000" cols="47" rows="10"></textarea>
</center>
 </td>
</tr>

<tr>
 <td colspan="2" valign="top">
  <br>
 </td>
</tr>

<tr>
 <td colspan="2" align="center" valign="top">
  * = Required Field
 </td>
</tr>


<tr>
<td colspan="2" align="center" valign="top">
<input type="submit" value="  Send your enquiry!  " />
</td>
</tr>

</table>

</form>

Code: [Select]
<?php
if(isset($_POST['email'])) {
     
    
    $email_to = "mrpaul@mrpaulmedia.co.uk";
    $email_subject = "New customer information:";
     
     
    function died($error) {
        // your error code can go here
        echo "We are very sorry, but there were error(s) found with the form you submitted. ";
        echo "These errors appear below.<br /><br />";
        echo $error."<br /><br />";
        echo "Please go back and fix these errors.<br /><br />";
        die();
    }
     
    
    if(!isset($_POST['first_name']) ||
        !isset($_POST['last_name']) ||
        !isset($_POST['email']) ||
        !isset($_POST['phone']) ||
        !isset($_POST['contact']) ||
        !isset($_POST['find']) ||
        !isset($_POST['comments'])) {
        died('We are sorry, but there appears to be a problem with the form you submitted.');      
    }
     
    $first_name = $_POST['first_name']; // required
    $last_name = $_POST['last_name']; // required
    $email_from = $_POST['email']; // required
    $telephone = $_POST['phone']; // not required
    $contact = $_POST['contact']; // not required
    $find = $_POST['find']; // not required
    $comments = $_POST['comments']; // required
     
    $error_message = "";
   $email_exp = "^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$";
  if(!eregi($email_exp,$email_from)) {
    $error_message .= 'The Email Address you entered does not appear to be valid.<br />';
  }
    $string_exp = "^[a-z .'-]+$";
  if(!eregi($string_exp,$first_name)) {
    $error_message .= 'The First Name you entered does not appear to be valid.<br />';
  }
  if(!eregi($string_exp,$last_name)) {
    $error_message .= 'The Last Name you entered does not appear to be valid.<br />';
  }
  if(strlen($comments) < 2) {
    $error_message .= 'The Comments you entered do not appear to be valid.<br />';
  }
  if(strlen($error_message) > 0) {
    died($error_message);
  }
    $email_message = "New customer details below.\n\n";
     
    function clean_string($string) {
      $bad = array("content-type","bcc:","to:","cc:","href");
      return str_replace($bad,"",$string);
    }
     
    $email_message .= "First Name:   ".clean_string($first_name)."\n";
    $email_message .= "Last Name:   ".clean_string($last_name)."\n";
    $email_message .= "Email:   ".clean_string($email_from)."\n";
    $email_message .= "Telephone:   ".clean_string($telephone)."\n";
    $email_message .= "Preferred Time of Contact:   ".clean_string($contact)."\n";
    $email_message .= "How did the customer find out about Mr Paul Media?:   ".clean_string($find)."\n";
    $email_message .= "Comments:   ".clean_string($comments)."\n";
     
     

$headers = 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();
@mail($email_to, $email_subject, $email_message, $headers); 
?>
 

 
Thank you for contacting us. We will be in touch with you very soon.
 
<?php
}
?>



I'd be very grateful for any help!