FilesExpand file tree

 master

/

class.author.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

executable file

·

120 lines (100 loc) · 2.22 KB

 master

/

class.author.php

Copy path

Top

File metadata and controls

• Code
• Blame

executable file

·

120 lines (100 loc) · 2.22 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

<?php

class author

{

private $_name_table;

private $_id;

private $_name_author_array;

private $_n_author;

private $_id_array;

private $_n_id;

function __construct ($name)

{

$this->_name_table = $name;

}

public function retrive_by_id($id)

{

$table=$this->getName_table();

$query = "SELECT DISTINCT name FROM $table WHERE id = '$id' ";

$rs = mysql_query($query);

$n=0;

while(list($id) = mysql_fetch_row($rs))

{

$this->setName_author_array($id, $n);

$n = $n +1;

}

$this->setN_author($n);

}

public function retrive_name()

{

$table=$this->getName_table();

$query = "SELECT DISTINCT name FROM $table";

$rs = mysql_query($query);

$n=0;

while(list($id) = mysql_fetch_row($rs))

{

$this->setName_author_array($id, $n);

$n = $n +1;

}

$this->setN_author($n);

}

public function retrive_id_by_name($name)

{

$table=$this->getName_table();

$query = "SELECT DISTINCT id FROM $table WHERE name='$name'";

$rs = mysql_query($query);

$n=0;

while(list($id) = mysql_fetch_row($rs))

{

$this->setID_array($id, $n);

$n = $n +1;

}

$this->setN_id($n);

}

// SET -------------------------------------

public function setID($val)

{

$this->_id = $val;

}

public function setName_author_array($val, $n)

{

$this->_name_author_array[$n] = $val;

}

public function setID_array($val, $n)

{

$this->_id_array[$n] = $val;

}

public function setN_author($val)

{

$this->_n_author = $val;

}

public function setN_id($val)

{

$this->_n_id = $val;

}

// GET ++++++++++++++++++++++++++++++++++++++

public function getID()

{

return $this->_id;

}

public function getName_author_array($i)

{

return $this->_name_author_array[$i];

}

public function getID_array($i)

{

return $this->_id_array[$i];

}

public function getN_author()

{

return $this->_n_author;

}

public function getN_id()

{

return $this->_n_id;

}

public function getName_table()

{

return $this->_name_table;

}

}

?>