PHP - Auto Updating Sitemap With Auto Submit

I have a template written for me on another project that searches a MySQL database.

I'm moving this template to work with a database that only have 10 records in it and instead of having a search option

I would just like it to automatically display the database when the page opens. Is this possible?

The php page in close to 200 lines. This is the line of the code that has the search option. If you need more I can post it.

Thanks
Bob


Code: [Select]

<div id="search">
            <form action="parts.php" method="GET">
            Search: <input type="text" value="'.htmlentities($_GET['s']).'" name="s"/> <input type="submit" value="Search!"/>
           </form>
</div>

Can someone help me with this.. I cannot figure out why it will not log in..  The actual url and user/pass are valid so feel free to test the live site.



<?php 
// INIT CURL 
$ch = curl_init(); 
 
// SET URL FOR THE POST FORM LOGIN 
curl_setopt($ch, CURLOPT_URL, 'http://www.handy-hanky.com/shirley/homesell_cron.htm'); 
 
// ENABLE HTTP POST 
curl_setopt ($ch, CURLOPT_POST, 1); 
 
// SET POST PARAMETERS : FORM VALUES FOR EACH FIELD 
curl_setopt ($ch, CURLOPT_POSTFIELDS, 'user=tom&pass=test&login_theme=cpanel'); 
 
 
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); 
 
// EXECUTE 1st REQUEST (FORM LOGIN) 
$store = curl_exec ($ch); 
 
echo "STORE = $store<br>";


// CLOSE CURL 
curl_close ($ch);  
 
?>

Hi all !   I wish to post the value of an auto submit dropdown value to another page, be redirected to that page, and  use it on that page. I am unable to achieve this in php and so I tried as :-follows:-   dropdown.php

<form method="post" action = dropdownaction.php>
    <select name="myselect" onchange="this.form.submit();">
        <option>blue</option>
        <option>red</option>
    </select>
</form>

and now I need the equivalent of    dropdownaction.php

<?php

if(isset($_POST(['myselect']))) echo " I am selected".$_POST['myselect'];

?>

Please can someone tell me how I may retrieve the value of 'myselect' in the dropdownaction.php after being redirected to it. Thanks loads.  

From my experience, using Google's sitemap generator to generate a sitemap is not that good. It creates page that you do not want to show up.  I am wondering what the best method is for creating a sitemap of a website so that only certain pages of the website show up on Google?

Hi all,

I am having some trouble with a part of code. Basically the code is set for a Factory to produce 750 items every 30 minutes. It does this fine IF AND ONLY IF someone clicks the Factory page. For example, it produces 750 bullets, then I leave the page alone for say 20 minutes, but when I click back, it doesn't have 10 minutes left before the next produce. Instead, It has 30 minutes. So it only produces when someone on the game clicks the page. I have tried the basic html refresh but that doesn't work.

Any idea's?

Thanks in advance

Hello,

I am creating a job setup form and have a need for the job id field to increment based on the last inserted job id into our Oracle database.
So far I have created a function that selects the maximum job id from the job table and adds 1 to the number.

However, I run into the problem of when a user is filling out the form and another user opens it and begins filling out the form they both will receive the same job id in the field. I'm assuming this could possibly be solved with sessions, but I'm not sure where to start.

Also, the form is not inserted into the table on submit (instead an excel sheet is created with the information and someone will enter the data into the database manually). Since the form data can be entered anytime from completion to next week/two weeks, how can I ensure that that job id is not used again.

Thanks

I have an issue with my delete feature on my site.  A user selects a photo to delete.  It then takes them to the are you sure you want to do this page with the id of the image under  delete polaroid.  This page has the following code on it....
 <div id="editindexpage">
           <?php
    $qGetId  =  "SELECT * FROM `polaroids` WHERE id='".$_GET['delete_polaroid']."'";
   $result = mysql_query($qGetId) or die (mysql_error()) ;
$pola=mysql_fetch_array($result);
 
$GetCat = "SELECT * FROM category WHERE cat_name='".$pola['catid']."'";
$Result = mysql_query($GetCat);
$GotCat = mysql_fetch_assoc($Result);

?>         
        <p class="bold">Are you sure you want to delete <?php echo $GotCat['cat_name'];?> and its image from the database?</p><br/>

 
        <a href="polaroids.php?delete_comp=
<?php mysql_query("DELETE FROM polaroids WHERE id='".$_GET['delete_polaroid']."'");
mysql_query("DELETE FROM category WHERE cat_name='".$pola['catid']."'");
?>">Yes</a>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

<a href="polaroids.php">No</a>
</div>

My issue is this.  Even if you select no for some reason it deletes the selected file.  I dont understand how this is possible can anybody please help?

Thank you

Html code Code: [Select]
<div id="feedback">
          <p class="error wrong_name"> Fill the correct name</p>
          <p class="error wrong_email"> Incorrect email</p>
          <p class="error wrong_message"> Enter your message</p>
        </div>
        <form action="sendemail.php" id="contact_us" method="post">
          <p class="label_name">Name</p>
          <p class="input_form">
            <input type="text" name="Name" width="20"/>
          </p>
          <p class="label_name">Email</p>
          <p class="input_form">
            <input type="text" name="Email" />
          </p>
          <p class="label_name">Message</p>
          <p class="input_form" id="textarea">
            <textarea name="Message" rows="5" cols="4" id="message_input"></textarea>
          </p>
          <p id="submit">
            <input type="submit" value="Send" name="submitButton" class="button" />
          </p>
        </form>
        <p id="success">Your message was sent succesfully!</p>



Php code Code: [Select]
<?php
$mailTo = 'vmoore@minoritybiz.org';
$name = htmlspecialchars($_POST['Name']);
$mailFrom = htmlspecialchars($_POST['Email']);
$subject = 'Information Request';
$message_text = htmlspecialchars($_POST['Message']);

$message =  'From: '.$name.'; Email: '.$mailFrom.' ; Message: '.$message_text;

mail($mailTo, $subject, $message);

?>
this works  real simple I would like to add a auto respond to the person click the submit button.

Hello

can anyone tell me why this function don't return anything ?


<?php include_once('./header.php'); ?>

<?php
    $var = Array();
    $data = $db->get("omnot", "fullname");
    
    foreach($data as $var){
        $var = $data;        
    }
    $input = strtolower( $_GET['input'] );   // the input is ok
    $len = strlen($input);
    
    
    $aResults = array();
    
    if ($len)
    {
        for ($i=0;$i<2;$i++)
        {
            if (strtolower(substr(utf8_decode($var),0,$len)) == $input)
                $aResults[] = array( "id"=>($i+1) ,"value"=>htmlspecialchars($var[$i]));
        }
    }


from the database i get the values: "roey" , "rrr" , "try"
input == r

why the function don't go to the line:  Code: [Select]
$aResults[] = array( "id"=>($i+1) ,"value"=>htmlspecialchars($var[$i]));
whats wrong with the IF ?

is there a way to auto refresh the same page youre on after a script runs?

Hey,

In my table, I have 773 rows like this:

10800 ...
772 ...
771 ...
770 ...
769 ...
etc ...

When I insert a new row, it will have an ID of 10801 and not 773.
I delete row 10800 and I want to insert a new row that has an ID of 773.

Is there a code I can use also so that it creates the IDs in order?
1, 2, 3 etc no missing numbers.

Thanks.

Hello, I am making a Status Page for servers in general. It has Uptime(In %) and Status(Online/Offline).

I have a database it loads this from, (Failed, Success, and Status)
Here's an example of how it works.
Code: [Select]
Failed = 0
Success = 1
Php code calculates the uptime, and prints 100%
Status = 1
Status: Online

What I am trying to do, it make the site run through Hosts and Ports at the same time, and update the databases with the updated info.

Example
Code: [Select]
It updates, and Google was offline.
Failed = 1
Success = 1
Calculates the uptime to 0%
Status = 0
Status: Offline

Any way of doing this easily, because this will be something I might release to the public, and I want it user friendly.

P.S. This is will be using fsocketopen.

Hi, i need to code a script that login to a website after supplying a username and password, then downloads a file after every 24 hrs. Any suggestions ??

Hi I am trying to send a auto email to a variable email address throught php. But im not sure how to do it? I think this is the kind of php code I have to use:

$to = "<?php echo $Adminmail ?>";
$subject = "Join Faction Request!";
$message = "<?php echo $user wishes to join your faction?>";
echo "Mail Sent.";

Also how would i send php code in the email?

Any help would be great thanks 

Freid001

Hi..

I have code for auto generate but I got encountered problem that the SR number did not generate they still 120330001 even though I already save that SR number in my database.

I want to happen is after I click the save button the SR number will be 120330002.

here is my code:

Code: [Select]
<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date =date('Y-m-d H:i:s');

 $sql = "SELECT sr_number FROM receiving_materials ORDER BY sr_date DESC LIMIT 1"; 
        $result = mysql_query($sql, $con);
        if (!$result) {
            echo 'failed'; 
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
        } 
        else {
//------------------------------------------------------------------------------------------------------------------
            // Stock Number iteration.... 
            $row = mysql_fetch_assoc($result);
            
            $currentSRNum = (int)(substr($row['sr_num'],0,3));
            
            $currentSRYear  = (int)(substr($row['sr_num'],2,2));
            $currentSRMonth = (int)(substr($row['sr_num'],0,2));
            
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));
            
            
            if ($currentYear == $currentSRYear) {
                if ($currentMonth == $currentSRMonth) {
                    $currentSRNum = $currentSRNum + 1;
                }
                if ($currentMonth > $currentSRMonth) {
                    $currentSRNum = 1;
                }
                if ($currentDay > $currentSRDay) {
                    $currentSRNum = 1;
                }
            }  
            if ($currentYear > $currentRefYear) {      
                $currentSRNum = 1;                    
            }                                          
        }
//------------------------------------------------------------------------------------------------------------------         
        $yearMonth = date('ymd');    
        $currentSR = $yearMonth . sprintf("%04d", $currentSRNum); 
        
        
$sr_date = $_GET['sr_date'];
$sr_number = $_GET['sr_number'];
$si_num = $_GET['si_num'];
$s_name = $_GET['s_name'];
$po_num = $_GET['po_num'];
$qty = $_GET['qty'];
$mat_code = $_GET['mat_code'];
$mat_desc = $_GET['mat_desc'];
$wh_code = $_GET['wh_code'];
$bin_loc = $_GET['bin_loc'];        
?>
<html>
<title>Stock Requisition</title>
<head>
<style type="text/css">
#ddcolortabs{
margin-left: 2px;
padding: 0;
width: 100%;
background: transparent;
voice-family: "\"}\"";
voice-family: inherit;
padding-left: 2px;
}

#ddcolortabs ul{
font: bold 12px Arial, Verdana, sans-serif;
margin:0;
padding:0;
list-style:none;
}

#ddcolortabs li{
display:inline;
margin:0 2px 0 0;
padding:0;
text-transform:uppercase;
}


#ddcolortabs a{
float:left;
color: white;
background: #8cb85c url(layout_image/color_tabs_left.gif) no-repeat left top;
margin:2px 2px 0 0;
padding:0px 0 1px 3px;
text-decoration:none;
letter-spacing: 1px;
}

#ddcolortabs a span{
float:right;
display:block;
/*background: transparent url(layout_image/color_tabs_right.gif) no-repeat right top;*/
padding:6px 9px 2px 6px;
}

#ddcolortabs a span{
float:none;
}


#ddcolortabs a:hover{
background-color: #678b3f;
}

#ddcolortabs a:hover span{
background-color: #678b3f ;
}

#ddcolortabs #current a, #ddcolortabs #current span{ /*currently selected tab*/
background-color: #678b3f;
}
</style>
<style>
#SR_date{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .9em;
    margin-left: 10px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
   
}
#SR_number{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .9em;
    margin-left: 410px;
    top : 10px;
   
}
table {         
    margin: 10px;
    font-family: Arial, Helvetica, sans-serif; 
    font-size: .9em;
    border: 1px solid #DDD;
}

th {
    font-family: Arial, Helvetica, sans-serif;
    font-size: .7em;
    background: #694;
    color: #FFF;
    padding: 2px 6px;
    border-collapse: separate;
    border: 1px solid #000;
}   

td {
    font-family: Arial, Helvetica, sans-serif;
    font-size: .7em;
    border: 1px solid #DDD;
    text-align: left;
}

#RequestedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 10px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
}

#ApprovedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 15px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
}

#ReceivedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 15px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
}

#SI_number{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .9em;
    margin-left: 10px;
    width: auto;
    height: auto;
    float: left;
    top : 20px;
   
}
.LLabelRM {
display: block;
float: left;
width: 7em;
margin-right: 10px;
}

.LLabelSecRM {
display: block;
float: left;
width: 7.7em;
margin-left : 0px;
}

.LFieldRM {
float: left;
margin-right: 595px;   
}

.LFieldSecRM {
float: left;
margin-right: 15px;   
}
.LFieldSec1RM {
float: left;
margin-right: 350px;   
}
#save_btn {
    position: relative;
    top: 25px;
    margin-left: 7px;
}

</style>

<script type="text/javascript">
function save_rm(){
    var sr_date = document.getElementById("sr_date").value;
    var sr_number = document.getElementById("sr_number").value;
    var si_num = document.getElementById("si_num").value;
    var s_name = document.getElementById("s_name").value;
    var po_num = document.getElementById("po_num").value;
    var qty = document.getElementById("qty").value;
    var mat_code = document.getElementById("mat_code").value;
    var mat_desc = document.getElementById("mat_desc").value;
    var wh_code = document.getElementById("wh_code").value;
    var bin_loc = document.getElementById("bin_loc").value;

    document.receiving_form.action="ReceivingMaterialsSave.php?sr_date="+sr_date+"&sr_number="+sr_number+"&si_num="+si_num+
    "&s_name="+s_name+"&po_num="+po_num+"&qty="+qty+"&mat_code="+mat_code+"&mat_desc="+mat_desc+"&wh_code="+wh_code+
    "&bin_loc="+bin_loc;
    document.receiving_form.submit();
}
</script>
</head>
<body>
<form name="receiving_form">
<div id="ddcolortabs">
<ul>
<li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>
<li id="current"><a href="ReceivingMaterials.php" title="Receiving Materials"><span>Receiving Materials</span></a></li>
<li><a href="StockRequisition.php" title="Stock Requisition"><span>Stock Requisition</span></a></li>
<li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li>
</ul>
</div>
<div id="SR_date">
<label>Date :</label>
<input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly" style="border: none;">   
</div>
<div id="SR_number">
<label>RM# :</label>
<input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="9" readonly="readonly" style="font-weight: bold; border: none;">
</div>
<div id="SI_number">
 <label class="LLabelRM">SI/DR# :</label>
<input type="text" name="si_num" id="si_num" class="LFieldRM" value="" size="25">
<label class="LLabelRM">Supplier Name :</label>
<input type="text" name="s_name" id="s_name" class="LFieldRM" value="" size="25">
<label class="LLabelSecRM">PO # :</label>
<input type="text" name="po_num" id="po_num" class="LFieldSecRM" value="" size="25">
<label class="LLabelSecRM">Quantity :</label>
<input type="text" name="qty" id="qty" class="LFieldSec1RM" value="" size="25">
<label class="LLabelSecRM">Material Code :</label>
<input type="text" name="mat_code" id="mat_code" class="LFieldSecRM" value="" size="25">
<label class="LLabelSecRM">Material Desc. :</label>
<input type="text" name="mat_desc" id="mat_desc" class="LFieldSec1RM" value="" size="25">
<label class="LLabelSecRM">WH Code :</label>
<input type="text" name="wh_code" id="wh_code" class="LFieldSecRM" value="" size="25">
<label class="LLabelSecRM">BIN Location :</label>
<input type="text" name="bin_loc" id="bin_loc" class="LFieldSec1RM" value="" size="25">
</div>
<div id="save_btn">
<input type="button" name="save" value="save" onclick="save_rm()">
</div>
</form>
</body>
</html>

<?php

    $sql = "INSERT INTO receiving_materials
    (sr_date, sr_number, si_num, s_name, po_num, qty, mat_code, mat_desc, wh_code, bin_loc)
    VALUES
    ('$sr_date', '$sr_number', '$si_num', '$s_name', '$po_num', '$qty', '$mat_code', '$mat_desc', '$wh_code', '$bin_loc')
    ON DUPLICATE KEY UPDATE
    sr_date = '$sr_date', sr_number = '$sr_number', si_num = '$si_num', s_name = '$s_name', po_num = '$po_num',
    qty = '$qty', mat_code = '$mat_code', mat_desc = '$mat_desc', wh_code = 'wh_code', bin_loc = '$bin_loc'";
    $res_receiving = mysql_query($sql, $con) or die(mysql_error());
?>


any help is highly appreciated.

Thank you