php - Laravel join query with json data -

-

i have products id in json format in sales table. want fetch data , need join products table product details such product name, product image,etc

here sample data sales table , orders column

[{"pcode":"r1160","qty":1,"price":"270","default_shipping":30}, {"pcode":"r1112","qty":1,"price":"250","default_shipping":30}]

now want join query products table , want products details


Comments

Post a Comment

Popular posts from this blog

PHP while loop dynamic rowspan -

-
Image
consider table example using these table wanted print table these adding rowspan item id 1002. here php code $temp_val = ''; $counter = 1; $sql_sel = mysqli_query($con,"select * item_table"); while($res_sel = mysqli_fetch_array($sql_sel)){ if($temp_val == $res_sel['item_id']){ $counter++; echo "<tr></tr>"; } else{ echo "<tr><td rowspan='".$counter."'>".$res_sel['item_id']."</td></tr>"; } $temp_val = $res_sel['item_id']; } echo "</table>"; it's not correct, it's adding rowspan item id 1003 you should switch code inside else , if statement
Read more

javascript - image slideshow using canvas HTML5 -

-
i trying create image slideshow using html5 canvas , little bit of javascript. problem following: slideshow works fading effect want first passing through image set, , after that, images drawn canvas without effect, , keeps going that. html: <canvas id="showcanvas" width='600' height='400'>canvas not supported</canvas> javascript: <script type="text/javascript"> var imagepaths = ["images/j0149014.jpg","images/j0149024.jpg","images/j0149029.jpg"]; var showcanvas = null; var showcanvasctx = null; var img = document.createelement("img"); var currentimage = 0; var revealtimer; window.onload = function (){ showcanvas = document.getelementbyid('showcanvas'); showcanvasctx = showcanvas.getcontext('2d'); img.setattribute('width','600'); img.setattribute(...
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc...
Read more