Jump to content

Adam_Duski

Members
 View Profile  See their activity

  • Posts

    19

  • Joined

  • Last visited

 Content Type 

Posts posted by Adam_Duski

    Encrypting password in Mysql

    in MySQL Help

    Posted

    Hey , i have a problem in encrypting a password in mysql 

    in the register form if anyone registered make their password encrypt in mysql database but when i want to login i must used the encrypting password ,,

    is there's a way to use that password i entered in register form for e.g ( 1234 ) not the encrypted password  

    Countdown not working

    in Javascript Help

    Posted

    Hey Guys ! i'm not sure if i posted my topic in the right side 
    anyway ..

    i have a countdown.js file everything is OK  , but the big problem is the countdown not working at all ,( Days , Hours ,Min , Sec) all of this keeps in zero

    but the count UP work normal  :o 

    this is the source code : 

    http://jsfiddle.net/NdfPR/2/

     

    in line 29 and 30 

    until: new Date(2014, 4 - 1, 4, 0, 0, 0), 
since: null,

    nothing happen with this code but if i changed to this 

    until: null,
since:  new Date(2014, 4 - 1, 4, 0, 0, 0), 

    the count up will work and i don't count up  ,, 

    this js file is linked to my template so if there's anything to solve this problem ,, 

    i'm here if i forget anything to  :happy-04:

     

     

    getting data from table to Select Tag !

    in Javascript Help

    Posted

    i have the code that u post it and i didn't change anything on it , 

     

    now, i want to call the data from tables in my database 

     

    for e.x : when i choose the option #1 

    bring me the data from table (web) and showing all data in that table in the student tag 

     

    and when i choose the option #2 

    bring me the data from table (net) and showing all data in that table in the student tag 

     

    and when i choose the option #3 

    bring me the data from table (prog) and showing all data in that table in the student tag 

     

    that's all i want ! 

    getting data from table to Select Tag !

    in Javascript Help

    Posted

    Hi , 

     

    i have a database (dept_db) it contents of 3 tables (web , net , prog) ,

     

    634185979.png

     

    when i choose Dept like for example i makes Dept to (Web) so the (Web) group appears in the Students that get the inserted data from web table and display it in Students .and when i choose (Net) the Net group appears ,and when i don't choose any group ,i want it to disable the Students Select Tag 

     

    which function must i use and where and how  ! 

     

     

    this is a example :

    http://www.redsn0w.us/2010/03/download-direct-links-jailbreak-guides.html

     

    322886643.png

     

     

    how to select a number over 20 ?

    in MySQL Help

    Posted 



    
<html>
    
<head>
    
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256" />
    
<title>Movie</title>
    
<link href="style/style.css" rel="stylesheet" type="text/css" />


    
</head>


    
<body>
    
    <form action="form.php" method="POST">


    
<div id="container">
    
<div id="header"><div id="header_left"></div>
    
<div id="header_main"><b><font face="Arial" style="font-size: 14pt">Movie Details</font></b></div><div id="header_right"></div></div>
    
    <div id="content">
    
        <table class="countTable">




    
           <tr>
    
                <tr><th colspan="2" id="remain"><span style="font-weight: 400">
    
           
    
           </font></td><td>




    
         <tr><td><font style="font-size: 14pt" color="#0066FF">
    
          NO     <select name="no">  
    
                <option ></option>
    
<?php
    
  include 'config.php';
    
  mysql_select_db("mov_db",$con);
    
  $result=mysql_query("SELECT * from mov");
    
 while($row=mysql_fetch_array($result))


    
{  
    
   echo "<option value=".$row['no'].">".$row['no']."</option>";
    
}
    
?>
    
  </select>
    
  <br>
    
         Name <input type="text" name="name">
    
<br>
    
<br>
    
Type <input type="text" name="type">


    
<br>
    
<br>
    
Rating <input type="text" name="rating"> 


    
<br>
    
<br>


    
Stars <input type="text" name="stars"> 


    
<br>
    
<br>
    
QTY <input type="text" name="qty"> 


    
<br>
    
<br>
    
Price <input type="text" name="price"> 


    
<br>
    
<br>
    
<input type="submit" value="Send" class="inp2" name="submit">
    
<input type="hidden" name="formsend" value="1">
    
<br>
    
<br>
    
<center>
    
<?php


    
include "config.php";
    
mysql_select_db("mov_db", $con);
    
$select = mysql_query("SELECT * FROM mov ORDER BY no ASC");
    
echo "<table border=1 >";
    
echo "<tr>";
    
echo "<th>NO</th>";
    
echo "<th>Name</th>";
    
echo "<th> Type</th>";
    
echo "<th> Rating </th>";
    
echo "<th>Stars</th>";
    
echo "<th>QTY</th>";
    
echo "<th>Price</th>";
    
echo "<th>Update</th>";
    
echo "<th>Delete</th>";
    
echo "</tr>";


    
while($row=mysql_fetch_array($select)) {
    
  
    
echo "<tr>"; 
    
    echo "<td>" .$row['no'] ."</td>";
    
    echo "<td>" .$row['name'] ."</td>";
    
    echo "<td>" .$row['type'] ."</td>";
    
    echo "<td>" .$row['rating'] ."</td>";
    
    echo "<td>" .$row['stars'] ."</td>";
    
    echo "<td>" .$row['qty'] ."</td>";
    
    echo "<td>" .$row['price'] ."</td>";
    
    echo "<td>"."<input type='submit' value='Update' class='inp' name='update'>". "</td>";
    
    echo "<td>"."<a href='form.php?id=$row[no]'> Delete </a>". "</td>";
    
 echo"</tr>";




    
}
    
 echo "</table>";


    
if(isset($_GET["id"]))
    
{
    
mysql_query("DELETE FROM mov WHERE no=".$_GET["id"]);
    
}


    
if(isset($_POST['update']))
    
{


    
include "config.php";


    
mysql_select_db("mov_db",$con);
    
mysql_query("UPDATE mov SET name='$_POST[name]', type='$_POST[type]' , rating='$_POST[rating]' , stars='$_POST[stars]' , qty='$_POST[qty]' , price='$_POST[price]' WHERE no=$_POST[no]");
    
}
    
?> 
    
<?php
    
include "config.php";
    
mysql_select_db("mov_db", $con);
    
$select = mysql_query("SELECT no FROM mov ORDER BY no WHERE mov ASC limit 0,1");
    
echo "<br>";
    
echo "<table border=1 >";
    
echo "<tr>";
    
echo "<th>Total</th>";


    
echo"</tr>";


    
echo"<tr>";


    
$result = mysql_query("SELECT count(1) FROM mov");
    
$row = mysql_fetch_array($result);
    
echo "<td>";
    
$total = $row[0];
    
echo "Total Films: " . $total;
    
echo "</td>";
    
echo "</tr>";
    
 echo "</table>";


    
?>


    
<br>


    
<?php


    
include "config.php";
    
mysql_select_db("mov_db", $con);
    
$movies_table = "mov";
    
$query = "SELECT no,name,price from $movies_table where price >20 order by no DESC;";
    
echo "<table border=1 >";
    
echo "<tr>";
    
echo "<th>NO</th>";
    
echo "<th>Name</th>";
    
echo "<th>Price</th>";
    
echo "</tr>";


    
while($row=mysql_fetch_array($select)) {
    
  
    
echo "<tr>"; 
    
    echo "<td>" .$row['no'] ."</td>";
    
    echo "<td>" .$row['name'] ."</td>";
    
    echo "<td>" .$row['price'] ."</td>";
    
 echo"</tr>";




    
}
    
 echo "</table>";


    
?>


    
<br>


    
<br>
    
</font></td><td>
    
</center>
    
<br>
    
<br>


    
  <tr><th colspan="2" id="remain"><span style="font-weight: 400">
    
      
    
           <tr><td><font face="Tahoma" style="font-size: 10pt" color="#0066FF">
    
           <a href="https://wwww.facebook.com/Ahmed.Pirumeri">Ahmed K.Mustafa</a>
    
           </font></td><td>
    
      <font face="Tahoma" style="font-size: 10pt"></font></td></tr>
    
       </table>
    
    </div>
    
</div>
    
</form>
    
</body>
    
</html>


    
<?php 
    
if(isset($_POST['formsend']))
    
{
    
if(isset($_POST['submit']))
    
{
    
if($_POST["name"]!=""){


    
include 'config.php';
    
mysql_select_db("mov_db",$con);


    
$insert="INSERT INTO mov 
    
        values ('$_POST[no]','$_POST[name]','$_POST[type]','$_POST[rating]','$_POST[stars]','$_POST[qty]','$_POST[price]')";
    
mysql_query($insert,$con);
    
}
    
}
    
header("Location: form.php");
    
}
    
?>


    how to select a number over 20 ?

    in MySQL Help

    Posted

    You should show us your database schema!

     

    It should be something like:

    SELECT movie.name FROM db_name.movie WHERE movie.type='Drama' AND movie.price > 20 ORDER BY movie.price DESC

    PS: Sorry @dalecosp :)

     

    Thanks , but  i want to display a list of all movies with price over 20 and sorted by price in table ,, 

    and display information only drama movie in another table .. 

     

    i will put the full source 

    how to select a number over 20 ?

    in MySQL Help

    Posted

    You'll want to use some valid SQL for this:

     

    $select = mysql_query("SELECT "); //this won't work :-(
 
//try this instead
$movies_table = "name_of_your_table";
$query = "select no,name,price from $movies_table where price >20 order by price DESC;";
$select = mysql_query($query);

     

    give error 

    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\movie\form.php on line 158158

    how to select a number over 20 ?

    in MySQL Help

    Posted

    Hi ,, 

     

    i have this code 

     

    <?php


include "config.php";
mysql_select_db("mov_db", $con);
$select = mysql_query("SELECT ");
echo "<table border=1 >";
echo "<tr>";
echo "<th>NO</th>";
echo "<th>Name</th>";
echo "<th>Price</th>";
echo "</tr>";


while($row=mysql_fetch_array($select)) {
  
echo "<tr>"; 
    echo "<td>" .$row['no'] ."</td>";
    echo "<td>" .$row['name'] ."</td>";
    echo "<td>" .$row['price'] ."</td>";
 echo"</tr>";




}
 echo "</table>";


?>

    and i want to display a list of all movies with price over 20 and sorted by price ..

    how i can select ?

    ,,,,

     

    in another table i want to display information of all drama movie in "type" field because their is different type, i want just display drama   !! 

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.