<div dir="ltr"><div>$_SERVER["HOME"] is undefined. I just used parse_ini_file("../replica.my.cnf");<br><br></div>Thanks!<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-06-17 19:01 GMT+02:00 Maximilian Doerr <span dir="ltr"><<a href="mailto:maximilian.doerr@gmail.com" target="_blank">maximilian.doerr@gmail.com</a>></span>:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div link="blue" vlink="purple" lang="EN-US"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Something like <u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><?php<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">$db_mycnf = parse_ini_file($_SERVER['HOME']."/replica.my.cnf");<u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">$db_username = $db_mycnf['user'];<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">$db_password = $db_mycnf['password'];<u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">unset($db_mycnf);<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">should do nicely.  It’ll store the username and password to the variables $db_username and $db_password.<u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:labs-l-bounces@lists.wikimedia.org" target="_blank">labs-l-bounces@lists.wikimedia.org</a> [mailto:<a href="mailto:labs-l-bounces@lists.wikimedia.org" target="_blank">labs-l-bounces@lists.wikimedia.org</a>] <b>On Behalf Of </b>Emilio J. Rodríguez-Posada<br>

<b>Sent:</b> Tuesday, June 17, 2014 12:35 PM<br><b>To:</b> Wikimedia Labs<br><b>Subject:</b> [Labs-l] Connecting to MySQL in PHP<u></u><u></u></span></p><div><div class="h5"><p class="MsoNormal"><u></u> <u></u></p><div><div>

<p class="MsoNormal" style="margin-bottom:12.0pt">Hello;<u></u><u></u></p></div><p class="MsoNormal">I need to connect to a MySQL database using PHP. I have a replica.my.cnf that I guess I have to use. What is the best way to connect to MySQL using this file, without exposing the user/pass in the PHP code?<br>

<br>There is no help about this in the tutorial.[1]<br><br>Thanks<br><br>[1] <a href="https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help" target="_blank">https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help</a><u></u><u></u></p>

</div></div></div></div></div><br>_______________________________________________<br>
Labs-l mailing list<br>
<a href="mailto:Labs-l@lists.wikimedia.org">Labs-l@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br>
<br></blockquote></div><br></div>