{"id":18573,"date":"2022-11-01T07:38:55","date_gmt":"2022-11-01T02:08:55","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/"},"modified":"2022-11-01T07:38:55","modified_gmt":"2022-11-01T02:08:55","slug":"solved-how-to-select-photos-from-another-table-using-mysqlphp","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/","title":{"rendered":"[Solved] how to select photos from another table using mysql,php"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-45103797\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"45103797\" data-parentid=\"45103501\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>First of all you have to create connection between these two tables, add column user_id in <strong>photos<\/strong> table.<\/p>\n<pre><code>CREATE TABLE\nIF NOT EXISTS photos (\n    id INT (11) NOT NULL AUTO_INCREMENT,\n    location VARCHAR (100) NOT NULL,\n    caption VARCHAR (100) NOT NULL,\n    user_id int(11) NOT NULL,\n    PRIMARY KEY (id)\n) ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 5;\n<\/code><\/pre>\n<p>Then change the structure of your users table, you have to store avatar as int with photo id.<br \/>\nChange avatar from varchar to integer value.<\/p>\n<pre><code>CREATE TABLE users (\n    id BIGINT (20) NOT NULL,\n    username VARCHAR (255) NOT NULL,\n    PASSWORD VARCHAR (255) NOT NULL,\n    email VARCHAR (255) NOT NULL,\n    age BIGINT (200) NOT NULL,\n    gender VARCHAR (10) NOT NULL,\n    avatar INT(10) NOT NULL,\n    signup_date INT (10) NOT NULL\n    ) ENGINE = MyISAM DEFAULT CHARSET = utf8;\n<\/code><\/pre>\n<p>Then when user will add data into photos table just write user_id and then you will have ability to get all users photos with MySQL query:<\/p>\n<pre><code>SELECT * FROM `photos` WHERE user_id={your_user_id}\n<\/code><\/pre>\n<p>Then you will choose id of one photo that you want to make avatar and will update <strong>users<\/strong> table column named avatar with photo <strong>id<\/strong> <em>(photos.id)<\/em><\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">7<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved how to select photos from another table using mysql,php <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] First of all you have to create connection between these two tables, add column user_id in photos table. CREATE TABLE IF NOT EXISTS photos ( id INT (11) NOT NULL AUTO_INCREMENT, location VARCHAR (100) NOT NULL, caption VARCHAR (100) NOT NULL, user_id int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE = MyISAM DEFAULT CHARSET &#8230; <a title=\"[Solved] how to select photos from another table using mysql,php\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/\" aria-label=\"More on [Solved] how to select photos from another table using mysql,php\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[340,339],"class_list":["post-18573","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql","tag-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] how to select photos from another table using mysql,php - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] how to select photos from another table using mysql,php - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] First of all you have to create connection between these two tables, add column user_id in photos table. CREATE TABLE IF NOT EXISTS photos ( id INT (11) NOT NULL AUTO_INCREMENT, location VARCHAR (100) NOT NULL, caption VARCHAR (100) NOT NULL, user_id int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE = MyISAM DEFAULT CHARSET ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-01T02:08:55+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] how to select photos from another table using mysql,php\",\"datePublished\":\"2022-11-01T02:08:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/\"},\"wordCount\":122,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"mysql\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/\",\"name\":\"[Solved] how to select photos from another table using mysql,php - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-01T02:08:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] how to select photos from another table using mysql,php\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] how to select photos from another table using mysql,php - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] how to select photos from another table using mysql,php - JassWeb","og_description":"[ad_1] First of all you have to create connection between these two tables, add column user_id in photos table. CREATE TABLE IF NOT EXISTS photos ( id INT (11) NOT NULL AUTO_INCREMENT, location VARCHAR (100) NOT NULL, caption VARCHAR (100) NOT NULL, user_id int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE = MyISAM DEFAULT CHARSET ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/","og_site_name":"JassWeb","article_published_time":"2022-11-01T02:08:55+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] how to select photos from another table using mysql,php","datePublished":"2022-11-01T02:08:55+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/"},"wordCount":122,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["mysql","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/","url":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/","name":"[Solved] how to select photos from another table using mysql,php - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-01T02:08:55+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-select-photos-from-another-table-using-mysqlphp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] how to select photos from another table using mysql,php"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/18573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=18573"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/18573\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=18573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=18573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=18573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}