https://devcodepro.comdevcodepro

Get last insert MySQL id using ADODB

Getting a MySQL last MySQL id from an ADODB conn

$DB->Execute('INSERT INTO mytable(posts) VALUES('.$DB->qstr($title).')');
$get_last_id = $DB->insert_id();
echo $get_last_id;

rated 21 times (20) (1)

comments: 1 / hits: 10202 / 6 years ago, thu, dec 8, 16, 06:21:29

Comments

There are no comments for this Snippet yet

Only authorized users can post. Please sign in first, or register a free account

Posted

Micky

Member since Nov 12, 2016

Total Points: 127

Total Code Snippets: 5

Total Comments: 2

Location: n/a

Micky snippets

Adodb RecordCount( ) Examples

6 years ago, thu, dec 1, 16, 6:27:26

<?php //example 1 $ra = $DB->execute('SELECT * FROM articles WHERE id = '.$DB->qstr($id).''); if(!$ra) print $DB->ErrorMsg(); else while(!$ra->EOF) { $numrows = $ra->PO_RecordCount(); echo $numrows; //$title = $ra->fields['title']; $ra->MoveNext(); } ?> <?php //example 2 $ra = $conn->Execute('SELECT * FROM articles WHERE id = '.$DB->qstr($id).''); if($ra) { if($ra->fields > 0) { $numrows = $ra->PO_RecordCount("articles"); echo $numrows; } } ?>

comments: 0 / hits: 4290

PHP

Reload / Refresh Div with jQuery

6 years ago, wed, dec 7, 16, 12:37:43

<!DOCTYPE html> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script> </head> <body> <script> $(function() { $("a.random").click(function() { $(".div1").load(location.href + " .div1"); }); }); </script> <a class="random">Click Here</a> <div class="div1"><?php echo rand(10000,50000); ?></div> </body> </html>

comments: 0 / hits: 5643

JavaScript

Syntax code highlighting phpBB 3.2

5 years ago, thu, mar 2, 17, 6:35:12

1. In /styles/YOURTEMPLATE/template/bbcode.html replace this code: <div class="codebox"><p>{L_CODE}{L_COLON} <a href="#" onclick="selectCode(this); return false;">{L_SELECT_ALL_CODE}</a></p><pre><code> with this code: <div class="codebox"><p>{L_CODE}{L_COLON} <a href="#" onclick="selectCode(this); return false;">{L_SELECT_ALL_CODE}</a></p><pre class="prettyprint"><code> 2. In styles/YOURTEMPLATE/template/overall_header.html put this code in HEAD section of the HTML <script src="https://cdn.rawgit.com/google/code-prettify/master/loader/run_prettify.js"></script> 3. Go to ACP - > Purge Cache

comments: 0 / hits: 10488

HTML, XML

Bootstrap button remove focus outline

5 years ago, thu, aug 3, 17, 2:59:59

.btn-primary.focus, .btn-primary:focus { -webkit-box-shadow: none!important; box-shadow: none!important; }

comments: 0 / hits: 14906

CSS