{"id":10627,"date":"2022-09-24T10:03:49","date_gmt":"2022-09-24T04:33:49","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/"},"modified":"2022-09-24T10:03:49","modified_gmt":"2022-09-24T04:33:49","slug":"solved-how-to-display-data-from-database-mysql-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/","title":{"rendered":"[Solved] how to display data from database (MySQL)? [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

It would be something like this:<\/p>\n

echo '<td><a href=\"https:\/\/stackoverflow.com\/questions\/14226828\/info.php?id=\".$row['id'].'\">'.$row['Email'].'<\/a><\/td>';\n<\/code><\/pre>\n
You’re passing the user id to the info.php page. This will only work if you have an Id column called Id<\/code> in your table. Alternatively you can use Email<\/code> instead of Id<\/code>:<\/p>\n
echo '<td><a href=\"https:\/\/stackoverflow.com\/questions\/14226828\/info.php?email=\".$row[\"Email'].'\">'.$row['Email'].'<\/a><\/td>';\n<\/code><\/pre>\n
Now, on the info.php you can do another query as such: <\/p>\n
$result = mysql_query(\"SELECT * FROM User WHERE id = \" . $_GET['id']);\nwhile($row = mysql_fetch_array($result)){\necho $row['Age'] . ' ' . $row['Name'];\n}\n<\/code><\/pre>\n
If you used Email<\/code> instead of Id<\/code> the first line needs to look like this:<\/p>\n
$result = mysql_query(\"SELECT * FROM User WHERE Email = \" . $_GET['email']);\n<\/code><\/pre>\n
Please note this is just a guideline. You’re open to sql injection and you should look into using PDO<\/a>.<\/p>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            10<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved how to display data from database (MySQL)? [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] It would be something like this: echo ‘<td><a href=”https:\/\/stackoverflow.com\/questions\/14226828\/info.php?id=”.$row[‘id’].'”>’.$row[‘Email’].'<\/a><\/td>’; You’re passing the user id to the info.php page. This will only work if you have an Id column called Id in your table. Alternatively you can use Email instead of Id: echo ‘<td><a href=”https:\/\/stackoverflow.com\/questions\/14226828\/info.php?email=”.$row[“Email’].'”>’.$row[‘Email’].'<\/a><\/td>’; Now, on the info.php you can do another query as … 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-10627","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql","tag-php"],"yoast_head":"\n[Solved] how to display data from database (MySQL)? [closed] - 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-display-data-from-database-mysql-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] how to display data from database (MySQL)? [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] It would be something like this: echo '<td><a href="https:\/\/stackoverflow.com\/questions\/14226828\/info.php?id=".$row['id'].'">'.$row['Email'].'<\/a><\/td>'; You’re passing the user id to the info.php page. This will only work if you have an Id column called Id in your table. Alternatively you can use Email instead of Id: echo '<td><a href="https:\/\/stackoverflow.com\/questions\/14226828\/info.php?email=".$row["Email'].'">'.$row['Email'].'<\/a><\/td>'; Now, on the info.php you can do another query as ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-24T04:33:49+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-display-data-from-database-mysql-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] how to display data from database (MySQL)? [closed]\",\"datePublished\":\"2022-09-24T04:33:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/\"},\"wordCount\":102,\"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-display-data-from-database-mysql-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/\",\"name\":\"[Solved] how to display data from database (MySQL)? [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-24T04:33:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] how to display data from database (MySQL)? [closed]\"}]},{\"@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=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"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 display data from database (MySQL)? [closed] - 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-display-data-from-database-mysql-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] how to display data from database (MySQL)? [closed] - JassWeb","og_description":"[ad_1] It would be something like this: echo '<td><a href=\"https:\/\/stackoverflow.com\/questions\/14226828\/info.php?id=\".$row['id'].'\">'.$row['Email'].'<\/a><\/td>'; You’re passing the user id to the info.php page. This will only work if you have an Id column called Id in your table. Alternatively you can use Email instead of Id: echo '<td><a href=\"https:\/\/stackoverflow.com\/questions\/14226828\/info.php?email=\".$row[\"Email'].'\">'.$row['Email'].'<\/a><\/td>'; Now, on the info.php you can do another query as ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/","og_site_name":"JassWeb","article_published_time":"2022-09-24T04:33:49+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-display-data-from-database-mysql-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] how to display data from database (MySQL)? [closed]","datePublished":"2022-09-24T04:33:49+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/"},"wordCount":102,"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-display-data-from-database-mysql-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/","name":"[Solved] how to display data from database (MySQL)? [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-24T04:33:49+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-display-data-from-database-mysql-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] how to display data from database (MySQL)? [closed]"}]},{"@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=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","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\/10627","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=10627"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10627\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=10627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=10627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=10627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}