الشرح على اليوتيوب
كود PHP:
<?php
function Number_Type($number)
{
if($number % 2)
{
return $result= "Odd";
}
else{
return $result= "Even";
}
}
/*
*
*
*
*/
if(isset($_GET['msg']))
{
$msg = $_GET['msg'];
$successful_guess = $_GET['success'];
$number = $_GET["number"];
if($successful_guess==0)
{
echo $number;
}
if($successful_guess==1)
{
$number=rand(1,99);
$number=$number|1;
echo $number;
}
}
else
{
$msg= "Welcome to the guessing game";
$number=rand(1,99);
$number=$number|1;
echo $number;
}
?>
<!DOCTYPE html>
<html lang="en" dir="ltr">
<head>
<**** charset="utf-8">
<title>Guess Secret</title>
</head>
<body>
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="POST">
<div>
<h1><?php echo $msg; ?></h1>
<label>Try and guess a random odd number between 1 and 99
<input type="hidden" name="number" value="<?php echo $number;?>"</label>
<input type="text" name="guess" required></br>
<input type="submit" name="submit" value="Check">
</div>
</form>
</body>
</html>
<?php
if (isset($_POST['submit']))
{
$guessed_By_user = $_POST["guess"];
$number = $_POST["number"];
$result = Number_Type($guessed_By_user);
if($result == "Odd" )
{
if( $number == $guessed_By_user)
{
$msg ="You guessed correctly. Now try to guess another number";
$successful_guess=1;
header("location:guess.php?msg=$msg&success=$successful_guess&number=$number");
}
if( $number < $guessed_By_user)
{
$msg ="Your guess is bigger than the secret number";
$successful_guess=0;
header("location:guess.php?msg=$msg&success=$successful_guess&number=$number");
}
if( $number > $guessed_By_user)
{
$msg ="Your guess is smaller than the secret number";
$successful_guess=0;
header("location:guess.php?msg=$msg&success=$successful_guess&number=$number");
}
}
else{
$msg="The number you are guessing Odd!!!";
$successful_guess=0;
header("location:guess.php?msg=$msg&success=$successful_guess&number=$number");
}
}
?>
كود PHP:
INSERT INTO `student` (`student_id`, `firstname`, `lastname`) VALUES ('123', 'Some', 'One'), ('125', 'Another', 'One'), ('167', 'Good', 'One');
INSERT INTO `grades` (`student_id`, `gpa`) VALUES ('123', '2.34'), ('125', '3.21'), ('167', '3.86');
CREATE TABLE `student` (
`student_id` int(5) NOT NULL,
`firstname` varchar(255) CHARACTER SET utf8 NOT NULL,
`lastname` varchar(255) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `grades` (
`student_id` int(5) NOT NULL,
`gpa` double NOT NULL,
PRIMARY KEY (`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SELECT
CONCAT(LEFT(`student`.`firstname`, 1), ".", `student`.`lastname`) AS name,
`grades`.`gpa`
FROM `Student_DB`.`student`
LEFT JOIN `Student_DB`.`grades`
ON `student`.`student_id`= `grades`.`student_id`
WHERE `grades`.`gpa`> 3.5;
التعديل الأخير تم بواسطة mutaib ; 06-09-2020 الساعة 02:42 PM
mutaib متصل الآن أضافة تقييم إلى mutaib تقرير بمشاركة سيئة
08-09-2020, 11:23 PM
.jpg){kind=icon}
حل 2017/2018 tma
رد: حل 2017/2018 tma
العرض العادي
