PHP - Same Document Form Execution

hey guys... below is my code... when i hit the "submit" button the browser displays the php file rather than writing to the db... can anyone see what im doing wrong .. thanks
Code: [Select]
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td><form name="form1" method="post" action="insert_ac.php">
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="3"><strong>Insert Data Into mySQL Database </strong></td>
</tr>
<tr>
<td width="71">Name</td>
<td width="6">:</td>
<td width="301"><input name="name" type="text" id="name"></td>
</tr>
<tr>
<td>Lastname</td>
<td>:</td>
<td><input name="lastname" type="text" id="lastname"></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><input name="email" type="text" id="email"></td>
</tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>

Code: [Select]
<?php

$host="localhost"; // Host name 
$username=""; // Mysql username 
$password=""; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="test_mysql"; // Table name 

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// Get values from form 
$name=$_POST['name'];
$lastname=$_POST['lastname'];
$email=$_POST['email'];

// Insert data into mysql 
$sql="INSERT INTO $tbl_name(name, lastname, email)VALUES('$name', '$lastname', '$email')";
$result=mysql_query($sql);

// if successfully insert data into database, displays message "Successful". 
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='insert.php'>Back to main page</a>";
}

else {
echo "ERROR";
}

// close connection 
mysql_close();
?>

i wanna put condition that if ($signupbonus > 0.00) then following should not be executed

<font size="3" color="red"><b>Referral bonus: <font color="green" size="4">$<? echo $signupbonus; ?></font></b></font><br><br>

please help

Hello all, newbie here just trying to understand PHP and other languages. As a basic, i understood that exit() function is used to stop something. But, was wondering if below code is right to terminate something. Ref - InterviewBit

<?php
$site = "https://abcdefghijk.com//";
fopen($site,"r")
or exit("Unable to connect to $site");
?>

TIA!!

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\page\verify_security.php on line 170     earlier the code has been running fine and now it is showing error to me , can you tell something more about it ???

Folks,

I am running Linux Commands in PHP.

I am looping through the Domain list and using the below line in my Script:



exec('cp -r '.$source.' '.$destination);



I am using this in a Foreach Statment, so only the last Even in the loop getting executed, because, the loop is running too fast so the Linux command does not even get initiated, only the last even in loop goes through.

What i have done is, i have added a line after exec();

sleep(30);

This gives enough time for Linux command to get executed, but is it efficient way to handle timing liek this?

Do i need to use time_limit() or something like that?

Cheers
Natasha

Hey guys, I was wondering if it is possible to have a value inserted into a table as someone clicks on a link (in order to count views for example)?

thanks!

I would like to have a script that would check certain parameters and if none of them returns TRUE, execute a set of codes. So the idea is somehow like if...else().

Code: [Select]
<?php
// trying to put if() directly within if()
if (
// checking of variables
if (!isset($transaction)) {
echo '<font color="#FF0000">Type of transaction is not set.</font>'. '<br />';
}
else {
if ($transaction == 'sell') {
if (empty($BV)) {
echo '<font color="#FF0000">Book value is not set.</font>'. '<br />';
}
}
}
if (empty($stock)) {
echo '<font color="#FF0000">Stock symbol is not set.</font>'. '<br />';
}
if (empty($price)) {
echo '<font color="#FF0000">Price per share is not set.</font>'. '<br />';
}
if (empty($volume)) {
echo '<font color="#FF0000">Volume of shares is not set.</font>'. '<br />';
}
) {
echo 'Go back and fill out necessary fields.';
}
// if none of the above parameters returns TRUE
else {
echo 'Copy and paste the following in the email that you would be submitting.'
</tr>
<tr>
<td>
switch ($transaction) {
case 'buy':
include('calc_buy.php');
break;
case 'sell':
include('calc_sell.php');
break;
default:
echo '<font color="#FF0000"><b>If you see this message there is something wrong with your session. Please send us a feedback with the details of your session before seeing this message.</b></font>';
}
}
?>

This code returns an error and as I understand the error, it is because of if (if ()). How can I make it work?

Thanks in advance!

Guys, why the following mysql stored procedure taking much more time comparing with firebird one?   1. MySQL stored procedure

CREATE DEFINER=`lxc`@`::1` PROCEDURE `insertData`(IN it INT)
BEGIN
      declare i int Default 0;
      declare str char(4);
      declare p_hash int;
      myloop: loop
      set p_hash = round(rand() * 999);
      set str='book';
      insert into test.users (name,password) VALUES (concat(str,'_',i+1),PASSWORD(p_hash));
      set i = i+1;
      if (i = it) then
        leave myloop;
	end if;
    end loop myloop;
  end

Object info:

Table: users
Columns:
id	int(10) UN PK AI
name	varchar(45) 
password	char(41) 

Time:

mysql> call insertData(10000);
Query OK, 1 row affected (9 min 38.22 sec)

2. Firebird Stored Procedure

SET TERM ^ ;
CREATE PROCEDURE INSERDATA (
    IT integer ) --iteration number
AS
DECLARE VARIABLE i integer; 
BEGIN
i = 0;
while ( i < it ) do
begin
INSERT INTO PRODUCT( CODE,NAME,PASS) VALUES(:i, 'jazz_' || :i, fb_hash(round(rand() * 999)));
i = i + 1;
end
END^
SET TERM ; ^
COMMIT;

Object Info:

Table: product
columns
CODE integer,
NAME varchar(45),
PASS CHAR(41)

Time:  ( for 10 000 records it takes less than 1 sec for execution)

Executing statement...
Statement executed (elapsed time: 0.063s).
31464 fetches, 11084 marks, 0 reads, 0 writes.
10000 inserts, 0 updates, 0 deletes, 5 index, 0 seq.
Delta memory: 24264 bytes.
PRODUCT: 10000 inserts. 
0 rows affected directly.
Total execution time: 0.151s
Script execution finished.

Do you see something wrong in mysql stored procedure code?   jazz.
Edited by jazzman1, 31 July 2014 - 03:21 PM.

Hello,

I have the following code:

<form method="post" action="<?php echo $_SERVER['REQUEST_URI']; ?>" name="loginform" id="loginform" class="niceform" ">

The problem is that the code isn't executed after the action="<?php echo $_SERVER['REQUEST_URI']; ?>" so the result doesn't have css.

Any ideas?

Hello, i've been coding a CLI php mailer which i'm using with a webshell.

My problem shows up when i execute my mailer, the hole server crash or in the best case scenario it slows down a lot.

In the same folder that my script was executing a huge error log appears with this error repeated:

Quote

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-zts-20060613/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
 PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-zts-20060613/ixed.5.2ts.lin' - /usr/local/lib/php/extensions/no-debug-zts-20060613/ixed.5.2ts.lin: cannot open shared object file: No such file or directory in Unknown on line 0


I'm not getting why this happens since i just use normal functions like mail(), fread(), etc. I'm not using any sql function or anything like that.

Any clues?

Another non related thing i wanted to ask was: Is it possible to make an "interactive" cli script? I mean using a similar function like getc() in C or something.

I have this one issue.  While logging in into our system, we call a routine called getToken().  This calls a routine on another server (used to be able to securely access documents).  The issue we have is if that other server goes down, this call fails, and the user isn't able to login.  I want to make it so that even if the other server goes down, users can still login and access our system (just not documents). 

I know that I can't prevent fatal errors or even ignore them, correct (even with set_error_handler)?

Any thoughts?  It's a simple call, here's all it is:


require_once('include/utils.php');
$token=getToken();

Code: [Select]
<?php
//Start session
session_start();

//Include database connection details
require_once('config.php');

//Array to store validation errors
$errmsg_arr = array();

//Validation error flag
$errflag = false;

//Connect to mysql server
$link = mysql_connect($hostname, $username, $password);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db($dbname);
if(!$db) {
die("Unable to select database");
}

//Function to sanitize values received from the form. Prevents SQL injection
function clean($str) {
$str = @trim($str);
if(get_magic_quotes_gpc()) {
$str = stripslashes($str);
}
return mysql_real_escape_string($str);
}

//Sanitize the POST values
$login = clean($_POST['login']);
$password = clean($_POST['password']);

//Input Validations
if($login == '') {
$errmsg_arr[] = 'Login ID missing';
$errflag = true;
}
if($password == '') {
$errmsg_arr[] = 'Password missing';
$errflag = true;
}

//If there are input validations, redirect back to the login form
if($errflag) {
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
if( isset($_SESSION['ERRMSG_ARR']) && is_array($_SESSION['ERRMSG_ARR']) && count($_SESSION['ERRMSG_ARR']) >0 ) {
echo '<ul class="err">';
foreach($_SESSION['ERRMSG_ARR'] as $msg) {
echo '<li>',$msg,'</li>'; 
}
echo '</ul>';
unset($_SESSION['ERRMSG_ARR']);
}
session_write_close();
header("location: index.php");
exit();
}

//Create query
$qry="SELECT * FROM members WHERE login='$login' AND passwd='".md5($_POST['password'])."'";
$result=mysql_query($qry);

//Check whether the query was successful or not
if($result) {
if(mysql_num_rows($result) == 1) {
//Login Successful
session_regenerate_id();
$member = mysql_fetch_field($result);
$_SESSION['SESS_MEMBER_ID'] = $member['member_id'];
$_SESSION['SESS_FIRST_NAME'] = $member['firstname'];
$_SESSION['SESS_LAST_NAME'] = $member['lastname'];
session_write_close();
header("location: member-index.php");
exit();
}else {
//Login failed
header("location: login-failed.php");
exit();
}
}else {
die("Query failed");
}
?>
This is my login execution script and when i run it, i get this -

Fatal error: Cannot use object of type stdClass as array in /home/a8029060/public_html/login-exec.php on line 75

Please any help :/

Hi All,   I'm hoping somebody would be able to help me with a performance issue I'm having with a bit of code I've written.   The setup:   Client request arrives on Apache2 reverse proxy over HTTPS. SSL is offloaded and proxy initiates connection to backend development web server over standard HTTP. The website is being developed using HTML5 syled with CSS, Javascript (to dynamically show counters on message text area, perform client side validation for browsers that do not support the build in HTML5 input validation) and PHP for server side validation and form submission (sends email to webadmin).   The development web server is located in a LXC container on the production web server. The host server presents the "public" IP address to the physical network and uses UFW to NAT all traffic inbound and outbound from the development website to trick the network into thinking that the server is on the physical network (Only way to get it routeable across the rest of the network).   The problem: On form submission, if I intentionally leave the fields blank and turn off client side validation, the script echos "An error occured in your form, please check to make sure that all relevent fields are filled in!!!". This response returns in 16.50ms with a latency of 34.92ms. The POST appears instantly in the Apache2 logs less than a second after I submit the form.   If I submit the form with all fields (Name, Email, Phone, Website, Subject and Message), it takes 60 - 65 seconds before Apache logs the POST has arrived. I'm not entirely sure why its taking this long for the server to receive the content. GET Requests are pretty much instant as I would expect. Could this be an issue with inefficient scripting that maye be causing this type of delay? This issue occurs regardless of whether I use firefox or Safari.   Could this be a result of inefficient scripting? Using timelines in Safari and on form submission with content, I get 1.0min latency with an actual duration/script run time of 5.336ms. Where would this latency be coming from? Standard GET requests for HTML and CSS content is instant, next to no latency but once the Payload increases in size, it seems like I run into the issue.   Any views, thoughts or possible things to try would be hugely appreciated. I'm learning the ropes with scriping at the moment but this high latency, as a hunch, appears to be server related. Happy to upload the submit.php script and web form if it will help.   Many Thanks, A  

Is there any simple way I can log the execution time of each mysql query that is executed on a page, maybe with a register shutdown function, I have been trying to profile and reduce execution time of the CRM / tracking system at work and have used a register shutdown function to log page execution time. We were unsure of wither it was the internet connection, browsers having a hard time rendering nested tables(the code is OLD), or mysql queries taking too long to execute.


Yesterday I started re-coding a script and I got to a query, it returned one row/field and had a limit 1, but it searched for an md5 has in the where clause, as soon as I added this query in my re-code it took execution time from 1s to 13s, I ran the query in phpmyadmin and the execution time was 0.5s, this was running in a loop which returned about 20 rows, I added an index on the md5 hash field and the query then took 0.0005s to load, I now want to do this for all scripts on the system.


Any ideas?

Thanks

// EDIT,

please note that I don't have shell access, I only have access to the scripts, plesk panel and PHPmyadmin

I have a simple script that imports all images in a folder to my site and generates thumbnails. It works, but on folders with a rather large amount of images (500+) it can reach the max execution time and give a fatal error.

I could always break up my import folders into smaller chunks or increase the max execution time, but I am wondering if there is a different approach I could take.

Is there a way to reset the execution time of a script by inserting some kind of a pause/delay?