php - how to get id of unique column -

-

  1. insert article , find tags in it
  2. insert 1 tag , 1 reference 1 one know last_insert_id() of tag
$tags = array('strawberries','blueberries','food','strawberries')  function hashtaginsert($tags)      {         /// commit transaction          $lastinsertid = $this->db->lastid(); // last insert id of article          foreach ($tags $val)         {             $sql = 'insert tags (tag, added) values (:tag, now()) on duplicate key update occurrence = occurrence + 1';             $this->db->boolquery($sql, array(':tag' => $val));              $sql2 = 'insert tags_refs (article_id, tag_id) values (:lastinsertid, last_insert_id())';             $this->db->boolquery($sql2, array(':lastinsertid' => $lastinsertid));         }     }

i wrote script take care of it. , works. unfortunately there bit problem duplicities because there unique column.

if there duplicity there origin tag , don't know id has. in table after have got new reference last insert tag doesn't exist.

the tag exists reference wrong.

the db looks after first processing script:

create table `tags` (   `id` int(11) not null auto_increment,   `tag` varchar(100) not null,   `occurrence` int(11) not null,   `added` datetime not null,   primary key (`id`),   unique key `tag` (`tag`) ) engine=myisam default charset=utf8;  insert `tags` (`id`, `tag`, `occurrence`, `added`) values (18,    'boobs',    1,  '2015-05-29 16:46:44'), (20,    'food', 0,  '2015-05-29 16:46:44'), (19,    'blueberries',  0,  '2015-05-29 16:46:44');  , reference one:      drop table if exists `tags_refs`; create table `tags_refs` (   `id` int(11) not null auto_increment,   `article_id` int(11) not null,   `tag_id` int(11) not null,   primary key (`id`) ) engine=myisam default charset=utf8;  insert `tags_refs` (`id`, `article_id`, `tag_id`) values (24,    31, 18), (25,    31, 19), (26,    31, 20), (27,    31, 26);  -- 2015-05-29 14:49:55 

function hashtaginsert($tags)  {     /// commit transaction      $lastinsertid = $this->db->lastid();      foreach ($tags $val)     {         $sql = 'insert tags (tag, added) values (:tag, now()) on duplicate key update occurrence = occurrence + 1, last_article_id = :lastinsertid';         $stmt = $this->db->boolquery($sql, array(':tag' => $val,                                                  ':lastinsertid' => $lastinsertid));          if(!$stmt)         {            $sql3 = 'select id tags tag = :tag';             $existingtagid = $this->db->queryfetch($sql3, array(':tag' => $val));         }          $tagid = (isset($existingtagid)? $existingtagid : $this->db->lastid());          $sql2 = 'insert tags_refs (article_id, tag_id) values (:lastinsertid, :tagid)';         $this->db->boolquery($sql2, array(':lastinsertid' => $lastinsertid,                                           ':tagid' => $tagid));          unset($existingtagid);     } }

Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more