StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMysql_error() Not Catching INSERT Error in PHP
primarykey
Id
7906373
data
AcceptedAnswerId
7906394
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-10-26T17:19:11.137
FavoriteCount
0
LastActivityDate
2011-10-26T17:26:31.770
LastEditDate
LastEditorUserId
0
OwnerUserId
1014992
ParentId
0
PostTypeId
1
Score
0
ViewCount
2162
LastEditorDisplayName
text
Body
new here and really green to programming, so go easy.. I discovered I have an <code>INSERT</code> that is failing because of a duplicate record error. I figured it out by running the query in a MySQL console with literals, where err#1062 popped up. What I want to understand is why <code>mysql_error()</code> or <code>mysql_errno()</code> didn't catch this error in my PHP script. Below is a generic setup of what I've done. I have a form that submits to a php file that calls <code>data_insert()</code> <pre><code>function data_insert($var1, $var2, $var3, $var4){ $db = db_connect(); $query = "INSERT INTO exampletable (id, id_2, id_3, id_4) VALUES ('$var1', '$var2', '$var3', '$var4')"; $result = $db->query($query); if (!$result) { echo ('Database Error:' . mysql_error()); } else { echo "Data added to db"; } } </code></pre> The DB connection: <pre><code>function db_connect() { $result = new MySQLi('localhost', 'root', 'root', 'dbname'); if (!$result) throw new Exception('Could not connect to database server'); else return $result; } </code></pre> Result I'm getting is: <pre><code>Database Error: </code></pre> PHP echos "Database Error:" because the <code>INSERT</code> fails, but no subsequent MySQL error info is echoed. Honestly, I'm not exactly sure what I'm supposed to see, but through reading some other SO questions, I've double-checked my php.ini file for error handling and E_ALL and display_errors is set appropriately (although not sure if it matters in this case). Is there something in my logic that I'm not understanding, like the scope of the link resource mysql_error() takes? Thanks for your help, I'm hoping this is something embarrassingly obvious. I know the above is missing XSS and security precautions and uniform exception handling. Baby steps though. It's simplified here for discussion's sake. 
Tags
<php><mysql>
Title
Mysql_error() Not Catching INSERT Error in PHP
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USPHPeer
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.