Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ?php
- /* ----------------- POSTGRESQL YHTEYS ------------------------- */
- //$connection = pg_connect("host=localhost port=5432 dbname=evoker user=postgres password=jarppa");
- $connection = pg_connect("host=localhost port=13713 dbname=muistilista user= password=");
- if(!$connection) {
- die("Database connection failed: " . pg_last_error());
- }
- ?>
- <?php
- $name='Jaakko';
- $surname='Pekonen';
- $varNimi = pg_escape_string($name);
- $varSur = pg_escape_string($surname);
- $query1 = "SELECT name, surname FROM opiskelija WHERE name='".$varNimi."' AND surname='".$varSur."'";
- global $connection;
- $onnistuiko = pg_query($connection, $query1);
- $row = pg_fetch_assoc($onnistuiko);
- //Tarkastetaan onko kyselyllä sisältöä, jos ei ole, niin nimi + salasanapari ei ole olemassa
- if (isset($row["name"])){
- //echo "\$" . $row["name"];
- //echo $onnistuiko;
- //jos onnistui, niin
- print "jee onnistui";
- }
- else
- echo "tarkista nimi ja salasana";
Add Comment
Please, Sign In to add comment