[:en]Step : 2 Fill-In New Student Certificate Form[:th]Fill-in Student Form[:]

[:en][private]

Step 2 : Fill-In New Student Certificate Form.

First enter the amount of Student Certificate you wish to register then click “Confirm”

*Not more than 20 certificates per times


[insert_php]
$servername = “localhost”;
$username = “imaes920_imaes2”;
$password = “dbimaes”;
$current_user = wp_get_current_user()->ID;
// Create connection
$conn = mysql_connect($servername, $username, $password);
mysql_select_db(“imaes920_dbimaes”);

// Check connection
if (!$conn) {
die(“Connection failed: ” . mysql_connect_error());
}
echo “U:$current_user CC $country_id”;
//Select Country ID
$sql = mysql_query (“SELECT `meta_value` FROM `imaesdbusermeta` WHERE `meta_key` = ‘_mgm_cf_id_country’ AND `user_id` = ‘$current_user’ “);
$result = mysql_fetch_assoc($sql);
$country_id = $result[meta_value];
echo $country_id;
//Select Country Name
$sql_name = mysql_query (“SELECT `name` FROM `imaesdbmgm_countries` WHERE UPPER(`Code3`) = ‘$country_id’”);
$result_name = mysql_fetch_assoc($sql_name);
$country_name = $result_name[name];
//end INFO

// Select Gym
$select_gym = “‘;
}

//Select Tamra
$select_Tamra = “‘;
}

//Select NF Name
$query_country = mysql_query (” SELECT `Country` FROM `NF` WHERE `Code3`= ‘$country_id’ “);
$check_nf_country = mysql_fetch_assoc($query_country);
$nf_country = $check_nf_country [Country];

[/insert_php]


Form example for the new user without a serial number.

No.
Country
NF Name
Gym Name
Tamra
Type
Awarded Date
First Name
Last Name
Birthdate
SerialNumber
1
Thailand
NF Thailand
Gym A
Tamra 1 Khan 1
Gym
3/2/2015
Mr.Jones
Ahsly
10/13/1988
2
Thailand
NF Thailand
Gym B
Tamra 1 Khan 1
Female
3/2/2015
Mrs.Ketty
Alovada
12/17/1991

 

Form example for the user that already has a serial number.

No.
Country
NF Name
Gym Name
Tamra
Type
Awarded Date
First Name
Last Name
Birthdate
SerialNumber
1
Thailand
NF Thailand
Gym A
Tamra 1 Khan 2
Gym
3/2/2015
Mr.Jones
Ahsly
10/13/1988
A000001
2
Thailand
NF Thailand
Gym B
Tamra 1 Khan 3
Female
3/2/2015
Mrs.Ketty
Alovada
12/17/1991
A000002

 

**If you have questions, please contact : [email protected]

[/private]

[:th][private]

Step 2 : Fill-In New Student Certificate Form.

First enter the amount of Student Certificate you wish to register then click “Submit”

*Not more than 20 certificates per times


[insert_php]
$servername = “localhost”;
$username = “imaes920_imaes2”;
$password = “dbimaes”;
$current_user = wp_get_current_user()->ID;
// Create connection
$conn = mysql_connect($servername, $username, $password);
mysql_select_db(“imaes920_dbimaes”);

// Check connection
if (!$conn) {
die(“Connection failed: ” . mysql_connect_error());
}

//Select Country ID
$sql = mysql_query (“SELECT `meta_value` FROM `imaesdbusermeta` WHERE `meta_key` = ‘_mgm_cf_id_country’ AND `user_id` = ‘$current_user’ “);
$result = mysql_fetch_assoc($sql);
$country_id = $result[meta_value];

//Select Country Name
$sql_name = mysql_query (“SELECT `name` FROM `imaesdbmgm_countries` WHERE `Code3`= ‘$country_id’”);
$result_name = mysql_fetch_assoc($sql_name);
$country_name = $result_name[name];
//end INFO

// Select Gym
$select_gym = “‘;
}

//Select Tamra
$select_Tamra = “‘;
}

//Select NF Name
$query_country = mysql_query (” SELECT `Country` FROM `NF` WHERE `Code3`= ‘$country_id’ “);
$check_nf_country = mysql_fetch_assoc($query_country);
$nf_country = $check_nf_country [Country];

[/insert_php]


Form example for the new user without a serial number.

No.
Country
NF Name
Gym Name
Tamra
Type
Awarded Date
First Name
Last Name
Birthdate
SerialNumber
1
Thailand
NF Thailand
Gym A
Tamra 1 Khan 1
Gym
3/2/2015
Mr.Jones
Ahsly
10/13/1988
2
Thailand
NF Thailand
Gym B
Tamra 1 Khan 1
Female
3/2/2015
Mrs.Ketty
Alovada
12/17/1991

 

Form example for the user that already has a serial number.

No.
Country
NF Name
Gym Name
Tamra
Type
Awarded Date
First Name
Last Name
Birthdate
SerialNumber
1
Thailand
NF Thailand
Gym A
Tamra 1 Khan 2
Gym
3/2/2015
Mr.Jones
Ahsly
10/13/1988
A000001
2
Thailand
NF Thailand
Gym B
Tamra 1 Khan 3
Female
3/2/2015
Mrs.Ketty
Alovada
12/17/1991
A000002

 

**If you have questions, please contact : [email protected]

[/private]

[:]