Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml" dir="rtl" lang="ar-su" xml:lang="ar-su">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <meta http-equiv="Content-Language" content="en-us" />
- <title>استمارة التكفل</title>
- <link rel="stylesheet" href="contact.css" type="text/css" />
- </head>
- <body>
- <script language="javascript">
- function fncSubmit()
- {
- if(document.form1.chk1.checked == false)
- {
- alert('Please Click Checkbox 1 ');
- return false;
- }
- if(document.form1.chk2.checked == false)
- {
- alert('Please Click Checkbox 2 ');
- return false;
- }
- document.form1.submit();
- }
- </script>
- <div id="container">
- <div id="header">
- <div class="top"></div>
- <div class="spacer"></div>
- <div class="logo">
- <?php
- $config_file = "include/config.php";
- if (file_exists($config_file))
- {
- $fd = fopen($config_file, 'rb');
- $restore_query = fread($fd, filesize($config_file));
- // echo "EXISTS";
- // echo $restore_query;
- $mystring1 = $restore_query;
- $findme1 = '$l'; // find position of logo_url
- $pos1 = strpos($mystring1, $findme1);
- // echo $pos1;
- $mystring2 = $restore_query;
- $findme2 = '$s'; // find position of site_url
- $pos2 = strpos($mystring2, $findme2);
- // echo $pos2;
- $dif = $pos2 - $pos1;
- // echo $dif; // diffference (b/w site_url and logo_url) is length
- $difference_substring = substr($restore_query, $pos1, $dif);
- // echo $difference_substring;
- $mystring3 = $difference_substring;
- $findme3 = 'h'; // find position of http
- $pos3 = strpos($mystring3, $findme3);
- // echo $pos3;
- $mystring4 = $difference_substring;
- $findme4 = ';'; // find position of colon
- $pos4 = strpos($mystring4, $findme4);
- // echo $pos4;
- $dif1 = $pos4 - $pos3;
- // echo $dif1; // diffference (b/w colon and http) is length
- $correct_dif = $dif1 - 1;
- $difference1_substring = substr($difference_substring, $pos3, $correct_dif);
- // echo $difference1_substring;
- echo "
- <img src='$difference1_substring' />
- <font size='4' face='arial' color=#000000><b>مكتب مؤسسة العين في المانيا</b></font>";
- fclose($fd);
- }
- else
- {
- // echo "DOES NOT EXIST";
- $error = 'SQL file does not exist: ' . $config_file;
- }
- ?>
- </div>
- <div id="inner-container" class="clearfix"> <!-- inner-container -->
- <div id="content">
- <div style="margin-right:11em">
- <?php
- //Sample Database Connection Syntax for PHP and MySQL.
- //Connect To Database
- include('include/config.php');
- //$hostname="put your host name here, for example, p41mysqladmin.secureserver.net, or localhost";
- //$username="put your user name for the database";
- //$password="put your host name for the database";
- $usertable="contacts";
- $field1 = "last";
- $field2 = "first";
- $field70 = "k1";
- $field71 = "k2";
- $field72 = "k3";
- $field73 = "k4";
- $field3 = "middle";
- $field4 = "dob";
- $field5 = "address";
- $field6 = "city";
- $field7 = "phone";
- $field8 = "cell_phone";
- $field9 = "first_contact";
- $field10 = "first_relation";
- $field11 = "first_phone";
- $field12 = "second_contact";
- $field13 = "second_relation";
- $field14 = "second_phone";
- $field15 = "physician";
- $field16 = "phy_phone";
- $field17 = "medical_note";
- $field18 = "state";
- $field19 = "zip";
- $field20 = "email";
- $field97 = "id";
- // Alternative to include statement, $con = mysql_connect("$hostname", "$username", "$password");
- // Alternative to include statement, mysql_select_db('put name in these single quotes, or variable without these quotes', $con);
- $con = mysql_connect("$dbhost", "$dbuser", "$dbpass");
- mysql_select_db($dbname, $con);
- if (!$con)
- {
- die('Could not connect: ' . mysql_error());
- }
- if (isset($_REQUEST['first'])) // End of if structure where it checks if form is submitted.
- {
- $submet_email = $_REQUEST['email'];
- $querya = "SELECT * FROM $usertable";
- $queryb = "SELECT * FROM $usertable WHERE email = '$submet_email'";
- $resulta = mysql_query($querya);
- $resultb = mysql_query($queryb);
- if($resulta) // This if checks, if there are previously entered any records, or it is first time.
- {
- while($rowb = mysql_fetch_array($resultb)) //If there is even one record, the if and while parts would execute, it further compares the email
- {
- //echo "while part executed";
- $submitted_email = $submet_email;
- $email = $rowb["$field20"];
- if ($email == $submitted_email)
- {
- $capture_email = $email;
- }
- } // End of while loop
- $blank = "";
- if ($capture_email == $submet_email && $capture_email != $blank)
- {
- $sub_last = $_REQUEST['last'];
- $sub_first = $_REQUEST['first'];
- $sub_k1 = $_REQUEST['k1'];
- $sub_k2 = $_REQUEST['k2'];
- $sub_k3 = $_REQUEST['k3'];
- $sub_k4 = $_REQUEST['k4'];
- $sub_middle = $_REQUEST['middle'];
- $sub_dob = $_REQUEST['dd'].".".$_REQUEST['mm'].".".$_REQUEST['yyyy'];
- $sub_address = $_REQUEST['address'];
- $sub_city = $_REQUEST['city'];
- $sub_state = $_REQUEST['state'];
- $sub_zip = $_REQUEST['zip'];
- $sub_phone = $_REQUEST['phone'];
- $sub_cell_phone = $_REQUEST['cell_phone'];
- $sub_first_contact = $_REQUEST['first_contact'];
- $sub_first_relation = $_REQUEST['first_relation'];
- $sub_first_phone = $_REQUEST['first_phone'];
- $sub_second_contact = $_REQUEST['second_contact'];
- $sub_second_relation = $_REQUEST['second_relation'];
- $sub_second_phone = $_REQUEST['second_phone'];
- $sub_physician = $_REQUEST['physician'];
- $sub_phy_phone = $_REQUEST['phy_phone'];
- $sub_medical_note = $_REQUEST['medical_note'];
- $dat = date("Y-m-d");
- $tim = date("H:m:s");
- $timstamp = $dat." ".$tim;
- $eyep = $_SERVER['REMOTE_ADDR'];
- $query1 = "UPDATE contacts SET last = '$sub_last', first = '$sub_first', k1 = '$sub_k1', k2 = '$sub_k2', k3 = '$sub_k3', k4 = '$sub_k4', middle = '$sub_middle'
- , email = '$submitted_email', dob = '$sub_dob', address = '$sub_address', city = '$sub_city'
- , state = '$sub_state', zip = '$sub_zip', phone = '$sub_phone', cell_phone = '$sub_cell_phone'
- , first_contact = '$sub_first_contact', first_relation = '$sub_first_relation', first_phone = '$sub_first_phone'
- , second_contact = '$sub_second_contact', second_relation = '$sub_second_relation', second_phone = '$sub_second_phone'
- , physician = '$sub_physician', phy_phone = '$sub_phy_phone', medical_note = '$sub_medical_note', date = '$timstamp'
- , ip = '$eyep' WHERE email = '$submet_email'";
- $result1 = mysql_query($query1);
- if($result1)
- {
- echo "<br />You have successfully deleted <b>".$trans_fname." ".$trans_lname."</b>'s information.<br /><br />
- <center>
- <form>
- <input type='button' value='Close this window' onClick='window.close()'>
- </form>
- </center>
- <br />
- ";
- }
- } // End of internal if structure with comparison operator
- else
- {
- // echo "else part executed";
- $testing = $_REQUEST['first'];
- // echo $testing;
- $dat = date("Y-m-d");
- $tim = date("H:m:s");
- $timstamp = $dat." ".$tim;
- $eyep = $_SERVER['REMOTE_ADDR'];
- $query2="INSERT INTO $usertable (last, first, k1, k2, k3, k4, middle, email, dob, address, city, phone, cell_phone, first_contact,
- first_relation, first_phone, second_contact, second_relation, second_phone, physician, phy_phone, medical_note, state,
- zip, date, ip)
- VALUES ('$_REQUEST[last]','$_REQUEST[first]','$_REQUEST[k1]','$_REQUEST[k2]','$_REQUEST[k3]','$_REQUEST[k4]','$_REQUEST[middle]','$_REQUEST[email]',
- '$_REQUEST[dd].$_REQUEST[mm].$_REQUEST[yyyy]','$_REQUEST[address]','$_REQUEST[city]','$_REQUEST[phone]',
- '$_REQUEST[cell_phone]','$_REQUEST[first_contact]','$_REQUEST[first_relation]','$_REQUEST[first_phone]',
- '$_REQUEST[second_contact]','$_REQUEST[second_relation]','$_REQUEST[second_phone]','$_REQUEST[physician]',
- '$_REQUEST[phy_phone]','$_REQUEST[medical_note]','$_REQUEST[state]','$_REQUEST[zip]','$timstamp','$eyep')";
- $result2 = mysql_query($query2);
- if($result2)
- {
- echo "<br /> شكرا لكم لقم قمنا الان باستلام الاستمارة الخاصة بتكفل اليتم وسوف يقوم احد موظفين مؤسسة العين في المانيا بالتواصل معكم.<br /><br />
- <center>
- <form>
- <input type='button' value='Close this window' onClick='window.close()'>
- </form>
- </center>
- <br />
- ";
- }
- else
- {
- // echo "query failed";
- }
- } // End of else structure connected with if comparisor operator.
- } // End of if structure where it checks if it is first time.
- else // Start of else structure connected with if where it checks if it is first time.
- {
- // echo "This part executed";
- $dat = date("Y-m-d");
- $tim = date("H:m:s");
- $timstamp = $dat." ".$tim;
- // echo $timstamp;
- $eyep = $_SERVER['REMOTE_ADDR'];
- $query2="INSERT INTO contacts (last, first, k1, k2, k3, k4, middle, email, dob, address, city, phone, cell_phone, first_contact, k1,
- first_relation, first_phone, second_contact, second_relation, second_phone, physician, phy_phone, medical_note, state,
- zip, date, ip)
- VALUES ('$_REQUEST[last]','$_REQUEST[first]','$_REQUEST[k1]','$_REQUEST[k2]','$_REQUEST[k3]','$_REQUEST[k4]','$_REQUEST[middle]','$_REQUEST[email]',
- '$_REQUEST[dd].$_REQUEST[mm].$_REQUEST[yyyy]','$_REQUEST[address]','$_REQUEST[city]','$_REQUEST[phone]',
- '$_REQUEST[cell_phone]','$_REQUEST[first_contact]','$_REQUEST[first_relation]','$_REQUEST[first_phone]',
- '$_REQUEST[second_contact]','$_REQUEST[second_relation]','$_REQUEST[second_phone]','$_REQUEST[physician]',
- '$_REQUEST[phy_phone]','$_REQUEST[medical_note]','$_REQUEST[state]','$_REQUEST[zip]','$timstamp','$eyep')";
- $result2 = mysql_query($query2);
- if($result2)
- {
- $first = $_REQUEST['first'];
- $last = $_REQUEST['last'];
- echo "<b>".$first." ".$last."</b>, Thank You for saving your emergency contact information.<br /><br />
- <!--
- <br /><br /><center>
- <form>
- <input type='button' value='Close this window' onClick='window.close()'>
- </form>
- </center>
- <br />
- --> ";
- }
- } // End of else structure connected with if where it checks if it is first time.
- mysql_close($con);
- } // End of if structure where it checks if form is submitted.
- else
- {
- echo "
- <font size='3' face='arial' color=#000000><b> </b></font><br />";
- echo "<form action='index.php' method='post' onSubmit="JavaScript:return fncSubmit();>
- </tr>
- </table>
- <br /><font size='4' face='arial' color=#000000><b>معلومات الكفيل يرجى ملئ جميع الحقول</b></font><br />
- <table border='10' bgcolor='#FFFFFF'>
- <tr>
- <td><font color=#000000 size='4' face='arial'>الاسم الكامل:</font></td><td><input type='text' name='first' size='4' style='width: 11em' /></td>
- <td><font color=#000000 size='4' face='arial'>اللقب:</font></td><td><input type='text' name='last' size='4' style='width: 6em' /></td>
- </tr>
- <tr>
- <td><font color=#000000 size='4' face='arial'>تاريخ الميلاد:</font></td>
- <td>
- <select name='dd'>
- <option SELECTED value='01'>01
- <option value='02'>02
- <option value='03'>03
- <option value='04'>04
- <option value='05'>05
- <option value='06'>06
- <option value='07'>07
- <option value='08'>08
- <option value='09'>09
- <option value='10'>10
- <option value='11'>11
- <option value='12'>12
- <option value='13'>13
- <option value='14'>14
- <option value='15'>15
- <option value='16'>16
- <option value='17'>17
- <option value='18'>18
- <option value='19'>18
- <option value='20'>20
- <option value='21'>21
- <option value='22'>22
- <option value='23'>23
- <option value='24'>24
- <option value='25'>25
- <option value='26'>26
- <option value='27'>27
- <option value='28'>28
- <option value='29'>29
- <option value='30'>30
- <option value='31'>31
- </select>
- <select name='mm'>
- <option SELECTED value='01'>01
- <option value='02'>02
- <option value='03'>03
- <option value='04'>04
- <option value='05'>05
- <option value='06'>06
- <option value='07'>07
- <option value='08'>08
- <option value='09'>09
- <option value='10'>10
- <option value='11'>11
- <option value='12'>12
- </select>
- <select name='yyyy'>
- <option SELECTED value='1900'>1900
- <option value='1901'>1901
- <option value='1902'>1902
- <option value='1903'>1903
- <option value='1904'>1904
- <option value='1905'>1905
- <option value='1906'>1906
- <option value='1907'>1907
- <option value='1908'>1908
- <option value='1909'>1909
- <option value='1910'>1910
- <option value='1911'>1911
- <option value='1912'>1912
- <option value='1913'>1913
- <option value='1914'>1914
- <option value='1915'>1915
- <option value='1916'>1916
- <option value='1917'>1917
- <option value='1918'>1918
- <option value='1919'>1919
- <option value='1920'>1920
- <option value='1921'>1921
- <option value='1922'>1922
- <option value='1923'>1923
- <option value='1924'>1924
- <option value='1925'>1925
- <option value='1926'>1926
- <option value='1927'>1927
- <option value='1928'>1928
- <option value='1929'>1929
- <option value='1930'>1930
- <option value='1931'>1931
- <option value='1932'>1932
- <option value='1933'>1933
- <option value='1934'>1934
- <option value='1935'>1935
- <option value='1936'>1936
- <option value='1937'>1937
- <option value='1938'>1938
- <option value='1939'>1939
- <option value='1940'>1940
- <option value='1941'>1941
- <option value='1942'>1942
- <option value='1943'>1943
- <option value='1944'>1944
- <option value='1945'>1945
- <option value='1946'>1946
- <option value='1947'>1947
- <option value='1948'>1948
- <option value='1949'>1949
- <option value='1950'>1950
- <option value='1951'>1951
- <option value='1952'>1952
- <option value='1953'>1953
- <option value='1954'>1954
- <option value='1955'>1955
- <option value='1956'>1956
- <option value='1957'>1957
- <option value='1958'>1958
- <option value='1959'>1959
- <option value='1960'>1960
- <option value='1961'>1961
- <option value='1962'>1962
- <option value='1963'>1963
- <option value='1964'>1964
- <option value='1965'>1965
- <option value='1966'>1966
- <option value='1967'>1967
- <option value='1968'>1968
- <option value='1969'>1969
- <option value='1970'>1970
- <option value='1971'>1971
- <option value='1972'>1972
- <option value='1973'>1973
- <option value='1974'>1974
- <option value='1975'>1975
- <option value='1976'>1976
- <option value='1977'>1977
- <option value='1978'>1978
- <option value='1979'>1979
- <option value='1980'>1980
- <option value='1981'>1981
- <option value='1982'>1982
- <option value='1983'>1983
- <option value='1984'>1984
- <option value='1985'>1985
- <option value='1986'>1986
- <option value='1987'>1987
- <option value='1988'>1988
- <option value='1989'>1989
- <option value='1990'>1990
- <option value='1991'>1991
- <option value='1992'>1992
- <option value='1993'>1993
- <option value='1994'>1994
- <option value='1995'>1995
- <option value='1996'>1996
- <option value='1997'>1997
- <option value='1998'>1998
- <option value='1999'>1999
- <option value='2000'>2000
- <option value='2001'>2001
- <option value='2002'>2002
- <option value='2003'>2003
- <option value='2004'>2004
- <option value='2005'>2005
- <option value='2006'>2006
- <option value='2007'>2007
- <option value='2008'>2008
- <option value='2009'>2009
- </select>
- </tr>
- <td><font color=#000000 size='4' face='arial'>البريد الالكتروني:</font></td><td><input width='2' type='text' name='email' /></td>
- <td></td>
- <td></td>
- </tr>
- </table>
- <br /><font size='4' face='arial' color=#000000><b>العنوان</b></font><br />
- <table border='10' bgcolor='#FFFFFF'>
- <tr>
- <tr><td><font color=#000000 size='4' face='arial'>الرمز البريدي:</font></td><td><input type='text' name='zip' size='15' style='width: 6em' /></td>
- <td><font color=#000000 size='4' face='arial'>المدينة:</font></td><td><input type='text' name='city' size='15' style='width: 6em' /></td>
- <td><font color=#000000 size='4' face='arial'>البلد:</font></td><td><input type='text' name='physician' size='15' style='width: 6em' /></td>
- </tr>
- <tr>
- <td><font color=#000000 size='4' face='arial'>رقم الهاتف:</font></td><td><input type='text' name='phone' size='15' style='width: 6em' /></td>
- </table>
- <br /><font size='4' face='arial' color=#000000><b>انواع الكفالة</b></font><br />
- <table border='10' bgcolor='#FFFFFF'>
- <tr>
- <td align='right'><font color=#000000 size='4' face='arial'>الكفالة الاعتيادية 68 يورو شهريا: </font></td>
- <td>
- <select name='cell_phone'>
- <option value='0'>العدد
- <option value='01'>1
- <option value='02'>2
- <option value='03'>3
- <option value='04'>4
- <option value='05'>5
- </td>
- <tr>
- <td align='right'><font color=#000000 size='4' face='arial'>كفالة يتامى ذوي الاحتياجات الخاصة 82 يورو شهريا: </font></td>
- <td>
- <select name='first_contact'>
- <option value='0'>العدد
- <option value='01'>1
- <option value='02'>2
- <option value='03'>3
- <option value='04'>4
- <option value='05'>5
- </td>
- <tr>
- <td align='right'><font color=#000000 size='4' face='arial'>كفالة يتامى ضحايا الارهاب 82 يورو شهريا: </font></td>
- <td>
- <select name='first_relation'>
- <option value='0'>العدد
- <option value='01'>1
- <option value='02'>2
- <option value='03'>3
- <option value='04'>4
- <option value='05'>5
- </td>
- <tr>
- <td align='right'><font color=#000000 size='4' face='arial'>كفالة يتامى المتفوقين دراسيا 97 يورو شهريا: </font></td>
- <td>
- <select name='first_phone'>
- <option value='0'>العدد
- <option value='01'>1
- <option value='02'>2
- <option value='03'>3
- <option value='04'>4
- <option value='05'>5
- </td>
- </table>
- <br /><font size='4' face='arial' color=#19a1bf><b>طريقة الدفع</b></font><br />
- <table border='10' bgcolor='#FFFFFF'>
- <tr>
- <td align='right'><font color=#000000 size='4' face='arial'> </font></td>
- <td>
- <select name='second_contact'>
- <option value='-'>شهريا
- <option value='نعم'>نعم
- <option value='لا'>لا
- </td>
- <tr>
- <td align='right'><font color=#000000 size='4' face='arial'> </font></td>
- <td>
- <select name='second_relation'>
- <option value='-'>فصليا
- <option value='نعم'>نعم
- <option value='لا'>لا
- </td>
- <tr>
- <td align='right'><font color=#000000 size='4' face='arial'> </font></td>
- <td>
- <select name='second_phone'>
- <option value='-'>سنويا
- <option value='نعم'>نعم
- <option value='لا'>لا
- </table>
- <br /><font size='4' face='arial' color=#19a1bf><b> مكان الدفع ملاحظة (يرجى كتابة أسم البلد أو المحافظة الذي ترومون الدفع فيه) </b></font><br />
- <table border='10' bgcolor='#FFFFFF'>
- <tr>
- <td><font color=#000000 size='4' face='arial'>يرجى الكتابة هنا:</font></td><td><input type='text' name='k1' size='4' style='width: 11em' /></td>
- </table>
- </td>
- </tr>
- </table>
- <br /><font size='4' face='arial' color=#19a1bf><b>حال رغبتكم دفع مبلغ لليتيم شهريا اكثر من المبلغ اعلاه يرجى كتابة المبلغ في الحقل ادناه </b></font><br />
- <table border='10' bgcolor='#FFFFFF'>
- <tr>
- <td><font color=#000000 size='4' face='arial'>يرجى كتابة المبلغ هنا:</font></td><td><input type='text' name='k3' size='4' style='width: 11em' /></td>
- </table>
- <br /><font size='4' face='arial' color=#19a1bf><b>هل الكفالة</b></font><br />
- <table border='10' bgcolor='#FFFFFF'>
- <tr>
- <td align='right'><font color=#000000 size='4' face='arial'> </font></td>
- <td>
- <select name='k2'>
- <option value='لاول مرة'>لاول مرة
- <option value='إضافة يتيم'>إضافة يتيم
- <option value='إعادة كفالة'>إعادة كفالة
- </td>
- </table>
- <table border='10' bgcolor='#FFFFFF'>
- <tr><td valign='top'><font color=#000000 size='3' face='arial'>هل لديك اي مشكلة او معلومات اضافية لم تكن موجودة في الحقول السابقة يرجى كتابة المعلومات الاضاقية داخل هذا المربع وسوف يرد على حضراتكم موضف قسم الاعلام في مؤسسة العين .</font><br /><textarea name='medical_note' rows='8' cols='85'></textarea></td></tr>
- </table><br />
- </tr>
- <tr>
- </table>
- <br />
- <input name="chk1" type="checkbox" id="chk1" value="Y"><font size='4' face='arial' color=#ff0000><b> ان هذا الطلب يعتبر التزامآ تشريفيآ ادبيآ بين الكفيل واليتيم لذا يرحى مراعاة فقرات دور الكفيل اعلاه مع الدعاء لكم بحسن التوفيق </b></font><br />
- <table border='10' bgcolor='#FFFFFF'>
- <tr>
- </tr>
- <table border='10' bgcolor='#FFFFFF'>
- <input name="btnSubmit" type="submit" value='ارسال الاستمارة' />
- </table><br />
- </form>";
- }
- ?>
- </div>
- </div> <!-- EOF: CONTENT FRAME -->
- </div> <!-- EOF: inner-container -->
- <div id="copyright">
- <div class="left">Copyright © karrar-Hayder </div>
- </div> <!-- EOF: CONTAINER -->
- <!-- EOF: FOOTER INCLUDE -->
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement