Insert Strongly Typed Object into mySQL from PHP

Change line 22 into this:

$result = mysql_query($query);
if(!$result) die('Error: '.mysql_error()."<br />\nQuery: ".$query);

This will give you the mysql error, which will give more details about what is wrong.

hello coconutelegraph, ,  in your code -
$userFirstName = $tmp>userFirstName;
youleft out a -
$userFirstName = $tmp->userFirstName;

I am wondering about your use of the  VOUser()  object ? ?, you have this code -
$tmp = new VOUser();  
$tmp = $userObj;

I do not think you need to  Initialize a VOUser() object if the $userOb is a VOUser() object,
also, I wonder if the copied object is valid?
I think I would try using a passed Reference  &$userOb  for the object, instead of a Copied object as you do

public function saveUser(&$userObj) {// use a reference with &  , not a copy object
   $userID = $userObj->userID; 
   $userFirstName = $userObj->userFirstName; 
   $userLastName = $userObj->userLastName; 
   $userEmail = $userObj->userEmail; 
// other code here}
 
OR pass the data to the function, and NOT an Object
 
public function saveUser($userID, $userFirstName, $userLastName, $userEmai) {// No Object
// other code here}

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:

Slick812,
Thanks for the info. This got rid of the fault messages and fires off my resultHandler indicating the save was successful. However, upon database inspection the records are not getting added. Still digging around. Thanks again.

???, you may need to define the "Fields" that you want to insert the data into in your query statement,
I do not see why you use the  sprintf  for your query creation

below is some code That uses a more secure mysqli, you do not need to have the mysql_real_escape_string() with mysqli

$mysqli = new mysqli('localhost', 'user', 'password', 'database');
if (!mysqli_connect_errno()) {
    // define the field1, field2, field3, field4 below as the field names in your table
	$query = "INSERT INTO campaigns (field1, field2, field3, field4) VALUES (?,?,?,?)";
	$stmt = $mysqli->prepare($query);
	$stmt->bind_param("ssss", $userObj->userID, $userObj->userFirstName, $userObj->userLastName, $userObj->userEmail);
	if(!$stmt->execute()) echo 'execute has failed<br>'; else echo 'Rows Inserted '.$stmt->affected_rows.'<br>';
	$stmt->close();
	$mysqli->close();
 } else echo '<b>BIG mysqli ERROR - did NOT create the mysqli Object '.mysqli_connect_error().'</b>';

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

>> you do not need to have the mysql_real_escape_string() with mysqli

That is true if you use the mysqli::prepare() method. You can also use mysqli in the "oldfashioned" way, with mysqli::query(). In that case, you need to escape the input using mysqli::real_escape_string(), just as with the classic mysql extension.

http://php.net/manual/en/mysqli.real-escape-string.php

coconutelegraph, did you insert error checking like I suggested above? Do you get a mysql error?

cxr,
I did add the error checking but I'm not seeing any output (most likely due to my lack of experience with PHP). The file VOUser is called from Flex.

I have three seperate files for zend_amf

1.) index.php
2.) VOUser.php (user class)
3.) userService.php (which includes VOUser)

Any suggestions or workarounds? I've checked the PHP logs and they are ok. Thanks.

Sorry, I have no experience with Flex or zend_amf.

cxr,
No problem. This is a PHP/mySQL issue. The object is passed to PHP with all the right data. I've checked using Charles.

If you were testing a php file that instantiated multiple classes how would you go about testing? It seems that when I debug, the issue is that I'm unable to simulate the input of the query variables.

Thanks.