Reply to thread

Message: <blockquote data-quote="Lakshan-Seram" data-source="post: 26874022" data-attributes="member: 358904">Hadissiye liwwe podi awl athi <img src="/styles/default/xenforo/smilies/default/rolleyes.gif"  class="smilie" loading="lazy" alt=":rolleyes:" title="Rolleyes    :rolleyes:" data-shortname=":rolleyes:" />[CODE=php]<?php/** Database **/$server = 'localhost';$user = 'root';$pass = '';$db = 'elakiri';$table = 'elakiri';/** Connection **/$conn = new mysqli( $server, $user, $pass, $db );/** If the connection is okay **/if ( $conn->connect_error ) {     die( 'Connection error: ' . $conn->connect_error ); }/** Start Id **/$id = 1;/** Gettings the last id **/$query = 'SELECT user_id FROM ' . $table . ' ORDER BY id DESC LIMIT 1';$result = $conn->query( $query );if( $result->num_rows > 0 ) {     /** The selected row in database **/    $row = $result->fetch_assoc();     /** Extracting row **/    extract( $row );     /** Getting the Id in the database **/    $id_last = substr( $user_id, -4 );     /** Increment by 1 **/    $id = $id_last + 1; }/** Last digits of the current year **/$year = date( 'y' );/** Format Id **/$id_formatted = $year . sprintf( '%04d', $id );/** Final Id **/var_dump( $id_formatted ); // Do whatever with this :)/** Colsing the connection **/$conn->close();?>[/CODE][CODE=sql]DROP TABLE IF EXISTS `elakiri`;CREATE TABLE IF NOT EXISTS `elakiri` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `user_id` int(6) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;---- Dumping data for table `elakiri`--INSERT INTO `elakiri` (`id`, `user_id`) VALUES(4, 210002),(3, 210001);COMMIT;[/CODE]<hr />ah podi awlak una.. new year ekak kiyana kella mataka una lol------ Post added on [DATETIME="UT"]1631540378[/DATETIME]<hr />Update[CODE=php]<?php/** Database **/$server = 'localhost';$user = 'root';$pass = '';$db = 'elakiri';$table = 'elakiri';/** Connection **/$conn = new mysqli( $server, $user, $pass, $db );/** If the connection is okay **/if ( $conn->connect_error ) {        die( 'Connection error: ' . $conn->connect_error );    }/** Start Id **/$id = 1;/** Last digits of the current year **/$year = date( 'y' );/** Gettings the last id **/$query = 'SELECT user_id FROM ' . $table . ' ORDER BY id DESC LIMIT 1';$result = $conn->query( $query );if( $result->num_rows > 0 ) {        /** The selected row in database **/    $row = $result->fetch_assoc();        /** Extracting row **/    extract( $row );        /** Getting the Id in the database **/    $id_last = substr( $user_id, -4 );        /** Getting the year in the database **/    $year_last = substr( $user_id, 0, 2 );        if( $year == $year_last ) {                /** Increment by 1 **/        $id = ( int ) $id_last + 1;            }    }/** Format Id **/$id_formatted = $year . sprintf( '%04d', $id );/** Final Id **/var_dump( ( int ) $id_formatted ); // Do whatever with this :)/** Colsing the connection **/$conn->close();?>[/CODE][CODE=sql]DROP TABLE IF EXISTS `elakiri`;CREATE TABLE IF NOT EXISTS `elakiri` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `user_id` int(6) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;---- Dumping data for table `elakiri`--INSERT INTO `elakiri` (`id`, `user_id`) VALUES(4, 200002),(3, 200001),(5, 210001);COMMIT;[/CODE]------ Post added on [DATETIME="UT"]1631540827[/DATETIME]</blockquote>

Verification: Asuwa dahayen wadi kalama keeyada?

Top Bottom