fabxl
Threadersteller
Dabei seit: 19.07.2005
Ort: Augsburg
Alter: 50
Geschlecht:
|
Verfasst Do 17.12.2009 23:06
Titel php script vereinfachen? |
 |
|
hallo zusammen,
ich habe dieses script aus einem tutorial. mußte es allerdings stark erweitern (ursprünglich ist es ausgelegt für 6 objects jetzt sind es 28...) die daten kommen aus einer flash datei.. nun das problem: die übertragung zur datenbank klappt nur ungefähr jedes 10 mal.. kann das an meiner "unprofessionellen erweiterung liegen? und wenn ja wie kann ich das vereinfachen.. hab von php keine ahnung, hab zwar verstanden was das teil macht aber um es selbst zu ändern reicht es leider nicht..
bin für jeden tipp dankbar!!!
Code: | <?php
include("db.php");
$table = 'ecards';
$message_text = $_GET['message_text'];
$to_name = $_GET['to_name'];
$from_name = $_GET['from_name'];
$x_kopf1 = $_GET['x_kopf1'];
$y_kopf1 = $_GET['y_kopf1'];
$x_kopf2 = $_GET['x_kopf2'];
$y_kopf2 = $_GET['y_kopf2'];
$x_kopf3 = $_GET['x_kopf3'];
$y_kopf3 = $_GET['y_kopf3'];
$x_kopf4 = $_GET['x_kopf4'];
$y_kopf4 = $_GET['y_kopf4'];
$x_kopf5 = $_GET['x_kopf5'];
$y_kopf5 = $_GET['y_kopf5'];
$x_kopf6 = $_GET['x_kopf6'];
$y_kopf6 = $_GET['y_kopf6'];
$x_kopf7 = $_GET['x_kopf7'];
$y_kopf7 = $_GET['y_kopf7'];
$x_kopf8 = $_GET['x_kopf8'];
$y_kopf8 = $_GET['y_kopf8'];
$x_kopf9 = $_GET['x_kopf9'];
$y_kopf9 = $_GET['y_kopf9'];
$x_kopf10 = $_GET['x_kopf10'];
$y_kopf10 = $_GET['y_kopf10'];
$x_kopf11 = $_GET['x_kopf11'];
$y_kopf11 = $_GET['y_kopf11'];
$x_kopf12 = $_GET['x_kopf12'];
$y_kopf12 = $_GET['y_kopf12'];
$x_kopf13 = $_GET['x_kopf13'];
$y_kopf13 = $_GET['y_kopf13'];
$x_kopf14 = $_GET['x_kopf14'];
$y_kopf14 = $_GET['y_kopf14'];
$x_kopf15 = $_GET['x_kopf15'];
$y_kopf15 = $_GET['y_kopf15'];
$x_kopf16 = $_GET['x_kopf16'];
$y_kopf16 = $_GET['y_kopf16'];
$x_kopf17 = $_GET['x_kopf17'];
$y_kopf17 = $_GET['y_kopf17'];
$x_kopf18 = $_GET['x_kopf18'];
$y_kopf18 = $_GET['y_kopf18'];
$x_kopf19 = $_GET['x_kopf19'];
$y_kopf19 = $_GET['y_kopf19'];
$x_kopf20 = $_GET['x_kopf20'];
$y_kopf20 = $_GET['y_kopf20'];
$x_kopf21 = $_GET['x_kopf21'];
$y_kopf21 = $_GET['y_kopf21'];
$x_object1 = $_GET['x_object1'];
$y_object1 = $_GET['y_object1'];
$x_object2 = $_GET['x_object2'];
$y_object2 = $_GET['y_object2'];
$x_object3 = $_GET['x_object3'];
$y_object3 = $_GET['y_object3'];
$x_object4 = $_GET['x_object4'];
$y_object4 = $_GET['y_object4'];
$x_object5 = $_GET['x_object5'];
$y_object5 = $_GET['y_object5'];
$x_object6 = $_GET['x_object6'];
$y_object6 = $_GET['y_object6'];
$x_object7 = $_GET['x_object7'];
$y_object7 = $_GET['y_object7'];
$card_num = $_GET['card_num'];
$email_text = $_GET['email_text'];
$body_URL = $_GET['body_URL'];
$message_text = strip_tags($message_text);
$message_text = str_replace("\r", " ", $message_text);
$message_text = str_replace("\n", " ", $message_text);
if ($to_name != NULL){
mysql_pconnect( $host, $user, $pass);
mysql_select_db ($database);
$query = "REPLACE INTO $table (message_text, to_name, from_name, x_kopf1, y_kopf1, x_kopf2, y_kopf2, x_kopf3, y_kopf3, x_kopf4, y_kopf4, x_kopf5, y_kopf5, x_kopf6, y_kopf6, x_kopf7, y_kopf7, x_kopf8, y_kopf8, x_kopf9, y_kopf9, x_kopf10, y_kopf10, x_kopf11, y_kopf11, x_kopf12, y_kopf12, x_kopf13, y_kopf13, x_kopf14, y_kopf14, x_kopf15, y_kopf15, x_kopf16, y_kopf16, x_kopf17, y_kopf17, x_kopf18, y_kopf18, x_kopf19, y_kopf19, x_kopf20, y_kopf20, x_kopf21, y_kopf21, x_object1, y_object1, x_object2, y_object2, x_object3, y_object3, x_object4, y_object4, x_object5, y_object5, x_object6, y_object6, x_object7, y_object7, card_num, prime_key) VALUES ('$message_text', '$to_name', '$from_name', '$x_kopf1', '$y_kopf1', '$x_kopf2', '$y_kopf2', '$x_kopf3', '$y_kopf3', '$x_kopf4', '$y_kopf4', '$x_kopf5', '$y_kopf5', '$x_kopf6', '$y_kopf6', '$x_kopf7', '$y_kopf7', '$x_kopf8', '$y_kopf8', '$x_kopf9', '$y_kopf9', '$x_kopf10', '$y_kopf10', '$x_kopf11', '$y_kopf11', '$x_kopf12', '$y_kopf12', '$x_kopf13', '$y_kopf13', '$x_kopf14', '$y_kopf14', '$x_kopf15', '$y_kopf15', '$x_kopf16', '$y_kopf16', '$x_kopf17', '$y_kopf17', '$x_kopf18', '$y_kopf18', '$x_kopf19', '$y_kopf19', '$x_kopf20', '$y_kopf20', '$x_kopf21', '$y_kopf21', '$x_object1', '$y_object1', '$x_object2', '$y_object2', '$x_object3', '$y_object3', '$x_object4', '$y_object4', '$x_object5', '$y_object5', '$x_object6', '$y_object6', '$x_object7', '$y_object7', '$card_num', '' )";
mysql_query ($query) or die ( mysql_error() );
echo "Successful Submission";
} else {
echo "Unsuccessful Submission";
}
if ($email_text != NULL){ // if an email address was included in the ecard creation page, then this part of the script is run...
$from = "no-reply@mydomain.de"; //FILL IN YOUR ADDRESS HERE
$headers = "From: $from";
$email_to = $email_text;
$subject = 'Sie haben eine eCard erhalten';
$message = "Ihr Freund: " . $from_name . " hat für Sie unter dieser Adresse eine eCard hinterlegt... \n\n";
$message .= $body_URL;
mail($email_to , $subject , $message, $headers ); // sends an email
}
?>
|
|
|