-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdictionary.php
More file actions
32 lines (30 loc) · 749 Bytes
/
dictionary.php
File metadata and controls
32 lines (30 loc) · 749 Bytes
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
<?php
include('lock.h');
function getDictionary($id) {
$sql="SELECT id_name FROM t_dictionary WHERE id_id='$id'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
if (mysql_num_rows($result)==1) {
$value = $row['id_name'];
return $value;
}
}
function insertDictionary($id, $name) {
$sql="INSERT INTO t_dictionary (id_id, id_name) VALUES ('$id', '$name')";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
if (mysql_affected_rows()==1) {
return true;
}
return false;
}
function setDictionary($id, $name) {
$sql="UPDATE t_dictionary SET id_name='$name' WHERE id_id='$id'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
if (mysql_affected_rows()==1) {
return true;
}
return false;
}
?>