https://wiki.avdelning.se/index.php?action=history&feed=atom&title=PHP_och_MySQL%2C_ansluta_och_l%C3%A4sa_data 2026-07-11T04:31:07Z Revision history for this page on the wiki MediaWiki 1.45.3 https://wiki.avdelning.se/index.php?title=PHP_och_MySQL,_ansluta_och_l%C3%A4sa_data&diff=320&oldid=prev 2026-05-11T21:53:23Z

<p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 21:53, 11 May 2026</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

Linadmin https://wiki.avdelning.se/index.php?title=PHP_och_MySQL,_ansluta_och_l%C3%A4sa_data&diff=319&oldid=prev 2016-10-24T08:02:34Z

<p>Skapade sidan med &#039;För att ansluta till databasen: &#039;&#039;&#039;$dbpass=&quot;&#039;&#039;password&#039;&#039;&quot;;&#039;&#039;&#039; &#039;&#039;&#039;$dblink=mysql_connect(&quot;&#039;&#039;localhost&#039;&#039;&quot;,&quot;&#039;&#039;gbuser&#039;&#039;&quot;,&quot;$dbpass&quot;) or die (&quot;Could NOT connect to database&quot;);&#039;&#039;&#039;...&#039;</p> <p><b>New page</b></p><div>För att ansluta till databasen:<br /> <br /> &#039;&#039;&#039;$dbpass=&quot;&#039;&#039;password&#039;&#039;&quot;;&#039;&#039;&#039;<br /> &#039;&#039;&#039;$dblink=mysql_connect(&quot;&#039;&#039;localhost&#039;&#039;&quot;,&quot;&#039;&#039;gbuser&#039;&#039;&quot;,&quot;$dbpass&quot;) or die (&quot;Could NOT connect to database&quot;);&#039;&#039;&#039;<br /> &#039;&#039;&#039;$databas=mysql_select_db(&quot;&#039;&#039;database&#039;&#039;&quot;) or die (&quot;Could NOT select database&quot;);&#039;&#039;&#039;<br /> <br /> För att stänga ned kopplingen till databasen:<br /> &#039;&#039;&#039;mysql_close($dblink);&#039;&#039;&#039;<br /> <br /> Skicka en sql-sträng:<br /> Skapa en sträng innehållande sqlfrågan<br /> &#039;&#039;&#039;$sql=&quot;select * from &#039;&#039;tabell&#039;&#039; where &#039;&#039;villkor&#039;&#039;&quot;;&#039;&#039;&#039;<br /> <br /> Skicka in den i MySQL<br /> &#039;&#039;&#039;$result=mysql_query(&quot;$sql&quot;);&#039;&#039;&#039;<br /> <br /> Ett sätt att läsa ut datat<br /> &#039;&#039;&#039;while ($rad=mysql_fetch_array($result))&#039;&#039;&#039;<br /> &#039;&#039;&#039;{&#039;&#039;&#039;<br /> &#039;&#039;&#039;echo &quot;$rad[id]&quot;&#039;&#039;&#039;; Om $rad[id] inte står innanför &quot;&quot; ska det bytas mot $rad[&#039;id&#039;].<br /> &#039;&#039;&#039;echo &quot;$rad[text]&quot;&#039;&#039;&#039;;<br /> &#039;&#039;&#039;}&#039;&#039;&#039;<br /> Notera att &#039;&#039;&#039;id&#039;&#039;&#039; och &#039;&#039;&#039;text&#039;&#039;&#039; ovan är kolumnner i tabellen &#039;&#039;&#039;tabell&#039;&#039;&#039; i exemplet.<br /> <br /> [[Category:php]]</div>

Linuxwiki>Wikiadmin