pass associative array into php function

Question

how to pass an associative array into php functions? i tried the code below but its not working. please help me or atleast give advice. thank you so much.

addrecord.php
require 'class.php';
$fields = array(
'strname' =>$name,
'strdescript' =>$strdescript,
'straction' =>$straction
);
$addRecord = new Record();
$addRecord->addRecord($fields);


class.php
class Record{
public $db, $sql,$stmt;
public function __construct(){
$this->db = new connection();
$this->db = $this->db->dbConnect();
}
public function addRecord($fields){
$this->sql =
"INSERT INTO user
(name,description,action)
VALUES
(?,?,?)"
$this->stmt = $this->db->prepare($this->sql);
$this->stmt->bindParam(1,{$fields['strname']},PDO::PARAM_STR);
$this->stmt->bindParam(2,{$fields['strdescript']},PDO::PARAM_STR);
$this->stmt->bindParam(3,{$fields['straction']},PDO::PARAM_STR);
$this->stmt->execute();
if($this->stmt->rowCount==1){
echo "<script>alert('blah.. blah.. blah.')</script>";
}else{ 
echo "<script>alert('blah.. blah.. blah.')</script>";
}//EndIf
}//EndFunction

gia · Accepted Answer · 2015-03-30 02:58:17Z

2

The line of code that is your question has proper usage.

syntax

$var = "{array['key']}";

to note:

the "bigger" string uses "", (because a "" string allows the use of {} for variables, and the use of '' inside ).
{} to tell php to replace with a variable's value
your array's member is the variable to use

Your error is 1) using multiple lines, for multiple lines you may do (among many other syntaxes, research them):

$var = "this " .
           "is " .
             " a string in multiple lines";

2) your sql string syntax is wrong, description is most likely a string type, strings have to be between ''

$sql = "INSERT INTO (...) VALUES ( 'my description' )"; //you lack these 's, put them

answered Mar 30, 2015 at 2:58

gia

7575 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

gia Over a year ago

btw, since you can do prepared statements, try to use them all the time, because they'll be safe from SQL injections (hackers) as opposed to building the sql string like on my answer.

Deepak Keynes · Accepted Answer · 2021-02-13 04:44:45Z

0

For passing an empty associative array, do the following:

$result['data'] = array('content_id'=>'','user_id'=>'','title' =>'','content' =>'');

answered Feb 13, 2021 at 4:44

Deepak Keynes

2,3597 gold badges31 silver badges61 bronze badges

Collectives™ on Stack Overflow

pass associative array into php function

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related