php - MySQL - Perform JOIN from serialized array? -



php - MySQL - Perform JOIN from serialized array? -

i creating simple cart script php , mysql, , having problem figuring out fastest , efficient way perform query.

i have table called carts , table called products. carts table has column called contents contains serialized array of item numbers. these items numbers correspond pid column of products.

what looking have query pull array of info , match contents of array corresponding rows in products can echo out of matching info product.

create table `carts` ( `cart_id` int(10) not null auto_increment, `session_id` varchar(50) null default null, `contents` longtext null, `first_name` varchar(50) null default null, `last_name` varchar(50) null default null, `address` varchar(100) null default null, `city` varchar(100) null default null, `state` varchar(100) null default null, `postal` varchar(20) null default null, `country` varchar(20) null default null, primary key (`cart_id`), unique index `session_id` (`session_id`) ) collate='utf8_general_ci' engine=myisam auto_increment=7; create table `products` ( `pid` int(4) not null auto_increment, `itemtitle` varchar(100) not null, `itemnumber` varchar(10) not null, `itemdescription` longtext not null, `imgarray` longtext not null, `visibility` tinyint(1) not null, `availability` tinyint(1) not null, `itemprice` decimal(8,2) not null, `accentcolor` varchar(11) not null, primary key (`pid`) ) collate='latin1_swedish_ci' engine=myisam auto_increment=143;

sample serialized array: a:6:{i:0;s:3:"115";i:2;s:2:"82";i:4;s:2:"79";i:5;s:2:"58";i:6;s:2:"38";i:7;s:2:"85";}

while may technically possible, should not seek join on serialized column. fastest way using bridge table between cart , products. shouldn't hard modify code work off of rows in bridge table instead of single serialized field.

php mysql arrays serialization join

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more