code for if and else condition connected with database

Question

we are using an extension , so that the extension provides a text box in the admin panel.

if we enter the numbers in the admin panel text field means automatically it will save in the database table

we saved list of numbers in the database .

if the number is present in the database, than we have to display the message if condition

" available", if it is not present means than we have to display else condition "un avaialble"

please give me the php code for these kind of feature

please don't clsoe this question as un clear, if you have any doubts , please comment here, so that i will try to to clear it.....

Answer 1

If it's a configuration field, you need to find out what is the path of the field by looking at the system.xml file of the module.

You should find something like this:

<sections>
        <yourmodule translate="label" module="yourmodule">
            ...
            <groups>
                <group_tag translate="label">
                     ...   
                     <fields>
                        <your_field translate="label">
                            <label>Label of the field</label>
                            ...
                         </your_field>
                    </fields>                               
                </group_tag>
            </groups>                   
        </yourmodule>
    </sections>

Thus, with the example above you can retrieve the value of the field using the following PHP code:

Mage::getStoreConfig('yourmodule/group_tag/your_field');

Edit: according to the system.xml file, here is how you can retrieve the values of your field:

Mage::getStoreConfig('checkdelivery/general/pincode');

However this field is comma separated so if you want an array you can just do:

$myArray = explode(',',Mage::getStoreConfig('checkdelivery/general/pincode'));

Then if you want to test if a number is in this array:

if (in_array($myNumber,$myArray))
{
// Number is present in the array
}
else
{
// Number is not in the array
}