English 中文(简体)
Zend db 插入例外
原标题:Zend db insertion exception
  • 时间:2012-01-12 10:31:22
  •  标签:
  • php
  • zend-db

请一些机构帮助我多次核实,但我无法发现我犯过错之处。

科斯塔法[23,000]:违反诚信规定: 1062 主要指数的重复录用

这是我的法典:

$first_name = $_POST [ firstName ];
$middle_name = $_POST [ middleName ];
$last_name = $_POST [ lastName ];
$office_ph_no = $_POST [ officePhoneNumber ];
$cell_ph_no = $_POST [ cellPhoneNumber ];
$email = $_POST [ emailId ];
$supervisor_name = $_POST [ supervisorName ];
$supervisor_email = $_POST [ supervisorEmail ];
$supervisor_ph = $_POST [ supervisorPhone ];
$pass = $_POST [ password ];

$sql = $db->query ( "INSERT INTO user( user_id, title, first_name, last_name, user_identity_id, email_id, password, office_phone_number, public_id, session_id, address_id, created_by, last_modified_by, created_on, last_modified_on, is_activated, is_deprecated, middle_name, cell_phone_number, superviser_name, superviser_email, superviser_phone_number) 

VALUES ( :p_user_id, :p_title, :p_first_name, :p_last_name, :p_user_identity_id, :p_email_id, :p_password, :p_office_phone_number, :p_public_id, :p_session_id, :p_address_id, :p_created_by, :p_last_modified_by, :p_created_on, :p_last_modified_on, :p_is_activated, :p_is_deprecated, :p_middle_name, :p_cell_phone_number, :p_superviser_name, :p_superviser_email, :p_superviser_phone )",

   array (
 p_user_id  =>   ,
 p_title  => NULL,
 p_first_name  => $first_name,
 p_last_name  => $last_name,
 p_user_identity_id  =>  id ,
 p_email_id  => $email,
 p_password  => $pass,
 p_office_phone_number  => $office_ph_no,
 p_public_id  => NULL,
 p_session_id  => NULL,
 p_address_id  => NULL,
 p_created_by  => NULL,
 p_last_modified_by  => NULL,
 p_created_on  =>   ,
 p_last_modified_on  =>   ,
 p_is_activated  =>  0 ,
 p_is_deprecated  =>  0 ,
 p_middle_name  => $middle_name,
 p_cell_phone_number  => $cell_ph_no,
 p_superviser_name  => $supervisor_name,
 p_superviser_email  => $supervisor_email,
 p_superviser_phone  => $supervisor_ph 
)
最佳回答

In array the name p_ is_deprecated has a blank space.

问题回答

暂无回答




相关问题
Brute-force/DoS prevention in PHP [closed]

I am trying to write a script to prevent brute-force login attempts in a website I m building. The logic goes something like this: User sends login information. Check if username and password is ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

定值美元

如何确认来自正确来源的数字。

Generating a drop down list of timezones with PHP

Most sites need some way to show the dates on the site in the users preferred timezone. Below are two lists that I found and then one method using the built in PHP DateTime class in PHP 5. I need ...

Text as watermarking in PHP

I want to create text as a watermark for an image. the water mark should have the following properties front: Impact color: white opacity: 31% Font style: regular, bold Bevel and Emboss size: 30 ...

How does php cast boolean variables?

How does php cast boolean variables? I was trying to save a boolean value to an array: $result["Users"]["is_login"] = true; but when I use debug the is_login value is blank. and when I do ...

热门标签