Question

How do I check if a certain ENUM value in a sql database is a certain string.
For example, PHP:
if((data) == "myString"){
do this
}

Answer 1

@TuringTest

Answer 2

I'm sorry, I don' know enough about sql or what an ENUM value is.

Answer 3

oh ok nevermind...

Answer 4

thanks anyways

Answer 5

good luck!
I would like to learn this as well

Answer 6

@wio

Answer 7

plz help

Answer 8

Are you making an SQL query?

Answer 9

yes

Answer 10

I need a permissions system, so I need to check the value of a certain enum using PHP

Answer 11

So you want the query to filter out data without permission? Or do you want it to come back with true?

Answer 12

I need to check if a certain value exists for the column.. for example if the permissions column contains "yes"..

Answer 13

Normally you'd add
```
WHERE column = 'yes'
```
But not all SQL define ENUM the same

Answer 14

hmm I'll try that..

Answer 15

I would need to know more to give better answer

Answer 16

I did that, but the following error:
Warning: mysql_query() expects parameter 2 to be resource, string given in /home/u677311329/public_html/login.php on line 28

Answer 17

Okay, what do you know about the ENUM?

Answer 18

http://pastebin.com/1N6Wxj2a

Answer 19

thats line 28

Answer 20

Okay, where is the SQL for defining the ENUM?

Answer 21

the permissions parameter doesn't seem to work for some reason

Answer 22

The enum parameter is "admin"

Answer 23

Is there a reason you can't tell me about the ENUM? Is it that you don't know?

Answer 24

What enum?

Answer 25

Umm, no. I need to know about the database schema...

Answer 26

I have a column named permissions and inside there are two enum values:
"admin","user". I want to check if the specified column contains "admin"

Answer 27

Okay, here is what you should do then:
get rid of the enum constraint, then print out whatever is in the permissions column

Answer 28

Then you will know what it's current value is, and you can check against it.

Answer 29

The enum is converted to some integer, but I don't know what integers it's going to be. That's what you should know

Answer 30

But the permissions column stores the enum values

Answer 31

Yes, well you don't know what the enum value becomes, right? So just print it out.

Answer 32

Then you will know, then you can check against it

Answer 33

How do I do that, if I could print out the value, then I could also check value.. which is what i need

Answer 34

Okay, so do you have a way to execute queries directly on your database? Like phpMyAdmin?

Answer 35

Yes I do have phpMyAdmin.. i'm using it right now

Answer 36

```
SELECT permissions
FROM company
WHERE username = 'bob';
```
You can change `bob` to the username of an admin and figure out what the enum corresponds too.

Answer 37

Yes i see, I run it with the appropriate username.. I can the value is currently set to "admin". Now how do I store that value into a variable and check the value is equal to a certain ENUM

Answer 38

Okay, then maybe try `permissions=admin` without quotes

Answer 39

No it doesn't work, all I get is that parameter 2 is expected to be resource, but string given

Answer 40

http://pastebin.com/ZHG5rdPd Here is my code

Answer 41

okay, the problem isn't enum

Answer 42

` "$connection"` Why you put in quotes?

Answer 43

You shouldn't put it quotes

Answer 44

Yeah, but you put it in quotes

Answer 45

oh lemme try it out again..

Answer 46

THANK YOU!.... but do you have any idea why it can't verify it afterwards... because it doesn't seem to print the $adminedit variable after

Answer 47

try 'admin' or admin

Answer 48

yes, only 'admin' works, but I can't seem to echo the variable $adminedit afterwards

Answer 49

What happens when you try?

Answer 50

nothing appears..

Answer 51

http://pastebin.com/EQxcRNYz

Answer 52

try `var_dump($adminedit)`.
I think that the problem is that it doesn't get defined.

Answer 53

why should i put that in the code

Answer 54

To figure out what happened to `$adminedit`

Answer 55

I'll try

Answer 56

Outputs: "NULL",
Can I not store a string on multiple lines?

Answer 57

http://php.net/manual/en/language.types.string.php#language.types.string.syntax.heredoc

Answer 58

EOD huh?.. lemme try

Answer 59

```
$adminedit = "<form>
<textarea name='editor1' id='editor1' rows='10' cols='80'>
This is my textarea to be replaced with CKEditor.
</textarea>
<script>
// Replace the <textarea id='editor1'> with a CKEditor
// instance, using default configuration.
CKEDITOR.replace('editor1');
</script>
</form>";
```
Should be
```
$adminedit = <<HTML
<form>
<textarea name='editor1' id='editor1' rows='10' cols='80'>
This is my textarea to be replaced with CKEditor.
</textarea>
<script>
// Replace the <textarea id='editor1'> with a CKEditor
// instance, using default configuration.
CKEDITOR.replace('editor1');
</script>
</form>
HTML;
```

Answer 60

`<<<HTML` begins string
`HTML;` ends string

Answer 61

I'll try that

Answer 62

Only outputs syntax error

Answer 63

what is code?

Answer 64

http://pastebin.com/4jZx4TqL

Answer 65

`HTML;` but be at the start of a new line

Answer 66

must be

Answer 67

No doesn't work either

Answer 68

and `<<<HTML` must be at end of line


also, don't need `"`

Answer 69

Is there syntax error?

Answer 70

yes

Answer 71

what is error?

Answer 72

Parse error: syntax error, unexpected T_SL in /home/u677311329/public_html/login.php on line 30

Answer 73

Line 30: $adminedit = <<<HTML

Answer 74

What does code look like now?

Answer 75

http://pastebin.com/bysjh4t8

Answer 76

You have white space before `HTML;`
It must be at the beginning of the line.

Answer 77

Doesn't work either

Answer 78

can I see?

Answer 79

http://pastebin.com/tJMXsLv2

Answer 80

can you give me exact error?

Answer 81

Parse error: syntax error, unexpected T_SL in /home/u677311329/public_html/login.php on line 30

Answer 82

T_SL refers to <<

Answer 83

You should not use tabs or spaces before you use `HTML;`

Answer 84

Can you check if the enum is verified correctly, because the string just outputs null without the <<<HTML

Answer 85

I tried without tabs or spaces, still does not work

Answer 86

the `<<<HTML` and `HTML;` work just like `"` and `"`, but allow multiple line.

Answer 87

Therefore, you don't need to keep `"` in them

Answer 88

still NULL

Answer 89

is there parser error?

Answer 90

nope... NULL... I even preset the $adminedit variable to something else before the condition... outputs null still

Answer 91

Can you show me entire thing?

Answer 92

http://pastebin.com/6Qf5s4cM

Answer 93

There is no echo....

Answer 94

Yes, I have the echo on the actual html page

Answer 95

can I see it?

Answer 96

<?php echo $adminedit; ?>

Answer 97

What about variable scope?

Answer 98

does it regard that.. It wont even print out the preset global value.