 PHP×MySQLランキングナビを自作しました 無能投資家の苦悩;mask-image:urldata:imagesvgxml;utf8,;mask-mode:alpha;-webkit-mask-repeat:no-repeat;mask-repeat:no-repeat;-webkit-mask-size:contain;mask-size:contain;-webkit-mask-position:center;mask-position:center;border-radius:0.wp-block-latest-comments__commentfont-size:15px;line-height:1.1;list-style:none;margin-bottom:1em.has-avatars .wp-block-latest-comments__commentmin-height:36px;list-style:none.has-avatars .wp-block-latest-comments__comment .wp-block-latest-comments__comment-excerpt,.has-avatars .wp-block-latest-comments__comment .wp-block-latest-comments__comment-metamargin-left:52px.has-dates .wp-block-latest-comments__comment,.has-excerpts .wp-block-latest-comments__commentline-height:1.5.wp-block-latest-comments__comment-excerpt pfont-size:14px;line-height:1.8;margin:5px 0 20px.wp-block-latest-comments__comment-datecolor:8f98a1;display:block;font-size:12px.wp-block-latest-comments .avatar,.wp-block-latest-comments__comment-avatarborder-radius:24px;display:block;float:left;height:40px;margin-right:12px;width:40px.wp-block-latest-posts.alignleftmargin-right:2em.wp-block-latest-posts.alignrightmargin-left:2em.wp-block-latest-posts.wp-block-latest-posts__listlist-style:none.wp-block-latest-posts.wp-block-latest-posts__list liclear:both.wp-block-latest-posts.is-griddisplay:flex;flex-wrap:wrap;padding:0.wp-block-latest-posts.is-grid limargin:0 16px 16px 0;width:100media min-width:600px.wp-block-latest-posts.columns-2 liwidth:calc50 - 16px.wp-block-latest-posts.columns-3 liwidth:calc33.33333 - 16px.wp-block-latest-posts.columns-4 liwidth:calc25 - 16px.wp-block-latest-posts.columns-5 liwidth:calc20 - 16px.wp-block-latest-posts.columns-6 liwidth:calc16.66667 - 16px.wp-block-latest-posts__post-datedisplay:block;color:6c7781;font-size:13px.wp-block-latest-posts__post-excerptmargin-top:8px;margin-bottom:16px.wp-block-latest-posts__featured-image imgheight:auto;width:auto.wp-block-latest-posts__featured-image.alignleftmargin-right:1em.wp-block-latest-posts__featured-image.alignrightmargin-left:1em.wp-block-latest-posts__featured-image.aligncentermargin-bottom:1em;text-align:center.wp-block-media-textdirection:ltr;display:-ms-grid;display:grid;-ms-grid-columns:50 1fr;grid-template-columns:50 1fr;-ms-grid-rows:auto;grid-template-rows:auto.wp-block-media-text.has-media-on-the-right-ms-grid-columns:1fr 50;grid-template-columns:1fr 50.wp-block-media-text.is-vertically-aligned-top .wp-block-media-text__content,.wp-block-media-text.is-vertically-aligned-top .wp-block-media-text__media-ms-grid-row-align:start;align-self:start.wp-block-media-text.is-vertically-aligned-center .wp-block-media-text__content,.wp-block-media-text.is-vertically-aligned-center .wp-block-media-text__media,.wp-block-media-text .wp-block-media-text__content,.wp-block-media-text .wp-block-media-text__media-ms-grid-row-align:center;align-self:center.wp-block-media-text.is-vertically-aligned-bottom .wp-block-media-text__content,.wp-block-media-text.is-vertically-aligned-bottom .wp-block-media-text__media-ms-grid-row-align:end;align-self:end.wp-block-media-text .wp-block-media-text__media-ms-grid-column:1;grid-column:1;-ms-grid-row:1;grid-row:1;margin:0.wp-block-media-text .wp-block-media-text__contentdirection:ltr;-ms-grid-column:2;grid-column:2;-ms-grid-row:1;grid-row:1;padding:0 8;word-break:break-word.wp-block-media-text.has-media-on-the-right .wp-block-media-text__media-ms-grid-column:2;grid-column:2;-ms-grid-row:1;grid-row:1.wp-block-media-text.has-media-on-the-right .wp-block-media-text__content-ms-grid-column:1;grid-column:1;-ms-grid-row:1;grid-row:1.wp-block-media-textfigureimg,.wp-block-media-textfigurevideomax-width:unset;width:100;vertical-align:middle.wp-block-media-text.is-image-fill figure.wp-block-media-text__mediaheight:100;min-height:250px;background-size:cover.wp-block-media-text.is-image-fill figure.wp-block-media-text__mediaimgposition:absolute;width:1px;height:1px;padding:0;margin:-1px;overflow:hidden;clip:rect0,0,0,0;border:0media max-width:600px.wp-block-media-text.is-stacked-on-mobile-ms-grid-columns:100!important;grid-template-columns:100!important.wp-block-media-text.is-stacked-on-mobile .wp-block-media-text__media-ms-grid-column:1;grid-column:1;-ms-grid-row:1;grid-row:1.wp-block-media-text.is-stacked-on-mobile.has-media-on-the-right .wp-block-media-text__media,.wp-block-media-text.is-stacked-on-mobile .wp-block-media-text__content-ms-grid-column:1;grid-column:1;-ms-grid-row:2;grid-row:2.wp-block-media-text.is-stacked-on-mobile.has-media-on-the-right .wp-block-media-text__content-ms-grid-column:1;grid-column:1;-ms-grid-row:1;grid-row:1.wp-block-navigationuldisplay:block;list-style:none;margin:0;padding-left:0media min-width:600px.wp-block-navigationuldisplay:flex;flex-wrap:wrap.wp-block-navigationul ullist-style:none;padding-left:0;margin-top:0;margin-left:0.wp-block-navigationul ul limargin:0.wp-block-navigationul liz-index:1.wp-block-navigationul li:focus-within,.wp-block-navigationul li:hovercursor:pointer;z-index:99999.wp-block-navigationul li:focus-withinul,.wp-block-navigationul li:hoverul,.wp-block-navigationul li ul:focus,.wp-block-navigationul li ul:hovervisibility:visible;opacity:1;display:flex;flex-direction:column.wp-block-navigationulli ulposition:absolute;left:0;top:100;min-width:200px;max-width:200px;opacity:0;transition:opacity .1s linear;visibility:hidden.wp-block-navigation,.wp-block-navigation .block-editor-block-list__layoutdisplay:flex;flex-wrap:wrap.wp-block-navigation .block-editor-block-list__layout .block-editor-block-list__layoutwidth:200px.wp-block-navigation .block-editor-inner-blocks.block-editor-block-list__layout.wp-blockmargin:0;width:auto.wp-block-navigation,.wp-block-navigation.wp-block-navigation__containeralign-items:center;width:100.wp-block-navigation.wp-block-navigation-link,.wp-block-navigation.wp-block-navigation__container.wp-block-navigation-linkdisplay:flex;margin-top:0;margin-bottom:0.wp-block-navigation .wp-block-navigation-linkposition:relative;margin:0;min-height:56px;display:flex;line-height:1.4.wp-block-navigation .wp-block-navigation-link .wp-block,.wp-block-navigation .wp-block-navigation-link .wp-block-navigation-linkmin-height:auto;padding:0.wp-block-navigation .wp-block-navigation-link .wp-block .wp-block-navigation-linkmargin:0.wp-block-navigation .wp-block-navigation-link.block-editor-inner-blocksdisplay:none.wp-block-navigation .wp-block-navigation-link.has-child.wp-block-navigation__container,.wp-block-navigation .wp-block-navigation-link.is-editing.has-child.block-editor-inner-blocksdisplay:flex;border:1px solid rgba0,0,0,.15;position:absolute;z-index:1;top:100;left:0.wp-block-navigation .wp-block-navigation-link.has-child.wp-block-navigation__container .block-editor-inner-blocks,.wp-block-navigation .wp-block-navigation-link.has-child.wp-block-navigation__container .wp-block-navigation__container,.wp-block-navigation .wp-block-navigation-link.is-editing.has-child.block-editor-inner-blocks .block-editor-inner-blocks,.wp-block-navigation .wp-block-navigation-link.is-editing.has-child.block-editor-inner-blocks .wp-block-navigation__containerleft:100;top:-1px.wp-block-navigation .wp-block-navigation-link .block-editor-inner-blocks,.wp-block-navigation .wp-block-navigation-link .wp-block-navigation__containerbackground-color:inherit;color:inherit.wp-block-navigation .wp-block-navigation-link .wp-block-navigation-link__contentdisplay:flex;align-items:center;width:max-content;padding:6px 16px.wp-block-navigation .wp-block-navigation-link .wp-block-navigation-link:first-child:not:only-child .wp-block-navigation-link__contentpadding-top:8px.wp-block-navigation .wp-block-navigation-link .wp-block-navigation-link:last-child .wp-block-navigation-link__contentpadding-bottom:8px.wp-block-navigation .wp-block-navigation-link.has-child .wp-block-navigation-link__contentmin-width:100;padding-right:32px;position:relative.wp-block-navigation .wp-block-navigation-link .wp-block-navigation-link__submenu-iconposition:absolute;right:16px.wp-block-navigation .wp-block-navigation-link .wp-block-navigation-link__submenu-icon svgfill:currentColor.wp-block-navigation .wp-block-navigation-link .wp-block-navigation-link svgtransform:rotate0.wp-block-navigation .wp-block-navigation-link.has-text-color .wp-block-navigation-link__contentcolor:inherit.wp-block-navigation.is-style-light .wp-block-navigation-link:not.has-text-color.block-editor-inner-blocks,.wp-block-navigation.is-style-light .wp-block-navigation-link:not.has-text-color.wp-block-navigation__container,.wp-block-navigation .wp-block-navigation-link:not.has-text-color.block-editor-inner-blocks,.wp-block-navigation .wp-block-navigation-link:not.has-text-color.wp-block-navigation__containercolor:111.wp-block-navigation.is-style-light .wp-block-navigation-link:not.has-background.block-editor-inner-blocks,.wp-block-navigation.is-style-light .wp-block-navigation-link:not.has-background.wp-block-navigation__container,.wp-block-navigation .wp-block-navigation-link:not.has-background.block-editor-inner-blocks,.wp-block-navigation .wp-block-navigation-link:not.has-background.wp-block-navigation__containerbackground-color:fff.wp-block-navigation.is-style-dark .wp-block-navigation-link:not.has-text-color.block-editor-inner-blocks,.wp-block-navigation.is-style-dark .wp-block-navigation-link:not.has-text-color.wp-block-navigation__containercolor:fff.wp-block-navigation.is-style-dark .wp-block-navigation-link:not.has-background.block-editor-inner-blocks,.wp-block-navigation.is-style-dark .wp-block-navigation-link:not.has-background.wp-block-navigation__containerbackground-color:333.wp-block-navigation .wp-block-navigation-link.has-child.wp-block-navigation__containerdisplay:flex;flex-direction:column;padding:0.wp-block-navigationulliadisplay:flex;align-items:center.wp-block-navigationulli:first-of-typeapadding-left:0.wp-block-navigationulli:last-of-typeapadding-right:0.wp-block-navigation.items-justified-leftuljustify-content:flex-start.wp-block-navigation.items-justified-centeruljustify-content:center.wp-block-navigation.items-justified-rightuljustify-content:flex-end.is-small-textfont-size:14px.is-regular-textfont-size:16px.is-large-textfont-size:36px.is-larger-textfont-size:48px.has-drop-cap:not:focus:first-letterfloat:left;font-size:8.4em;line-height:.68;font-weight:100;margin:.05em .1em 0 0;text-transform:uppercase;font-style:normalp.has-backgroundpadding:20px 30pxp.has-text-color acolor:inherit.wp-block-pullquotepadding:3em 0;margin-left:0;margin-right:0;text-align:center.wp-block-pullquote.alignleft,.wp-block-pullquote.alignrightmax-width:290px.wp-block-pullquote.alignleft p,.wp-block-pullquote.alignright pfont-size:20px.wp-block-pullquote pfont-size:28px;line-height:1.6.wp-block-pullquote cite,.wp-block-pullquote footerposition:relative.wp-block-pullquote .has-text-color acolor:inherit.wp-block-pullquote:not.is-style-solid-colorbackground:0 0.wp-block-pullquote.is-style-solid-colorborder:0.wp-block-pullquote.is-style-solid-color blockquotemargin-left:auto;margin-right:auto;text-align:left;max-width:60.wp-block-pullquote.is-style-solid-color blockquote pmargin-top:0;margin-bottom:0;font-size:32px.wp-block-pullquote.is-style-solid-color blockquote citetext-transform:none;font-style:normal.wp-block-pullquote citecolor:inherit.wp-block-quote.is-large,.wp-block-quote.is-style-largemargin:0 0 16px;padding:0 1em.wp-block-quote.is-large p,.wp-block-quote.is-style-large pfont-size:24px;font-style:italic;line-height:1.6.wp-block-quote.is-large cite,.wp-block-quote.is-large footer,.wp-block-quote.is-style-large cite,.wp-block-quote.is-style-large footerfont-size:18px;text-align:right.wp-block-rss.alignleftmargin-right:2em.wp-block-rss.alignrightmargin-left:2em.wp-block-rss.is-griddisplay:flex;flex-wrap:wrap;padding:0;list-style:none.wp-block-rss.is-grid limargin:0 16px 16px 0;width:100media min-width:600px.wp-block-rss.columns-2 liwidth:calc50 - 16px.wp-block-rss.columns-3 liwidth:calc33.33333 - 16px.wp-block-rss.columns-4 liwidth:calc25 - 16px.wp-block-rss.columns-5 liwidth:calc20 - 16px.wp-block-rss.columns-6 liwidth:calc16.66667 - 16px.wp-block-rss__item-author,.wp-block-rss__item-publish-datedisplay:block;color:6c7781;font-size:13px.wp-block-searchdisplay:flex;flex-wrap:wrap.wp-block-search .wp-block-search__labelwidth:100.wp-block-search .wp-block-search__inputflex-grow:1;max-width:360px.wp-block-search .wp-block-search__buttonmargin-left:10px.wp-block-separator.is-style-wideborder-bottom-width:1px.wp-block-separator.is-style-dotsbackground:none!important;border:0;text-align:center;max-width:none;line-height:1;height:auto.wp-block-separator.is-style-dots:beforecontent:00b7 00b7 00b7;color:currentColor;font-size:20px;letter-spacing:2em;padding-left:2em;font-family:serif.wp-block-social-linksdisplay:flex;justify-content:flex-start;padding-left:0;padding-right:0;margin-left:0.wp-block-social-links .wp-social-link a,.wp-block-social-links .wp-social-link a:hovertext-decoration:none;border-bottom:0;box-shadow:none.wp-social-linkdisplay:block;width:36px;height:36px;border-radius:36px;margin-right:8px;transition:transform .1s easemedia prefers-reduced-motion:reduce.wp-social-linktransition-duration:0s.wp-social-link apadding:6px;display:block;line-height:0;transition:transform .1s ease.wp-social-link a,.wp-social-link a:active,.wp-social-link a:hover,.wp-social-link a:visited,.wp-social-link svgcolor:currentColor;fill:currentColor.wp-social-link:hovertransform:scale1.1.wp-block-social-links.aligncenterjustify-content:center;display:flex.wp-block-social-links:not.is-style-logos-only .wp-social-linkbackground-color:f0f0f0;color:444.wp-block-social-links:not.is-style-logos-only .wp-social-link-amazonbackground-color:f90;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-bandcampbackground-color:1ea0c3;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-behancebackground-color:0757fe;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-codepenbackground-color:1e1f26;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-deviantartbackground-color:02e49b;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-dribbblebackground-color:e94c89;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-dropboxbackground-color:4280ff;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-etsybackground-color:f45800;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-facebookbackground-color:1977f2;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-fivehundredpxbackground-color:000;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-flickrbackground-color:0461dd;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-foursquarebackground-color:e65678;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-githubbackground-color:24292d;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-goodreadsbackground-color:eceadd;color:382110.wp-block-social-links:not.is-style-logos-only .wp-social-link-googlebackground-color:ea4434;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-instagrambackground-color:f00075;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-lastfmbackground-color:e21b24;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-linkedinbackground-color:0577b5;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-mastodonbackground-color:3288d4;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-mediumbackground-color:02ab6c;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-meetupbackground-color:f6405f;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-pinterestbackground-color:e60122;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-pocketbackground-color:ef4155;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-redditbackground-color:fe4500;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-skypebackground-color:0478d7;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-snapchatbackground-color:fefc00;color:fff;stroke:000.wp-block-social-links:not.is-style-logos-only .wp-social-link-soundcloudbackground-color:ff5600;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-spotifybackground-color:1bd760;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-tumblrbackground-color:011835;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-twitchbackground-color:6440a4;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-twitterbackground-color:21a1f3;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-vimeobackground-color:1eb7ea;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-vkbackground-color:4680c2;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-wordpressbackground-color:3499cd;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-yelpbackground-color:d32422;color:fff.wp-block-social-links:not.is-style-logos-only .wp-social-link-youtubebackground-color:ff0100;color:fff.wp-block-social-links.is-style-logos-only .wp-social-linkbackground:0 0;padding:4px.wp-block-social-links.is-style-logos-only .wp-social-link svgwidth:28px;height:28px.wp-block-social-links.is-style-logos-only .wp-social-link-amazoncolor:f90.wp-block-social-links.is-style-logos-only .wp-social-link-bandcampcolor:1ea0c3.wp-block-social-links.is-style-logos-only .wp-social-link-behancecolor:0757fe.wp-block-social-links.is-style-logos-only .wp-social-link-codepencolor:1e1f26.wp-block-social-links.is-style-logos-only .wp-social-link-deviantartcolor:02e49b.wp-block-social-links.is-style-logos-only .wp-social-link-dribbblecolor:e94c89.wp-block-social-links.is-style-logos-only .wp-social-link-dropboxcolor:4280ff.wp-block-social-links.is-style-logos-only .wp-social-link-etsycolor:f45800.wp-block-social-links.is-style-logos-only .wp-social-link-facebookcolor:1977f2.wp-block-social-links.is-style-logos-only .wp-social-link-fivehundredpxcolor:000.wp-block-social-links.is-style-logos-only .wp-social-link-flickrcolor:0461dd.wp-block-social-links.is-style-logos-only .wp-social-link-foursquarecolor:e65678.wp-block-social-links.is-style-logos-only .wp-social-link-githubcolor:24292d.wp-block-social-links.is-style-logos-only .wp-social-link-goodreadscolor:382110.wp-block-social-links.is-style-logos-only .wp-social-link-googlecolor:ea4434.wp-block-social-links.is-style-logos-only .wp-social-link-instagramcolor:f00075.wp-block-social-links.is-style-logos-only .wp-social-link-lastfmcolor:e21b24.wp-block-social-links.is-style-logos-only .wp-social-link-linkedincolor:0577b5.wp-block-social-links.is-style-logos-only .wp-social-link-mastodoncolor:3288d4.wp-block-social-links.is-style-logos-only .wp-social-link-mediumcolor:02ab6c.wp-block-social-links.is-style-logos-only .wp-social-link-meetupcolor:f6405f.wp-block-social-links.is-style-logos-only .wp-social-link-pinterestcolor:e60122.wp-block-social-links.is-style-logos-only .wp-social-link-pocketcolor:ef4155.wp-block-social-links.is-style-logos-only .wp-social-link-redditcolor:fe4500.wp-block-social-links.is-style-logos-only .wp-social-link-skypecolor:0478d7.wp-block-social-links.is-style-logos-only .wp-social-link-snapchatcolor:fff;stroke:000.wp-block-social-links.is-style-logos-only .wp-social-link-soundcloudcolor:ff5600.wp-block-social-links.is-style-logos-only .wp-social-link-spotifycolor:1bd760.wp-block-social-links.is-style-logos-only .wp-social-link-tumblrcolor:011835.wp-block-social-links.is-style-logos-only .wp-social-link-twitchcolor:6440a4.wp-block-social-links.is-style-logos-only .wp-social-link-twittercolor:21a1f3.wp-block-social-links.is-style-logos-only .wp-social-link-vimeocolor:1eb7ea.wp-block-social-links.is-style-logos-only .wp-social-link-vkcolor:4680c2.wp-block-social-links.is-style-logos-only .wp-social-link-wordpresscolor:3499cd.wp-block-social-links.is-style-logos-only .wp-social-link-yelpbackground-color:d32422;color:fff.wp-block-social-links.is-style-logos-only .wp-social-link-youtubecolor:ff0100.wp-block-social-links.is-style-pill-shape .wp-social-linkwidth:auto.wp-block-social-links.is-style-pill-shape .wp-social-link apadding-left:16px;padding-right:16px.wp-block-spacerclear:bothp.wp-block-subheadfont-size:1.1em;font-style:italic;opacity:.75.wp-block-tableoverflow-x:auto.wp-block-table tablewidth:100.wp-block-table .has-fixed-layouttable-layout:fixed;width:100.wp-block-table .has-fixed-layout td,.wp-block-table .has-fixed-layout thword-break:break-word.wp-block-table.aligncenter,.wp-block-table.alignleft,.wp-block-table.alignrightdisplay:table;width:auto.wp-block-table.aligncenter td,.wp-block-table.aligncenter th,.wp-block-table.alignleft td,.wp-block-table.alignleft th,.wp-block-table.alignright td,.wp-block-table.alignright thword-break:break-word.wp-block-table .has-subtle-light-gray-background-colorbackground-color:f3f4f5.wp-block-table .has-subtle-pale-green-background-colorbackground-color:e9fbe5.wp-block-table .has-subtle-pale-blue-background-colorbackground-color:e7f5fe.wp-block-table .has-subtle-pale-pink-background-colorbackground-color:fcf0ef.wp-block-table.is-style-stripesborder-spacing:0;border-collapse:inherit;background-color:transparent;border-bottom:1px solid f3f4f5.wp-block-table.is-style-stripes tbody tr:nth-childoddbackground-color:f3f4f5.wp-block-table.is-style-stripes.has-subtle-light-gray-background-color tbody tr:nth-childoddbackground-color:f3f4f5.wp-block-table.is-style-stripes.has-subtle-pale-green-background-color tbody tr:nth-childoddbackground-color:e9fbe5.wp-block-table.is-style-stripes.has-subtle-pale-blue-background-color tbody tr:nth-childoddbackground-color:e7f5fe.wp-block-table.is-style-stripes.has-subtle-pale-pink-background-color tbody tr:nth-childoddbackground-color:fcf0ef.wp-block-table.is-style-stripes td,.wp-block-table.is-style-stripes thborder-color:transparent.wp-block-text-columns,.wp-block-text-columns.aligncenterdisplay:flex.wp-block-text-columns .wp-block-columnmargin:0 16px;padding:0.wp-block-text-columns .wp-block-column:first-childmargin-left:0.wp-block-text-columns .wp-block-column:last-childmargin-right:0.wp-block-text-columns.columns-2 .wp-block-columnwidth:50.wp-block-text-columns.columns-3 .wp-block-columnwidth:33.33333.wp-block-text-columns.columns-4 .wp-block-columnwidth:25.wp-block-videomargin-left:0;margin-right:0.wp-block-video videomax-width:100supports position:-webkit-sticky or position:sticky.wp-block-video posterobject-fit:cover.wp-block-video.aligncentertext-align:center.wp-block-video figcaptionmargin-top:.5em;margin-bottom:1em:root .has-pale-pink-background-colorbackground-color:f78da7:root .has-vivid-red-background-colorbackground-color:cf2e2e:root .has-luminous-vivid-orange-background-colorbackground-color:ff6900:root .has-luminous-vivid-amber-background-colorbackground-color:fcb900:root .has-light-green-cyan-background-colorbackground-color:7bdcb5:root .has-vivid-green-cyan-background-colorbackground-color:00d084:root .has-pale-cyan-blue-background-colorbackground-color:8ed1fc:root .has-vivid-cyan-blue-background-colorbackground-color:0693e3:root .has-vivid-purple-background-colorbackground-color:9b51e0:root .has-very-light-gray-background-colorbackground-color:eee:root .has-cyan-bluish-gray-background-colorbackground-color:abb8c3:root .has-very-dark-gray-background-colorbackground-color:313131:root .has-pale-pink-colorcolor:f78da7:root .has-vivid-red-colorcolor:cf2e2e:root .has-luminous-vivid-orange-colorcolor:ff6900:root .has-luminous-vivid-amber-colorcolor:fcb900:root .has-light-green-cyan-colorcolor:7bdcb5:root .has-vivid-green-cyan-colorcolor:00d084:root .has-pale-cyan-blue-colorcolor:8ed1fc:root .has-vivid-cyan-blue-colorcolor:0693e3:root .has-vivid-purple-colorcolor:9b51e0:root .has-very-light-gray-colorcolor:eee:root .has-cyan-bluish-gray-colorcolor:abb8c3:root .has-very-dark-gray-colorcolor:313131:root .has-vivid-cyan-blue-to-vivid-purple-gradient-backgroundbackground:linear-gradient135deg,0693e3,9b51e0:root .has-vivid-green-cyan-to-vivid-cyan-blue-gradient-backgroundbackground:linear-gradient135deg,00d084,0693e3:root .has-light-green-cyan-to-vivid-green-cyan-gradient-backgroundbackground:linear-gradient135deg,7adcb4,00d082:root .has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-backgroundbackground:linear-gradient135deg,fcb900,ff6900:root .has-luminous-vivid-orange-to-vivid-red-gradient-backgroundbackground:linear-gradient135deg,ff6900,cf2e2e:root .has-very-light-gray-to-cyan-bluish-gray-gradient-backgroundbackground:linear-gradient135deg,eee,a9b8c3:root .has-cool-to-warm-spectrum-gradient-backgroundbackground:linear-gradient135deg,4aeadc,9778d1 20,cf2aba 40,ee2c82 60,fb6962 80,fef84c:root .has-blush-light-purple-gradient-backgroundbackground:linear-gradient135deg,ffceec,9896f0:root .has-blush-bordeaux-gradient-backgroundbackground:linear-gradient135deg,fecda5,fe2d2d 50,6b003e:root .has-purple-crush-gradient-backgroundbackground:linear-gradient135deg,34e2e4,4721fb 50,ab1dfe:root .has-luminous-dusk-gradient-backgroundbackground:linear-gradient135deg,ffcb70,c751c0 50,4158d0:root .has-hazy-dawn-gradient-backgroundbackground:linear-gradient135deg,faaca8,dad0ec:root .has-pale-ocean-gradient-backgroundbackground:linear-gradient135deg,fff5cb,b6e3d4 50,33a7b5:root .has-electric-grass-gradient-backgroundbackground:linear-gradient135deg,caf880,71ce7e:root .has-subdued-olive-gradient-backgroundbackground:linear-gradient135deg,fafae1,67a671:root .has-atomic-cream-gradient-backgroundbackground:linear-gradient135deg,fdd79a,004a59:root .has-nightshade-gradient-backgroundbackground:linear-gradient135deg,330968,31cdcf:root .has-midnight-gradient-backgroundbackground:linear-gradient135deg,020381,2874fc.has-small-font-sizefont-size:13px.has-normal-font-size,.has-regular-font-sizefont-size:16px.has-medium-font-sizefont-size:20px.has-large-font-sizefont-size:36px.has-huge-font-size,.has-larger-font-sizefont-size:42px.has-text-align-centertext-align:center.has-text-align-lefttext-align:left.has-text-align-righttext-align:rightdiv.wpcf7 .screen-reader-responseposition:absolute;overflow:hidden;clip:rect1px,1px,1px,1px;height:1px;width:1px;margin:0;padding:0;border:0div.wpcf7-response-outputmargin:2em .5em 1em;padding:.2em 1em;border:2px solid f00div.wpcf7-mail-sent-okborder:2px solid 398f14div.wpcf7-mail-sent-ng,div.wpcf7-abortedborder:2px solid f00div.wpcf7-spam-blockedborder:2px solid ffa500div.wpcf7-validation-errors,div.wpcf7-acceptance-missingborder:2px solid f7e700.wpcf7-form-control-wrapposition:relativespan.wpcf7-not-valid-tipcolor:f00;font-size:1em;font-weight:normal;display:block.use-floating-validation-tip span.wpcf7-not-valid-tipposition:absolute;top:20;left:20;z-index:100;border:1px solid f00;background:fff;padding:.2em .8emspan.wpcf7-list-itemdisplay:inline-block;margin:0 0 0 1emspan.wpcf7-list-item-label::before,span.wpcf7-list-item-label::aftercontent: .wpcf7-display-nonedisplay:nonediv.wpcf7 .ajax-loadervisibility:hidden;display:inline-block;background-image:url 0 0 4px;vertical-align:middlediv.wpcf7 .ajax-loader.is-activevisibility:visiblediv.wpcf7 div.ajax-errordisplay:nonediv.wpcf7 .placeheldcolor:888div.wpcf7 inputtypefilecursor:pointerdiv.wpcf7 inputtypefile:disabledcursor:defaultdiv.wpcf7 .wpcf7-submit:disabledcursor:not-allowed.wpcf7 inputtypeurl,.wpcf7 inputtypeemail,.wpcf7 inputtypeteldirection:ltr.page-id-21 .sns-share,.page-id-21 .sns-follow,.page-id-33 .sns-share,.page-id-33 .sns-follow,.page-id-129 .sns-share,.page-id-129 .sns-followdisplay:none.widget_categories ul li aborder-bottom:1px dashed CCC;.widget_categories ul li a::beforefont-family:Font Awesome 5 Free;font-weight:900;content:f07b;color:5FB3F5;padding-right:6px.widget_categoriesullia:first-childborder-top:none.widget_categories ul li ul li a::beforefont-family:Font Awesome 5 Free;font-weight:900;content:f15c;color:5FB3F5;padding-right:6px.widget_categories ul li aline-height:1.3.caption-wrap:hoverfont-weight:bold;color:ffbc00;border-bottom:3px solid ffd400.rank-add,.rank-rmbackground-color:ff9.rank-upbackground-color:d1e8d9.rank-downbackground-color:f8dadbtd.upcolor:093td.staycolor:a6a6a6td.downcolor:ff333adiv.inlinedisplay:inline-block;_display:inline.easyLink-info-btn-amazonbackground:F90!important.easyLink-info-btn-rakutenbackground:BF0000!important.easyLink-info-btn-yahoobackground:FF0027!importantweatherbackground:linear-gradienttransparent 60,ff6 60.rankingpadding:2px 8px;background:F5DEB3.ranking-contentsfont-size:small;font-weight:bold.ranking ul-webkit-flex-direction:column;flex-direction:column;list-style-type:none;margin:0;padding:0.rank-top li adisplay:block;margin:5px 0 12px;padding:.8em;background:FFF;border-left:solid 10px 093;color:000;box-shadow:0 3px 3px rgba0,0,0,.3;background-image:linear-gradientto right,rgba0,0,0,0 50,093 50;background-size:200 auto;background-position:0 0;transition:all .3s ease 0s;text-decoration:none.rank-top li a:hovercursor:pointer;background-position:-100 0;color:fff.rank-bottom li adisplay:block;margin:5px 0 12px;padding:.8em;background:FFF;border-left:solid 10px ff333a;color:000;box-shadow:0 3px 3px rgba0,0,0,.3;background-image:linear-gradientto right,rgba0,0,0,0 50,ff333a 50;background-size:200 auto;background-position:0 0;transition:all .3s ease 0s;text-decoration:none.rank-bottom li a:hovercursor:pointer;background-position:-100 0;color:fff.rank-titlefont-weight:bold;float:left.rank-numfloat:left;background:linear-gradienttransparent 60,a8dafb 60.rank-datetext-align:right;.rank-up-colorcolor:093.rank-down-colorcolor:ff333a.badge-wincolor:fff;padding:1px 5px 0;border-radius:2px;font-size:12px;background-color:093.badge-losecolor:fff;padding:1px 5px 0;border-radius:2px;font-size:12px;background-color:ff333adiv.psy_navfont-size:83.fa-kunou:beforecontent:;height:1.5em;background:url no-repeat centercontain;display:block.fa-heartcolor:E3274D;-webkit-font-smoothing:antialiased;-webkit-text-stroke-color:E3274D;-webkit-text-stroke-width:1.5px.mobile-menu-buttonscolor:000;background-color:fff4;.sns-share-message-mobile,.sns-follow-message-mobilepadding:3px;font-size:18px;text-align:center;color:fff;font-weight:bold.share-menu-content .sns-share-buttons a,.follow-menu-content .sns-follow-buttons awidth:100.share-menu-content,.follow-menu-contenttop:initial;bottom:20media screen and max-width:1023px.logo-header,.taglinedisplay:noneshare-menu-input:checkedshare-menu-close,follow-menu-input:checkedfollow-menu-closedisplay:block;opacity:.8.home main,.archive mainbackground-color:transparent;margin-top:0;padding-top:0.entry-card-wrapbackground-color:fff;border-radius:4px;margin-bottom:1em!important;box-shadow:0 10px 20px -5px rgba0,0,0,.2;transition:all .3s ease.entry-card-wrap:hoverbox-shadow:none;transform:translateY2px;background-color:white.entry-card-wrapbackground-color:fff;border-radius:4px;margin-bottom:1em!important;box-shadow:0 10px 20px -5px rgba0,0,0,.2;transition:all .3s ease.a-wrappadding:2.card-thumb imgborder-radius:4px;box-shadow:0 2px 4px -1px rgba0,0,0,.2.eye-catch imgborder-radius:4px;box-shadow:0 2px 4px -1px rgba0,0,0,.2.kyusaipadding:15px;background-color:fff;border-width:3px;border-style:solid;border-color:00f.toc-contentvisibility:visible;height:auto;opacity:initial;transition:initial.toc-list li livisibility:hidden;height:0.toc-list olheight:0.toc-checkbox:checked.toc-contentpadding-top:0.toc-checkbox:checked .toc-list olheight:auto;padding-left:0;padding-bottom:.8em.toc-checkbox:checked .toc-list li livisibility:visible;height:auto;margin:0.toc-list li li:beforefont-family:Font Awesome 5 Free;font-weight:900;content:f0da!important;margin-right:6px.toc-list li lilist-style:none;text-indent:-11.47px;padding-left:11.47px.toc-title,.toc-list afont-weight:bold.toc-list li li afont-weight:normal.tocmin-width:70;background-color:FDFEEE;border-style:none;padding:10px 30px 10px 30px;box-shadow:2px 2px 4px gray;background-image:linear-gradienttransparent 98,rgba198,206,183,1 5,linear-gradient90deg,transparent 98,rgba198,206,183,1 5;background-size:14px 14px;background-repeat:repeat;background-position:10px 6pxfigcaptiontext-align:center;font-size:.8em;margin:2px.new-naviposition:relative;overflow:hidden;display:block;margin:15px auto;background:f1f1f1;box-shadow:0 3px 5px rgba0,0,0,.14;box-sizing:border-box.new-navi .new-entry-card-titlepadding:5px.ribbonbackground:ec3138;color:fff;font-size:15px;font-weight:bold;width:400px;height:25px;transform:rotate-45deg;transform-origin:top center;position:absolute;top:30px;left:-210px;padding:0 0 0 55px;box-sizing:border-box;text-align:center投資の随筆変なサービスPHP×MySQLランキングナビを自作しましたGAS×Twitter API自作ツールで相互フォロー解除を監視する市場が開いている日は日本株の投資成績を毎日投稿するようにしています見に来てくださる方はいるのですがそのページだけを見て終わる直帰パターンが多いです関連記事も表示していますが投資成績の記事をランダムに見せているだけなのであまり役立っていません暴落した日暴騰した日がランキング形式で見れたらおもしろいんじゃね?ってことで自作してみました汎用性が高いとは言えないですがログがてら記事にしますもしわからないわかりにくいうまくいかない等ありましたらコメントください実装の方法MySQLでランキングナビ用のテーブルを作成HTMLCSSでデザインを作成HTMLを生成するPHPを作成ショートコードとして登録し設置メンテナンスを楽にするために変更したことメンテナンス用MySQLコマンド前営業日比の増減金額トップ3とワースト3へのリンクを含んだナビゲーション7日以内の記事がランクインしていたらNEW!マークを表示見ている記事がランクインしている場合はリンクのタイトルを変更ランキングナビPC表示ランキングナビスマホ表示ランキングナビNEWアイコン閲覧中記事PHPのバージョン:PHP7.2.17MySQLのバージョン:MySQL5.7ランキングナビ部分の制作は以下のような流れで行いました上記HTMLを生成するPHPを作成今回の作業は若干難易度が高いです危機管理なしにガンガンいこうぜで突き進まないようにお願いします以下の作業を行っていますので万が一のミスがあると取り返しがつかなくなることがあります有事の際に元に戻せるように作業前にバックアップを取ってくださいテーマの基幹となるfunctions.phpに関わる変更ワードプレスの投稿内容を格納しているMySQLのテーブルからのデータ取得まずはランキングナビ表示のためのデータをMySQLで用意します以下の項目を持ったテーブルを作成していますURLのスラッグ部分日本株の投資成績はstock-jp-XXXと日付を使っているのでプライマリーキーとしても利用投稿の日付投稿のタイトルタイトルの最後につけている日本株成績XXXは入れない投稿の中身処理が終わったらNULLにしている前営業日比の増減金額continuous_days連騰続落の連続日数今回のランキングナビには利用していない投資結果の天気晴1晴ときどき曇2曇3雨4雷雨5今回のランキングナビには利用していない投稿が1週間以内かのフラグNEWマークの表示に利用MySQLの操作はエックスサーバーのサーバーパネルから利用できるphpMyAdminを利用しましたphpMyAdminでのMySQLコマンド実行方法SQLタブに以下のコマンドを入力し実行するとday_changecontinuous_daysweatherを除く項目が入ったテーブルが作成できます今回はwp_stock_jpという名前のテーブルを作成していますCREATE TABLE wp_stock_jp post_name varchar200 NOT NULL PRIMARY KEY, date varchar8, title text,post_content longtext, day_change int7 DEFAULT 0, continuous_days int2, weather int1, is_new int1 DEFAULT 0;1INSERT IGNORE INTO wp_stock_jp post_name, title, post_content select post_name, post_title,post_content FROM wp_posts WHERE post_status publish AND post_name like stock-jp-;2UPDATE wp_stock_jp SET titleLEFTtitle, CHAR_LENGTHtitle-13 WHERE post_content IS NOT null;3UPDATE wp_stock_jp SET dateCONCAT20,RIGHTpost_name, 6 WHERE post_content IS NOT null;4UPDATE wp_stock_jp SET post_content NULL;5UPDATE wp_stock_jp SET6is_new WHEN date CURRENT_TIMESTAMP - INTERVAL 7 DAY THEN 1それぞれのコマンドで以下の処理を行っています先ほど挙げた項目を持ったテーブルを作成作成したテーブルにワードプレスの投稿情報が入ったテーブルwp_postsから日本株投資成績の投稿を抽出して挿入post_statusがpublishでスラッグがstock-jp-xxxとなっているレコードを抽出投稿タイトルから日本株成績XXXの部分を削除全体の文字数-13を左側から抽出スラッグstock-jp-XXXから最後の6桁を抽出し年を2019とするために20を頭に追加処理が終わったのでpost_contentをNULLに変更dataと現在の日付を比較し7日以内の場合は1それ以外は0を入力そして機械的には取得できないday_changecontinuous_daysweatherは手入力を行いました各投稿を見ながら60弱のレコードを30分かけて入力しましたランキングナビ用テーブル完成イメージランキングナビをどのようなデザインにするかは結構時間がかかりました2カラムにするコードはCocoonで用意されたものを使っています暴騰暴落日ランキング期間:2019624第1位 XXX2019XXXX第2位 XXX2019XXXX第3位 XXX2019XXXX第XX位 -XXX2019XXXX第XX位 -XXX2019XXXX第XX位 -XXX2019XXXX.ranking-contents.ranking ul .rank-top li amargin: 5px 0px 12px;border-left: solid 10px 009933;box-shadow: 0px 3px 3px rgba0, 0, 0, 0.3;background-image: linear-gradientto right, rgba0,0,0,0 50, 009933 50;.rank-top li a:hover .rank-bottom li aborder-left: solid 10px ff333a;background-image: linear-gradientto right, rgba0,0,0,0 50, ff333a 50;.rank-bottom li a:hover .rank-title.rank-nummaker bluebackground: linear-gradienttransparent 60, a8dafb 60;.rank-date.rank-up-color .rank-down-color color: ff333a;ボタンの縦の配置はフレックスボックスで行っています.rank-title.rank-numにfloat: leftを付与し.rank-dateにtext-align: rightを付与することで1行で左寄せと右寄せを混在させています上記HTMLを作成するスクリプトをPHPで作成しますランキングの部分はMySQLのテーブルから情報を引っ張ってきますMySQLとの接続はPDOで実現する気満々でしたがワードプレスでデータベースへのアクセスのために用意されたクラス wpdbがあることを知ったのでそちらをありがたく使わせてもらいました下準備として今回作成したwp_stock_jpをwp-db.phpに追記する作業が必要になります以下の記事を参考に追記しましたblog.yukarien.comPHPファイルは以下を作成しましたトップ用code作成code_top ;day_changeの上位3レコードを取得結果は配列に格納されるresults wpdb-get_resultsSELECT FROM wpdb-stock_jp ORDER BY day_change DESC LIMIT 3;ランキングに7日以内の記事が入っているかif value-is_new new_mark NEW! ;new_mark ;ランキングに閲覧中の記事が入っているかif value-post_name substr_SERVERREQUEST_URI, 14, 15 title 本記事です;code_top code_top . 第 . num . 位 . number_formatvalue-day_change . . new_mark . dateYnj, strtotimevalue-date . ;code_top code_top . title . ;code_top code_top . ;ワースト用code作成code_bottom ;順位用にレコード数を取得num_max wpdb-get_varSELECT COUNT FROM wpdb-stock_jp;results wpdb-get_resultsSELECT FROM wpdb-stock_jp ORDER BY day_change ASC LIMIT 3;new_mark NEW! ;title 本記事です;idは最下位からrank-bottom13を付与code_bottom code_bottom . 第 . num_max . 位 . number_formatvalue-day_change . . new_mark . dateYnj, strtotimevalue-date . ;code_bottom code_bottom . title . ;num_max--;code_bottom code_bottom . ;htmlコードを生成echo暴騰暴落日ランキング期間:2019624code_topcode_bottom今回は関係ありませんがMySQLからデータを取ってくる際に第三者に入力された値を使う場合はprepareを使ったエスケープ処理が必要になります7日以内の投稿の場合はNEW!アイコンを表示閲覧中の記事のタイトルは本記事ですを表示するようにしていますhtmlを生成するphpファイルranking.phpが用意できたのでranking.phpを実行するショートコードを登録しますそのショートコードをお好みの位置に設置すれば実装完了ですショートコードの登録については以下の記事で説明しています設置場所も同じく投稿本文下のウィジェットとしましたfunction.phpを編集しますので万が一のためにバックアップを忘れずに取ってくださいPHPページへのアクセスのたびにテキストをランダムで出力ページへアクセスのたびにテキストがランダムで変わる仕組みの実装方法を紹介しますPHPで実現していますmunokuno.com実装についての説明は終わりですが今回作成するランキングナビは投稿するたびにテーブルへのレコードの追加が必要になります実装の部分で書きましたがテーブルの項目はMySQLコマンドで抽出したものと手入力で対応したものがありました具体的に言うと以下の3つの項目は手入力での対応としていましたなるべく手入力での対応をなくそうを知恵を絞りday_changeとweatherについては手入力をなくすことに成功しました前日比の増減金額の部分にday-change-valueというidを追加しました天気入力用のショートコードを作成し引数として天気の数字を使用するように変更しました例:weather 1ショートコードの記載は投稿内容にそのまま記載されているので引数の数字を抽出してテーブルに格納しますfunction weathernumif num0 1 text 晴; elseif num0 2 text 晴ときどき曇; elseif num0 3 text 曇; elseif num0 4 text 雨; elseif num0 5 text 雷雨;echo . text . ;add_shortcodeweather, weather;別ファイルではなくfunction.php内に実行コードを記載しましたレコードの追加およびcontinuous_daysを除く項目の入力までを実行するコマンドが以下になります日本株投資成績の記事を投稿後コマンドを実行しますINSERT IGNORE INTO wp_stock_jp post_name, title, post_content select post_name, post_title, post_contentFROM wp_posts WHERE post_status publish AND post_name like stock-jp-;1UPDATE wp_stock_jp SET titleLEFTtitle, CHAR_LENGTHtitle-13 WHERE post_content IS NOT null;2UPDATE wp_stock_jp SET dateCONCAT20,RIGHTpost_name, 6 WHERE post_content IS NOT null;3UPDATE wp_stock_jp SET weather SUBSTRINGpost_content, LOCATEweather , post_content CHAR_LENGTHweather , 1WHERE post_content IS NOT null;4 実際のコードではweatherの左側にがつくショートコードが実行されるため除去UPDATE wp_stock_jp SET post_content REPLACEpost_content, ,, WHERE post_content IS NOT null;5UPDATE wp_stock_jp SET day_change SUBSTRINGpost_content, LOCATEday-change-value, post_content CHAR_LENGTHday-change-value,LOCATE, post_content , LOCATEday-change-value, post_content-LOCATEday-change-value, post_content CHAR_LENGTHday-change-valueWHERE post_content IS NOT null;6UPDATE wp_stock_jp SET post_content NULL;7UPDATE wp_stock_jp SET8wp_postsテーブルにpost_nameが重複しないレコードがあれば挿入挿入したレコードの投稿タイトルから日本株成績XXXの部分を削除WHERE post_content IS NOT nullを入れることで既存のレコードには実行されないweatherのショートコードの記載から数字を抽出weather の次の文字を抽出前日比の増減金額から,を取るために投稿全体から,を削除,付きでは抽出がうまくいかなかった前日比の増減金額を抽出day-change-valueとその次に出てくるの間を抽出CASE式で条件分岐をSQL文に任せるCSS今更ながらフレックスボックスの使い方をまとめてみたホバー時に背景が左からスライド初めてのMySQLを使ったプラグラムでしたが何とか完成させることができましたドはまりポイントはこれと言ってありませんでしたが私にしては大物でしたので時間がかかりましたMySQLについては以下のサイトで勉強しましたMySQL以外にもいろいろな言語が学べるので英語の読みが多少できる人にはお勧めです以下は実現したかったが技術的に実現できなかった部分なので今後の課題ですランキングナビ用のDBをワードプレス用のDBと分けて作りwpdbを利用してアクセスするMySQLのユーザーを追加しワードプレス用のDBにはread権限のみランキングナビ用のDBにはreadwrite権限をつける連騰日数続落日数をMySQLのコマンドで入力する928追記 実現しました!MySQL前のレコードからデータ取得OFFSET句メンテナンス用のMySQLのコマンドをワードプレスの画面から実行できるようにする皆さんせっかく作ったランキングナビを活用してもらえると嬉しいです暴騰暴落の規模が小さくてすみません最後までお読みいただきありがとうございます!PV0を駆逐せよ!にほんブログ村戦略にテコ入れPHP×MySQLサイコロジカルライン出力プラグラムを作成しましたTradingViewトレーディングビューという神サービスを利用した株価チャートの掲載方法を説明しますCocoonのプロフィールをTwitter FIRSTにカスタマイズCocoonのプロフィールをカスタマイズしツイッターを目立つようにする方法ですPHP初回に生成したHTMLコードを再利用して処理を軽くするアクセス毎に同じ内容のHTMLコードを生成していたPHPスクリプトにちょこっと変更を入れて処理を軽くする試みです興味本位で投資の世界に飛び込み溺れ続けるリーマン投資家逆指標として使えますシステムトレード3メタトレーダー53投資の成績99株式91無能投資家観察場8投資の随筆17eワラント1気になるっ!5投資以外の随筆36変なサービス2生産性アップ52020年7月無能投資家観察場72 日本株成績更新2020年6月無能投資家観察場レーティングや目標株価からアナリストの見立てを手に入れる昔NISA口座で囲っていた銘柄を未来から見てむせび泣くCopyright 2019 無能投資家の苦悩 All Rights Reserved.あなたのシェアが力になる 