Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $connectString = 'host=localhost dbname=myDatabase user=foo password=bar';
- $link = pg_connect($connectString);
- if (!$link)
- die("An connection could not be established");
- $result = pg_query($link, 'select myField from myTable');
- if (!$result) {
- echo "An error occurred: " . pg_last_error($conn) . "<br />\n";
- }
- else if (pg_num_rows($result) == 0) {
- echo "No rows returned.<br />\n";
- }
- else {
- while ($row = pg_fetch_object($result)) {
- echo $row->myField . "<br />\n";
- }
- }
- pg_close($link);
- ?>
- bovenstaand postgresql
- onderstaand mysql,..
- uiteindelijk moet mysql naar postgresql worden.
- <?php
- $hostname='localhost'; //// specify host, i.e. 'localhost'
- $user='gsm'; //// specify username
- $pass='gsm'; //// specify password
- $dbase='gsmlog3_30'; //// specify database name
- $connection = mysql_connect($hostname, $user, $pass) or die ("Can't connect to MySQL");
- $db = mysql_select_db($dbase , $connection) or die ("Can't select database.");
- $sSql = "SELECT * FROM Inschrijven WHERE bevestigd!='Y'";
- if($oRes = mysql_query($sSql)){
- while($aRow = mysql_fetch_assoc($oRes)){
- mail($aRow['email'],'Openstaande Factuur '.$aRow['id'].'','
- Beste '.$aRow['naam'].' '.$aRow['achternaam'].',
- U bent ingeschreven voor de cursus '.$aRow['opleiding'].' .
- Het openstaande bedrag is: '.$aRow['overige'].'.
- Met vriendelijke groet,
- Pietje Puk',"From: info@easy.be");
- echo'Verzonden naar: '.$aRow['email'].'<br />';
- }
- }else{
- //mail('rick@rick.nl,'Cronjob error','Er is iets fout gegaan!'. mysql_error());
- echo mysql_error();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement