{"id":73,"date":"2024-02-27T12:19:35","date_gmt":"2024-02-27T04:19:35","guid":{"rendered":"https:\/\/www.beijingqingnian.com\/?p=73"},"modified":"2024-02-27T12:19:35","modified_gmt":"2024-02-27T04:19:35","slug":"php%e5%ae%9e%e7%8e%b0%e7%bd%91%e7%ab%99%e5%9b%be%e7%89%87%e6%89%b9%e9%87%8f%e5%8a%a0%e4%ba%8c%e7%bb%b4%e7%a0%81%e5%8a%9f%e8%83%bd","status":"publish","type":"post","link":"https:\/\/www.beijingqingnian.com\/index.php\/2024\/02\/27\/php%e5%ae%9e%e7%8e%b0%e7%bd%91%e7%ab%99%e5%9b%be%e7%89%87%e6%89%b9%e9%87%8f%e5%8a%a0%e4%ba%8c%e7%bb%b4%e7%a0%81%e5%8a%9f%e8%83%bd\/","title":{"rendered":"php\u5b9e\u73b0\u7f51\u7ad9\u56fe\u7247\u6279\u91cf\u52a0\u4e8c\u7ef4\u7801\u529f\u80fd"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u7f51\u7ad9\u56fe\u7247\u6279\u91cf\u6dfb\u52a0\u4e8c\u7ef4\u7801\uff0c\u76f4\u63a5\u4e0a\u4ee3\u7801<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>echo '=>start=>';\n    $sql = \"SELECT * FROM \" .$sse->table('mecine') . \" where m_id between 18101 and 18408\";\/\/18408\n    $rows = $db->getAll($sql);\n    foreach($rows as $k => $row){\n        $photos = explode(',',$row&#91;'m_photos']);\n        $photoArr = &#91;];\n        foreach($photos as $key => $photo){\n            \/\/\u56fe\u7247\u589e\u52a0\u4e8c\u7ef4\u7801\uff0c\u4fdd\u7559\u539f\u6765\u56fe\u7247\u65b0\u589e\u4e8c\u7ef4\u7801\u56fe\u7247\n    $img = getimagesize('..\/'.$photo);\n$qrimg = getimagesize('.\/template\/images\/qrcode.jpg');\n$top = $img&#91;0] - $qrimg&#91;0] - 20;\/\/\u8ddd\u79bb\u5de6\u4e0a\u89d2\u8ddd\u79bbx\n$left = $img&#91;1] - $qrimg&#91;1] - 20;\/\/\u8ddd\u79bb\u5de6\u4e0a\u89d2y\n$pct = 100;\/\/\u900f\u660e\u5ea6\n\n$imginfo = pathinfo($photo); \n$qrdir = str_replace('photo','qr_photo','..\/'.$imginfo&#91;'dirname']); \n\nif (!is_dir($qrdir)) {\n   is_dir($qrdir) or (mkdirs(dirname($qrdir)) and mkdir($qrdir,0777));\n}\n\n    picMerge('..\/'.$photo,'.\/template\/images\/qrcode.jpg',$top,$left,$pct,str_replace('photo','qr_photo','..\/'.$photo));\n $photoArr&#91;] = str_replace('photo','qr_photo', $photo);\n        }\n        $photoStr = implode(',',$photoArr);\n        \n        \/\/\u5904\u7406\u4e3b\u56fe\n        if($row&#91;'m_pic']){\n              $img = getimagesize('..\/'.$row&#91;'m_pic']);\n$qrimg = getimagesize('.\/template\/images\/qrcode.jpg');\n$top = $img&#91;0] - $qrimg&#91;0] - 20;\/\/\u8ddd\u79bb\u5de6\u4e0a\u89d2\u8ddd\u79bbx\n$left = $img&#91;1] - $qrimg&#91;1] - 20;\/\/\u8ddd\u79bb\u5de6\u4e0a\u89d2y\n$pct = 100;\/\/\u900f\u660e\u5ea6\n\n\n$imginfo = pathinfo($row&#91;'m_pic']); \n$qrdir = str_replace('mecine','qr_mecine','..\/'.$imginfo&#91;'dirname']); \n\nif (!is_dir($qrdir)) {\n   is_dir($qrdir) or (mkdirs(dirname($qrdir)) and mkdir($qrdir,0777));\n}\n\n    picMerge('..\/'.$row&#91;'m_pic'],'.\/template\/images\/qrcode.jpg',$top,$left,$pct,str_replace('medicine','qr_mecine','..\/'.$row&#91;'m_pic'])); \n    $m_pic = str_replace('mecine','qr_mecine',$row&#91;'m_pic']);\/\/\u66ff\u6362\u56fe\u7247\u5b58\u50a8\n    \n        }\n        \n        \n        \/\/\u66f4\u65b0\u6570\u636e\u5e93\n        $sql = \"update \".$GLOBALS&#91;'sse']->table('mecine').\" set m_photos = '\".$photoStr.\"',m_pic='\".$m_pic.\"' where m_id = '\".$row&#91;'m_id'].\"'\";\n    $db->query($sql);\n    del_static_cache('get_mecine_info'.$row&#91;'m_id']);\n        echo '=>end=>'.$row&#91;'m_id'];<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u7f51\u7ad9\u56fe\u7247\u6279\u91cf\u6dfb\u52a0\u4e8c\u7ef4\u7801\uff0c\u76f4\u63a5\u4e0a\u4ee3\u7801<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-73","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.beijingqingnian.com\/index.php\/wp-json\/wp\/v2\/posts\/73","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beijingqingnian.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.beijingqingnian.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.beijingqingnian.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beijingqingnian.com\/index.php\/wp-json\/wp\/v2\/comments?post=73"}],"version-history":[{"count":1,"href":"https:\/\/www.beijingqingnian.com\/index.php\/wp-json\/wp\/v2\/posts\/73\/revisions"}],"predecessor-version":[{"id":74,"href":"https:\/\/www.beijingqingnian.com\/index.php\/wp-json\/wp\/v2\/posts\/73\/revisions\/74"}],"wp:attachment":[{"href":"https:\/\/www.beijingqingnian.com\/index.php\/wp-json\/wp\/v2\/media?parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.beijingqingnian.com\/index.php\/wp-json\/wp\/v2\/categories?post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.beijingqingnian.com\/index.php\/wp-json\/wp\/v2\/tags?post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}