-
Notifications
You must be signed in to change notification settings - Fork 0
/
conn.php
90 lines (71 loc) · 3.4 KB
/
conn.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" integrity="sha384-JcKb8q3iqJ61gNV9KGb8thSsNjpSL0n8PARn9HuZOnIxN0hoP+VmmDGMN5t9UJ0Z" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js" integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js" integrity="sha384-B4gt1jrGC7Jh4AgTPSdUtOBvfO8shuf57BaghqFfPlYxofvL8/KUEfYiJOMMV+rV" crossorigin="anonymous"></script>
<link rel="stylesheet" href="last.css">
</head>
<body>
<div>
<?php
$servername = "localhost";
$username = "root";
$password = "1234";
$w = $_GET['t'];
$data = "jayanth";
try {
$conn = new PDO("mysql:host=$servername;dbname=$data", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$s = $conn->query("SELECT * from sample_words where word_name = '$w'");
foreach ($s as $row ) {
$wid = $row['word_id'] ;
echo "<h1>". $row['word_name'] . "</h1>";
echo '<img src="data:image/jpg;charset=utf8;base64,' .base64_encode($row['image']) .'"style="width:300px;"/>' . "<br>";
echo "Scientific Name: (" . $row['scientific_name']. ")". "<br>";
echo "Pronunciation: (" . $row['pronunciation']. ")". "<br>";
echo "-----------------------------"."<br>"."<br>";
$s = $conn->query("SELECT * from synonyms where word_id = $wid");
foreach ($s as $row ) {
$sid = $row['synonym_id'];
echo "<hr>"."Meaning: ".$row['definition'] ."<br>";
echo "Example: ". $row['example'] . "<br>";
echo "Synonym: ". $row['synonym_word']. "<br>";
$s = $conn->query("SELECT * from antonyms where synonym_id = $sid AND word_id = $wid");
foreach ($s as $row ) {
echo "Antonym: ". $row['antonym_word'] . "<br>";
echo "Example: ". $row['example'] . "<br>". "<br>";
}
// $s = $conn->query("SELECT * from pos where pos_id = $wid");
// foreach ($s as $row ) {
// echo "Example: ". $row['pos_name'] . "<br>";
// }
}
echo "<h2>"."In Other lauguages"."</h2>";
$s = $conn->query("SELECT * from languages where word_id = $wid");
echo "<hr>"."HINDI: ";
foreach ($s as $row ) {
echo $row['Hindi'] ." ,";
}
echo "<br>"."<hr>";
$s = $conn->query("SELECT * from languages where word_id = $wid");
echo "SANSKRIT: ";
foreach ($s as $row ) {
echo $row['Sanskrit']." ,";
}
echo "<br>"."<hr>";
$s = $conn->query("SELECT * from languages where word_id = $wid");
echo "TELUGU: ";
foreach ($s as $row ) {
echo $row['Telugu']." ,";
}
echo "<br>"."<hr>";
}
} catch(PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
?>
</div>
</body>
</html>