possible with php and mySQL?!?!?

[son.of.the.morning]

Is it possible for php the check for individual letters in a sql record. For example is the word 'superman' was stored in sql record and my page told the user to input the first, fourth and last letter of the word into a text box would php be able to check the record to see if the letter exists the word and that they are in the correct order?

[systemick]

You would need to pull the word out of the database then test it for the letters. If you had asked for letters 1,3&4 you would do somehting like this

 

 

if ($secret_word[0] == 's' && $secret_word[2] == 'p' && $secret_word[3] == 'e') {
<Do something>
}

 

[son.of.the.morning]

Wouldn’t the word have to be broken up, possible into an array.

I don’t no if i am making much sense of the code below, [0],[1],[2] are these referring the individual characters in the record?

 

[systemick]

You can treat a string as an array in php. Try this

 

$word = 'superman';
print 'first letter = '.$word[0];

[fortnox007]

can't it be done with preg_match?

like:

 

$string ='superman';
        echo preg_match('/(superman)/','$string');// will output 1 (true) if the first part is in the string

[mraza]

you can also check preg-split

<?php
$str = 'string';
$chars = preg_split('//', $str, -1, PREG_SPLIT_NO_EMPTY);
print_r($chars);
?>

 

[PFMaBiSmAd]

Since this word in stored in a database, you would generally want to do this in a query and check if the query matched any row(s) -

 

$first, $fourth, and $last php variables hold the entered characters. The underscore _ wildcard character ignores the 2nd, 3rd, 5th, 6th, and 7th positions -

 

$query = "SELECT COUNT(*) FROM your_table WHERE your_column LIKE '$first__$fourth___$last' AND another_condition_that_identifies_the_specific_word_you_want_to_check"

[son.of.the.morning]

i want to write a code, which will ask for different letters every time and once the user has submitted the form with the text box in it will then check to see if the letters are correct and in the right order from what the first page had indicated to the user.

 

 

[PFMaBiSmAd]

Then just write code to do that. You could build the LIKE '....' term dynamically with the entered values and wildcard characters in any positions you want.

[son.of.the.morning]

is there away i can make an array of possible combinations for the word?

[son.of.the.morning]

I have just read a short tutorial on wildcard in php, i cant access my ftp at the moe so i cant try the code.

 

Dont no if this will work, does this seem right?

$word = superman
$match = $word[1].$word[2].$word[5];
if ($pWord == $match) {
echo "ya mar";
}