A1SURF.us

PHP variable designation

A1SURF.us replied to A1SURF.us's topic in PHP Coding Help

Well I thought this was a PHP help forum but it's looking more like flame fest. Your either gonna help or your not. Smart ass replies are not helping. Every time I have a problem I try to get some help here and I usually get ignored or smart ass replies like this and I end up solving the problem on my own. My signature was not spam. According to rules, images and links are allowed. I wasn't posting and replying all over the place in some unnatural way.. According to the rules, Flaming and or Trolling is prohibited and will result in course of action to be taken by Staff members. But you are a staff member and I guess the rules do not apply to you?

PHP variable designation

A1SURF.us replied to A1SURF.us's topic in PHP Coding Help

Why doesn't this work? or is their something similar like this that needs to be done with a call to the database? $id = $user_id

PHP variable designation

A1SURF.us replied to A1SURF.us's topic in PHP Coding Help

Theirs actually only a few lines of code that need modified. I keep getting a blank page error when I try to modify it. There is also some dynamic javascript that might need modified. So I included it inside the class. I'm not sure if the java is relevant and if it contains actual data from the database. Their are 'id' tags inside the javascript and it is throwing me off. Let me know if you need the original.

PHP variable designation

A1SURF.us replied to A1SURF.us's topic in PHP Coding Help

I attached a more cleaner version of the class. [attachment deleted by admin]

PHP variable designation

A1SURF.us replied to A1SURF.us's topic in PHP Coding Help

I had to cut a bunch of the class out so that it would fit inside the post limit, but it wasn't important stuff I think..

PHP variable designation

A1SURF.us posted a topic in PHP Coding Help

How do I designate or change 'id' in this class to 'user_id'? <?php include ("dbconnect.php"); include ("settings.php"); //make connection $server = mysql_connect($host, $user, $password); $connection = mysql_select_db($database, $server); // CUSTOM SQL FUNCTIONS function sql_quote($value) { $value = str_replace('<?','',$value); $value = str_replace('script','',$value); if (get_magic_quotes_gpc()) { $value = stripslashes($value); } if (!is_numeric($value)) { $value = "'" . mysql_real_escape_string($value) . "'"; } else { if ((string)$value[0] == '0') { $value = "'" . mysql_real_escape_string($value) . "'"; }} return $value; } function sql_lastinsertid() { $result = mysql_query("SELECT LAST_INSERT_ID()"); $row = mysql_fetch_row($result); return $row[0]; } function sql_getfield($table, $field, $where_cond = "") { $q = "SELECT ".$field." FROM ".$table." ".$where_cond; $r = mysql_query($q); $row = mysql_fetch_row($r); return $row[0]; } ?><?php //  //  //  if (isset($_GET['unsubscribe']) && sql_getfield($table_emails,'id','WHERE email = '.sql_quote($_GET['unsubscribe']))) { $q = "DELETE from $table_emails WHERE email = ".sql_quote($_GET['unsubscribe']); mysql_query($q); echo 'You have unsubscribed!'; exit(); } ?><?php //  //  //  if ($password_protection == true) { session_name($session_name); session_start(); // if (isset($_SESSION['last_ts'])) {$_SESSION['last_ts'];} if (!isset($_SESSION['last_ts']) && !isset($_POST['login'])) { // LOGIN FORM echo ' <body style="background:url(images/background.png) repeat-x;"> <div style="position:fixed;top:35%;left:35%;width:50%"> <form action="index.php" method="post" accept-charset="utf-8"> <img src="images/logo.png" alt="logo" id="logo" name="logo" align="left" style="margin-right:20px;" /> <br /><h1 style="font-family: arial, verdana;font-size:20px;color:#222;margin:0;color:#777;display:inline;">Newsletter module </h1> <small> pre 0.9</small><br /> <br /><input type="password" name="login" id="login" style="padding:5px;display:inline;" /> <input type="submit" style="background-color:#E61056;color:#fff;border:0;padding:5px;-moz-border-radius:3px;" value="Login"> </form> </div> </body> '; exit(); } if ($_POST['login'] && sha1($_POST['login'])==$password_hash) { $_SESSION['auth'] = substr(md5(microtime(true).mt_rand()), 0, 16); $_SESSION['last_ts'] = time(); // to destroy the post variable header('Location: index.php'); } if ($_POST['login'] && sha1($_POST['login'])!=$password_hash) { header('Location: index.php?info=invalidlogin'); } else if ((time() - $_SESSION['last_ts'] > $session_timeout) || isset($_GET['logout'])) { session_destroy(); header('Location: index.php'); } else if ((time() - $_SESSION['last_ts'] < $session_timeout)) { $_SESSION['last_ts'] = time(); } } ?><?php //  //  //  // Setup $error=''; // DELETE E-MAILS if ($_POST['action']=='delmail') { $count = 0; $category = $_POST["cat"]; $emails = $_POST["emails"]; if (!empty($emails)) { $email = explode("|",$emails); foreach ($email as $value) { if (!empty($value) && sql_getfield($table_emails,'id','WHERE id = '.sql_quote($value))) { $q = "DELETE from $table_emails WHERE id = ".sql_quote($value)." LIMIT 1"; mysql_query($q); $count+=1; } } } else { $error = 'No emails are selected !'; } echo "{"; echo "error: '" . $error . "',\n"; echo "count: '" . $count . "'\n"; echo "}"; exit(); } // *** // DELETE CATEGORY if ($_POST['action']=='delcat') { $kategorie = $_POST["categories"]; if (!empty($kategorie)) { $category = explode("|",$kategorie); foreach ($category as $value) { if (!empty($value) && sql_getfield($table_categories,'name','WHERE id = '.sql_quote($value))) { if (!in_array($value,$protected)) { $q = "DELETE from $table_categories WHERE id = ".sql_quote($value)." LIMIT 1"; mysql_query($q); $q = "DELETE from $table_emails WHERE category = ".sql_quote($value); mysql_query($q); } else { $error = 'This category is protected'; } } } } else { $error = 'Nie sú označené žiadne kategórie !'; } echo "{"; echo "error: '" . $error . "'\n"; echo "}"; exit(); } // *** // RENAME CATEGORY if ($_POST['action']=='rncat') { $category = $_POST["category"]; $newname = $_POST["newname"]; if (!empty($category) && !empty($newname) && sql_getfield($table_categories,'name','WHERE id = '.sql_quote($category)) ) { $q = "UPDATE $table_categories SET name = ".sql_quote($newname)." WHERE id = ".sql_quote($category)." LIMIT 1"; mysql_query($q); } else { $error = 'Chyba pri premenovaní !'; } echo "{"; echo "error: '" . $error . "'\n"; echo "}"; exit(); } // *** // NEW EMAIL if ($_POST['action']=='newemail') { $category = $_POST["cat"]; $emails = $_POST["emails"]; $append =''; if (!empty($emails)) { $emails = str_replace('"',"",$emails); $emails = str_replace(','," ",$emails); $emails = str_replace(';'," ",$emails); $emails = str_replace('<'," ",$emails); $emails = str_replace('>'," ",$emails); $emails = str_replace("\n"," ",$emails); $emails = str_replace("\t"," ",$emails); $emails = str_replace("\r"," ",$emails); $emails = str_replace("\0"," ",$emails); $email = explode(" ",$emails); foreach ($email as $value) { if (stristr($value,'@') && !sql_getfield($table_emails,'email','WHERE email = '.sql_quote($value).' AND category = '.sql_quote($category))) { $q = "INSERT into $table_emails (category,email) VALUES (".sql_quote($category).",".sql_quote($value).")"; if (!mysql_query($q)) { $error = 'ERR'; } else { $id = sql_lastinsertid(); $append.= '<div><input value="'.$id.'" id="'.$id.'" name="'.$id.'" type="checkbox" /> '.$value.'</div>'; } } } } else { $error = 'Zadajte emailové adresy'; } echo "{"; echo "error: '" . $error . "',\n"; echo "toappend: '" . $append . "'\n"; echo "}"; exit(); } // *** // NEW CATEGORY if ($_POST['action']=='newcategory') { $newcat = $_POST["catname"]; if (!empty($newcat)) { $q = "INSERT into $table_categories (name) VALUES (".sql_quote($newcat).")"; $result = mysql_query($q); if (!$result) { $error = 'ERR'; } else { $name = $newcat; $id = sql_lastinsertid(); } } else { $error = "Please, enter the name !"; } echo "{"; echo "error: '" . $error . "',\n"; echo "name: '" . $name . "',\n"; echo "id: '" . $id . "'\n"; echo "}"; exit(); } // *** // SENDMAIL if ($_POST['action']=='sendmail') { if ($use_template == false ) { $template_top = ''; $template_bottom = '';} $emails = $_POST['adresses']; $body = $_POST['ebody']; $subject = $_POST['subject']; $message = str_replace("\n","<br />",$body); /* ERRORS */ if ($message == '') {$error = 'Please, fill the message field !';} if ($subject == '') {$error = 'Please, fill the subject field !';} if (empty($emails)) {$error = 'No recipient defined ! ';} if (!empty($emails) && empty($error)) { /* ZAPIS DO ODOSLANÝCH NEWSLETTROV */ $q = "INSERT INTO $table_sent (time, subject, body, attachment) VALUES ( ".sql_quote(time()).", ".sql_quote($subject).", ".sql_quote($message).", ".sql_quote($_POST["attachment"]).")"; mysql_query($q); $from = "$your_name <$your_email>"; if (!empty($_POST["attachment"])) { $suffix =strtolower(substr($dir.$_POST["attachment"], -3)); switch($suffix) { case 'gif': $typ = "image/gif"; break; case 'jpg': $typ = "image/jpg"; break; case 'peg': $typ = "image/jpeg";break; case 'png': $typ = "image/png"; break; case 'pdf': $typ = "application/pdf"; break; case 'zip': $typ = "application/zip"; break; } $subject = $_POST['subject']; $fileatt = $dir.$_POST["attachment"]; $fileatttype = $typ; $fileattname = $_POST["attachment"]; $headers = "From: $from"; $file = fopen( $fileatt, 'rb' ); $data = fread( $file, filesize( $fileatt ) ); fclose( $file ); $semi_rand = md5( time() ); $mime_boundary = "==Multipart_Boundary_x{$semi_rand}x"; $headers .= "\nMIME-Version: 1.0\n" . "Content-Type: multipart/mixed;\n" . " boundary=\"{$mime_boundary}\""; $message = "This is a multi-part message in MIME format.\n\n" . "--{$mime_boundary}\n" . "Content-Type: text/html; charset=\"utf-8\"\n" . "Content-Transfer-Encoding: 7bit\n\n" . $template_top.$message.$template_bottom . "\n\n"; $data = chunk_split( base64_encode( $data ) ); $message .= "--{$mime_boundary}\n" . "Content-Type: {$fileatttype};\n" . " name=\"{$fileattname}\"\n" . "Content-Disposition: attachment;\n" . " filename=\"{$fileattname}\"\n" . "Content-Transfer-Encoding: base64\n\n" . $data . "\n\n" . "--{$mime_boundary}--\n"; } else { $subject = $subject." \n"; /* HEADERS */ $headers = "MIME-Version: 1.0\n"; $headers .= "Content-Type: text/html; charset=\"utf-8\"\n"; $headers .= "Content-Transfer-Encoding: 7bit \n"; $headers .= "From: ".$from." \n"; $headers .= "Return-Path: ".$from." \n"; $headers .= "X-Mailer: PHP/" . phpversion(); $message = $template_top.$message.$template_bottom; } if ($_POST['sendto']=='emails') { $email = explode(',',$emails); $email = array_unique($email); } else if ($_POST['sendto']=='categories') { $query = "SELECT * from $table_emails WHERE category IN (".$emails.")"; $select = mysql_query($query); while ($mail_row = mysql_fetch_assoc($select)) { $email[] = $mail_row['id']; } } /* ADMIN CHECK */ if ($mailcheck == true && !in_array($your_email,$email )) { $email[] = $your_email; } foreach ($email as $value) { $emailaddress = sql_getfield($table_emails,'email','WHERE id = '.sql_quote($value)); $unsubscribe_link = "<br /><br /><span style=\"font-size:14px;color:#000;\">If you prefer not to receive future promotional e-mails of this type, please click <a href=\"".$script_url."?unsubscribe=".$emailaddress."\" style=\"color:#ED008C;\">here</a> to unsubscribe."; mail($emailaddress, "=?UTF-8?B?".base64_encode($subject)."?=", $message.$unsubscribe_link, $headers); $count+=1; } } echo "{"; echo "error: '" . $error . "',\n"; echo "count: '" . $count . "'\n"; echo "}"; exit(); } // *** ?><?php //  //  //  ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-type" content="text/html; charset=utf-8" /> <meta http-equiv="expires" content="mon, 22 jul 2002 11:12:01 gmt" /> <title> Newsletter module </title>    <style type="text/css" media="screen"> /*<![CDATA[*/ /* HERE GOES YOUR CUSTOM CSS */ <?php echo $css; ?> /* THIS PART OF CSS SHOULD STAY UNTOUCHED TO PRESERVE ORIGINAL LAYOUT BUT - FEEL FREE TO CHANGE IT IF YOU KNOW WHAT YOU'RE DOING */ body { cursor:default; } h1, h2, h3, h4 { margin:0; padding:0; } #logo {vertical-align:middle;cursor:pointer;} a { cursor:pointer; } a:hover{ text-decoration:underline; } input[type=password],input[type=text],textarea { padding:3px; } #categories{ padding:10px; } .tiny { font-size:xx-small;color:#222; text-decoration:none; border:none; } .sign { font-size:xx-large; vertical-align:absmiddle; text-align:center; font-size:xx-large; display:inline; width:20px; } #processing { display:none; position:fixed; top:45%; left:45%; padding:10px 20px 10px 20px; margin:0 auto; text-align:center; } #filename { background:transparent;border:0; } #about { display:none; border:1px dotted #CCC; -moz-border-radius:10px; background-color:#3D3435; color:#fff; z-index:2; position:fixed; top:20%; left:32%; width:30%; padding:2%; } /*]]>*/ </style> </head> <body>  <?php // LOAD DATA INTO ARRAYS $result = mysql_query("SELECT * from $table_categories"); while ($row = mysql_fetch_assoc($result)) { $emails_result = mysql_query("SELECT * from $table_emails WHERE category = ".$row['id']); while ($subrow = mysql_fetch_assoc($emails_result)) { $row['emails'][] = $subrow; } mysql_free_result($emails_result); $categories[] = $row; } mysql_free_result($result); $result = mysql_query("SELECT * from $table_sent"); while ($row = mysql_fetch_assoc($result)) { $sent[] = $row; } mysql_free_result($result); ?> <div id="processing"> <img src="images/ajax-loader.gif" alt="loading" style="vertical-align:middle;margin-right:10px;" /> PROCESSING </div> <div style="clear:both;margin:0 auto;width:1000px;margin-top:60px;">  <img src="images/logo.png" alt="logo" id="logo" onclick="$('.maincontainers').hide(300);$('#newsletter').show(300)" /> <a class="button" id="sent_mails_link" onclick="$('.maincontainers').hide(200);$('#sent_mails').show(200);" name="sent_mails_link">SENT E-MAILS</a> | <a class="button" id="about_toggle" onclick="$('#about').fadeIn(300);">ABOUT</a> <?php if ($password_protection==true): ?> | <a class="button" id="logout" onclick="top.location.href='?logout=true'">LOGOUT</a><br /> <?php endif ?> </div> <br /> <div id="newsletter" class="maincontainers" style="clear:both;">  <div id="categories_container" style="width:200px;float:left;margin-right:20px;"> <h2> CATEGORIES </h2><br /> <br /> <div id="categories"> <?php if (isset($categories) && is_array($categories)) { foreach ($categories as $key => $value) { echo ' <div id="cat_'.$value['id'].'"> <input type="checkbox" value="'.$value['id'].'" /> <h3 style="cursor:pointer;" onclick="adr_show(\'category_'.$value['id'].'\');"> '.$value['name'].' </h3> </div>'; } } ?> </div><br /> <br /> <br />  <a onclick="$('#newcategory').slideToggle(200)" class="tiny">ADD CATEGORY</a><br /> <a onclick="delcat();" class="tiny">DELETE SELECTED</a><br /> <a onclick="rncat();" class="tiny">RENAME CATEGORY</a><br /> <div id="newcategory" style="text-align:left;display:none;"> <br /> <small>Create category with name:</small><br /> <br /> <input type="text" maxlength="40" id="newcategoryname" style="width:135px;border:1px solid #222;" /> <a onclick="newcategory()" class="tiny">OK</a><br /> </div> </div> <div id="emails_container" style="float:left;"> <?php if (isset($categories) && is_array($categories)) { foreach ($categories as $key => $value) { echo ' <div id="category_'.$value['id'].'" class="mails"> <h2 class="h2emails">E-MAILS</h2><br /> <div id="category_'.$value['id'].'_emails"><br /> <a style="font-size:small;margin-top:15px;" onclick="selectAll(\'category_'.$value['id'].'\',true);" ><small class="tiny">Select all</small></a> | <a style="font-size:small;margin-top:15px;" onclick="selectAll(\'category_'.$value['id'].'\',false);" ><small class="tiny">Select none</small></a><br /><br />'; if (isset($value['emails'])) { foreach ($value['emails'] as $subkey => $subvalue) { // EMAILS ARE PROTECTED BY ROT13 ENCRYPTION echo ' <div><input type="checkbox" name="'.$subvalue['id'].'" value="'.$subvalue['id'].'" /> <script type="text/javascript">  </script> <br /></div>'; } } else { echo '<span id="no_mails_'.$value['id'].'">No emails</span><br />'; } echo ' </div> <br />___<br /><br />  <a onclick="$(\'#new_emails_'.$value['id'].'\').slideToggle(200)" class="tiny"><font class="sign g">•</font> ADD E-MAILS</a> <a onclick="delmail(\''.$value['id'].'\');" class="tiny"><font class="sign r">-</font> DELTE SELECTED</a> <div id="new_emails_'.$value['id'].'" align="left" style="display:none;padding:15px;"> enter e-mails to add:<br /><br /> <textarea id="to_add_'.$value['id'].'" cols="30" rows="4" style="font-size:small;border:1px solid #222;"></textarea> <a class="tiny" onclick="add_mails(\''.$value['id'].'\')">OK</a><br /> </div> </div>'; } } ?> </div> <div style="float:right;"> <img src="images/send.gif" onclick="$('#newsletter').hide(350);$('#mailform').show(350);serializeSelection();" alt="next" style="cursor:pointer;" /> </div> </div> <div id="mailform" class="maincontainers" style="display:none;float:left;"> <h2> WRITE YOUR MESSAGE </h2> <div> <div style="float:left;padding:20px;border:1px dotted #ddd;"> <br /> <h3> SUBJECT </h3><br /> <br /> <input type="text" id="subject" style="width:400px;" /><br /> <br /> <h3> MESSAGE </h3><br /> <br /> <textarea id="emailbody" name="emailbody" cols="40" onfocus="if (this.value=='Write your message here ...') this.value='';" rows="8" style="width:400px;">Write your message here ...</textarea><br /> <br /> <input type="file" name="fileToUpload" id="fileToUpload" onchange="return ajaxFileUpload();" /> <input type="text" readonly="readonly" id="filename" style="color:#83B440;font-weight:bold;" value="" /><br /> <br /> </div> <div style="float:right;width:500px;text-align:center;padding-top:120px;"> <a class="backlink"><img onclick="sendmail();" src="images/go.png" alt="send!" /></a><br /> <br /> <span id="info_msg" class="tiny"></span> </div> </div><br style="clear:both" /> <br /> <a class="backlink" onclick="$('#newsletter').show(350);$('#mailform').hide(350)"><img src="images/back.gif" alt="go back" /></a> </div> <div id="sent_mails" class="maincontainers" style="display:none;float:left;"> <h2> SENT E-MAILS </h2> <div> <div style="float:left;padding:20px;border:0px dotted #ddd;"> <?php if (is_array($sent)) { foreach ($sent as $key => $value) { echo '<h3>'.$value['subject'].'</h3><br />'; echo '<small>'.$value['body'].'</small><br />'; echo '<small style="color:#ccc;">'.date('d.m.Y',$value['time']).'</small>'; if(isset($value['attachment'])) { echo ' <a style="color:#f30;text-decoration:none;" href="'.$dir.$value['attachment'].'" target="_blank"><small style="color:#f30;text-decoration:none;">'.$value['attachment'].'</small><br /></a>'; } echo '<br /><br />'; }} ?> </div> </div><br style="clear:both" /> <br /> <a class="backlink" onclick="$('.maincontainers').hide();$('#sent_mails_link').show(50);$('#newsletter').show(350);$('#mailform').hide(350)"><img src="images/back.gif" alt="go back" /></a> </div> </div> <p> <script type="text/javascript" src="<?php echo $jquery_src; ?>"></script>    <script type="text/javascript" charset="utf-8">  </script>    <script type="text/javascript">  </script> <?php mysql_close($server); ?> </body> </html>

How to put MySQL in Tables with Rows

A1SURF.us replied to A1SURF.us's topic in PHP Coding Help

This is what I got to work.. How do I get the join date to show up properly, it's just showing numbers? I replaced it with this line and the date works. echo date("d M Y h:i A",$row["joindate"]); Anyone want to clean it up? Or point out some other weakness.. <?php include('header.php');?> <div id="content_wrapper" style="padding-left:5%;padding-right:5%;"> <div width="80%" align="center"> <? if(!isset($_COOKIE["usNick"]) && !isset($_COOKIE["usPass"])) { exit(); } include('menum.php'); ?> <table cellpadding="0" cellspacing="0" style="border:1px #000000 solid;" width="68%"> <tr> <td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b> User </b></font></td> <td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b> Email </b></font></td> <td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b> Date </b></font></td> <td bgcolor="#eeeeee" style="padding:2px;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b> Visits </b></font></td> </tr> <? $lole=$_COOKIE["usNick"]; $tabla = mysql_query("SELECT * FROM tb_users where referer='$lole' ORDER BY id ASC"); while ($row = mysql_fetch_array($tabla)) { echo "<tr><td><font size=\"2\" face=\"verdana\">"; echo $row["username"]; echo "</font></td><td><font size=\"2\" face=\"verdana\">"; echo $row["email"]; echo "</font></td><td><font size=\"2\" face=\"verdana\">"; echo $row["joindate"]; echo "</font></td><td><font size=\"2\" face=\"verdana\">"; echo $row["visits"]; echo "</font></td></tr>"; } echo "</table>"; ?> <script type="text/javascript"> initSortTable('myTable',Array('S','N','S','N','S')); </script><br> </div> </div> <?php include('footer.php');?>

How to put MySQL in Tables with Rows

A1SURF.us posted a topic in PHP Coding Help

I'm trying to pull user referral data from my database. This is what I have so far. <table cellpadding="0" cellspacing="0" style="border:1px #000000 solid;" width="68%"> <tr> <td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b> User </b></font></td> <td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b> Email </b></font></td> <td bgcolor="#eeeeee" style="padding:2px;border-right:1px #000 solid;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b> Date </b></font></td> <td bgcolor="#eeeeee" style="padding:2px;border-bottom:1px #000 solid;"><font size="2" face="verdana"><b> Visits </b></font></td> </tr> <? $lole=$_COOKIE["usNick"]; $tabla = mysql_query("SELECT * FROM tb_users where username='$lole' ORDER BY id ASC"); while ($row = mysql_fetch_array($tabla)) { echo "<tr><td><font size=\"2\" face=\"verdana\">"; echo $row["username"]; echo "</font></td><td><font size=\"2\" face=\"verdana\">"; echo $row["email"]; echo "</font></td><td><font size=\"2\" face=\"verdana\">"; echo $row["joindate"]; echo "</font></td><td><font size=\"2\" face=\"verdana\">"; echo $row["visits"]; echo "</font></td></tr>"; } echo "</table>"; ?> <script type="text/javascript"> initSortTable('myTable',Array('S','N','S','N','S')); </script> I just found out my user ID is missing from database..

Insert Array Error

A1SURF.us replied to A1SURF.us's topic in PHP Coding Help

Your right it does work. I found the file in my list. How do I get it to show the upload was a success, with bright fancy lights of course, with my current template and a user success echo with a preview of the current uploaded file to better confirm the upload, instead of what looks like an error. The website uses .tpl flat files.

Insert Array Error

A1SURF.us posted a topic in PHP Coding Help

I get this error when I try to upload an image file: Array ( [file] => Array ( [name] => 125x125-adwidgetz.com.jpg [type] => image/jpeg [tmp_name] => /tmp/phpeghPVy [error] => 0 [size] => 12739 ) ) The error is somewhere in this class: } elseif(isset($_GET['action']) && $_GET['action'] == 'insert') { $file = str_replace(array('ü', 'ö', 'ä', 'ß', 'Ü', 'Ö', 'Ä', ' ', '/'), array('ue', 'oe', 'ae', 'ss', 'ue', 'oe', 'ae', '-', '-'), $_FILES['file']['name']); $file = preg_replace('![^a-z0-9/_\.]!i', '_', $file); $file = ereg_replace('_+', '_', $file); $file = time().$file; if($_FILES['file']['type'] == 'image/gif' OR $_FILES['file']['type'] == 'image/jpeg' OR $_FILES['file']['type'] == 'image/pjpeg' OR $_FILES['file']['type'] == 'image/png' OR $_FILES['file']['type'] == 'application/x-shockwave-flash' OR strstr($_FILES['file']['type'], 'shockwave-flash')) { move_uploaded_file($_FILES['file']['tmp_name'], _BannerAdManagement_PATH.'images/'.$file); $image_info = getimagesize(_BannerAdManagement_PATH.'images/'.$file);

Hit Counter Help

A1SURF.us replied to byrne86's topic in HTML Help

Analytics Alternatives; Hit Counter Alternatives 1. Free PHP/MySQL analytics alternative download and install the script. http://piwik.org/ 2. There is also statscounter. http://statcounter.com/ 3. Last but not least Stats247 http://stats247.co.cc/ And I'm off to play Warcraft III! Don't worry I have a good map hack like most people online except the no0obs!

HTML XHTML? Any difference?

A1SURF.us replied to cs.punk's topic in HTML Help

The only difference is the browser. Has no effect on you. Do you want other browsers to be able to access your web pages or not? Which is why you don't use frames, extreme widths, and tables...

designer

A1SURF.us replied to csckid's topic in HTML Help

You need to teach yourself CSS and start using Notepad. It's not that hard once you remember everything. Design is more of a memory game then anything else. So if your good at memory games or math then coding and design is a good idea for you. I personally suck at math so my coding skills lack majorly and I am trying to improve it on a daily basis. I thought CSS was harder the PHP code then I realized I could read it after I taught myself HTML. Experienced designers do not use Dreamweaver or Adobe. They code by hand and by knowledge. Software tools for web design are for beginners who do not know how to design anything. I'm sure an experienced designed can create some pretty wonderful websites with web design software. But there really is no need for deigners to use design software for anything other then reference. I only use Windows Expression for reference and to clean and format HTML. Everything I know, I taught myself from reading forums and just playing with examples of code.

iframe to display form

A1SURF.us replied to vijdev's topic in HTML Help

Using frames is not secure. Why don't you just change the .HTML page extension to .PHP and combine the form into the current page by simply embedding the PHP code or give it the same style sheet as the rest of your site and designate the form as a separate page. You can even include the form with PHP if you change the page extension from .HTML to . PHP, then just include an echo in the bottom of the PHP form: <?PHP include('your-form-page.php'); echo 'Thanks for using this form!'; ?> Keep in mind that most people don't have a 1400x1200 wide screen resolution when they browse the Internet thanks to phones and hand-held devices that can browse the internet, so you want to keep forms on separate pages anyway.

How do I get this PHP code to show up in a .tpl file form

A1SURF.us replied to A1SURF.us's topic in Other Libraries

This is what I have so far but it's not working: <?php error_reporting(E_ALL); session_start(); include_once './admin/inc/config.php'; include_once './admin/inc/globals.php'; include_once './admin/inc/database.class.php'; include_once './admin/inc/validation.func.php'; include_once './admin/inc/template.class.php'; include_once './admin/language/'._BannerAdManagement_DEFAULT_LANGUAGE.'.language.php'; header("Content-type: text/html; charset="._BannerAdManagement_Charset); $db = new mysqlconnection(); $tpl = new template(); $tpl->set_language($_language); // input validation if(isset($_GET['action']) && $_GET['action'] == 'save') { $validation_error = true; if(isset($_POST['username'])) { $sql_username = 'SELECT username FROM {prefix}banner_user WHERE username="'.$db->escape($_POST['username']).'"'; $result_username = $db->query($sql_username); $num_rows = mysql_num_rows($result_username); } if(isset($_POST['username'], $_POST['password'],$_POST['email'], $_POST['language']) && $num_rows == 0 && ((isset($_POST['generate_password']) && $_POST['generate_password'] == 1) || $_POST['password'] != '') && check_email($_POST['email']) && $_POST['language'] != '') $validation_error = false; if($validation_error == true) { $_GET['action'] = ''; } } // end of validation if(isset($_GET['action']) && $_GET['action'] == 'save') { include_once './admin/inc/mail.php'; if(isset($_POST['generate_password']) && $_POST['generate_password'] == '1') { $password = ''; if($_POST['generate_password'] == true) { // thank you abraxax $chars = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $char_num = strlen($chars)-1; for ($i=0;$i<rand("6","6");++$i) $password.= $chars[rand(0,$char_num)]; // end of my thanks } $_POST['password'] = $password; } //add referral if($_POST['r'] and !$_SESSION['r']) { $_SESSION['r'] = $_POST['r']; } if(($_SESSION['r'] and !$_POST['r']) or (($_SESSION['r'] and $_POST['r']) and $_POST['r'] != $_SESSION['r'])) { $_POST['r'] = $_SESSION['r']; } if($_POST["referer_name"]) { print $_POST["referer_name"]; } else { echo securedata($_GET["r"]); } if($_POST['referer_name'] or $_GET['r']) { print "$referer_name"; } if($_POST['r']) { $_SESSION['r'] = $_POST['r']; { $checkuser = mysql_query("SELECT username FROM banner_user WHERE username='$username'"); $username_exist = mysql_num_rows($checkuser); $referer_name = securedata($_POST["referer_name"]); $referer_name=limit_text($referer,15); $checkref = mysql_query("SELECT username FROM banner_user WHERE username='$referer_name'"); $referer_exist = mysql_num_rows($checkref); } } $sql_language = 'SELECT language FROM {prefix}banner_languages WHERE language_id="'.$db->escape($_POST['language']).'"'; $result_language = $db->query($sql_language); $row_language = mysql_fetch_array($result_language); $message = $_language['customer_registered_message']."<br><br>"; $message .= $_language['referer'].': '.$_POST['referer']."<br>"; $message .= $_language['referer_name'].': '.$_POST['referer_name']."<br>"; $message .= $_language['username'].': '.$_POST['username']."<br>"; $message .= $_language['password'].': '.$_POST['password']."<br>"; $message .= $_language['email'].': '.$_POST['email']."<br>"; $message .= $_language['language'].': '.$row_language['language']."<br>"; $message .= $_language['firm'].': '.$_POST['firm']."<br>"; $message .= $_language['lastname'].': '.$_POST['lastname']."<br>"; $message .= $_language['firstname'].': '.$_POST['firstname']."<br>"; $message .= $_language['street'].': '.$_POST['street']."<br>"; $message .= $_language['zipcode'].': '.$_POST['zipcode']."<br>"; $message .= $_language['city'].': '.$_POST['city']."<br>"; $message .= $_language['phone'].': '.$_POST['phone']."<br>"; $message .= $_language['fax'].': '.$_POST['fax']."<br>"; $message .= $_language['mobilephone'].': '.$_POST['mobilephone']."<br>"; send_mail(_BannerAdManagement_MailFrom, $_POST['email'], $_language['customer_registered_subject'], $message); $tpl->replace_all('info', $_language['customer_registered_confirmation']); $sql = 'INSERT INTO {prefix}banner_user (referer, username, password, email, userlevel, language_id, firm, lastname, firstname, street, zipcode, city, phone, fax, mobilephone, activate) VALUES ( "'.$db->escape($_POST['referer']).'", "'.$db->escape($_POST['referer_name']).'", "'.$db->escape($_POST['username']).'", "'.md5($_POST['password']).'", "'.$db->escape($_POST['email']).'", "1", "'.$db->escape($_POST['language']).'", "'.$db->escape($_POST['firm']).'", "'.$db->escape($_POST['lastname']).'", "'.$db->escape($_POST['firstname']).'", "'.$db->escape($_POST['street']).'", "'.$db->escape($_POST['zipcode']).'", "'.$db->escape($_POST['city']).'", "'.$db->escape($_POST['phone']).'", "'.$db->escape($_POST['fax']).'", "'.$db->escape($_POST['mobilephone']).'", "1")'; $db->query($sql); echo $tpl->display('./admin/templates/customer_register_confirmation.tpl'); } else { $sql = 'SELECT language_id, language FROM {prefix}banner_languages ORDER BY language ASC'; $result = $db->query($sql); $language_list = ''; while($row = mysql_fetch_array($result)) { if(isset($_POST['language']) && $_POST['language'] == $row['language_id']) $language_list .= '<option value="'.$row['language_id'].'" selected="selected">'.validate_print_form($row['language'], _BannerAdManagement_Charset).'</option>'; else $language_list .= '<option value="'.$row['language_id'].'">'.validate_print_form($row['language'], _BannerAdManagement_Charset).'</option>'; } if(isset($validation_error) && $validation_error == true) { // set error !isset($_POST['username']) || ($_POST['username'] == '' || $num_rows != 0) ? $tpl->replace('username', 'error', ' style="color: #ff0000;"') : $tpl->replace('username', 'error', ''); !isset($_POST['password']) || ($_POST['password'] == '' && (!isset($_POST['generate_password']) || $_POST['generate_password'] != 1)) ? $tpl->replace('password', 'error', ' style="color: #ff0000;"') : $tpl->replace('password', 'error', ''); !isset($_POST['email']) || !check_email($_POST['email']) ? $tpl->replace('email', 'error', ' style="color: #ff0000;"') : $tpl->replace('email', 'error', ''); !isset($_POST['language']) || $_POST['language'] == '' ? $tpl->replace('language', 'error', ' style="color: #ff0000;"') : $tpl->replace('language', 'error', ''); $tpl->replace_all('language_list', $language_list); $tpl->replace_all('referer_name', validate_print_form($_POST['referer_name'], _BannerAdManagement_Charset)); $tpl->replace_all('referer', validate_print_form($_POST['referer'], _BannerAdManagement_Charset)); $tpl->replace_all('username', validate_print_form($_POST['username'], _BannerAdManagement_Charset)); $tpl->replace_all('password', validate_print_form($_POST['password'], _BannerAdManagement_Charset)); $tpl->replace_all('email', validate_print_form($_POST['email'], _BannerAdManagement_Charset)); $tpl->replace_all('firm', validate_print_form($_POST['firm'], _BannerAdManagement_Charset)); $tpl->replace_all('lastname', validate_print_form($_POST['lastname'], _BannerAdManagement_Charset)); $tpl->replace_all('firstname', validate_print_form($_POST['firstname'], _BannerAdManagement_Charset)); $tpl->replace_all('street', validate_print_form($_POST['street'], _BannerAdManagement_Charset)); $tpl->replace_all('zipcode', validate_print_form($_POST['zipcode'], _BannerAdManagement_Charset)); $tpl->replace_all('city', validate_print_form($_POST['city'], _BannerAdManagement_Charset)); $tpl->replace_all('phone', validate_print_form($_POST['phone'], _BannerAdManagement_Charset)); $tpl->replace_all('fax', validate_print_form($_POST['fax'], _BannerAdManagement_Charset)); $tpl->replace_all('mobilephone', validate_print_form($_POST['mobilephone'], _BannerAdManagement_Charset)); } else { $tpl->replace('username', 'error', ''); $tpl->replace('password', 'error', ''); $tpl->replace('email', 'error', ''); $tpl->replace('language', 'error', ''); $tpl->replace_all('language_list', $language_list); $tpl->replace_all('referer', ''); $tpl->replace_all('referer_name', ''); $tpl->replace_all('username', ''); $tpl->replace_all('password', ''); $tpl->replace_all('email', ''); $tpl->replace_all('firm', ''); $tpl->replace_all('lastname', ''); $tpl->replace_all('firstname', ''); $tpl->replace_all('street', ''); $tpl->replace_all('zipcode', ''); $tpl->replace_all('city', ''); $tpl->replace_all('phone', ''); $tpl->replace_all('fax', ''); $tpl->replace_all('mobilephone', ''); } echo $tpl->display('./admin/templates/customer_register_form.tpl'); } This is the .tpl form: <form action="advertise.php?action=save" name="customer_register" method="post"> <p style="font-size:small;font-weight:bold;">*Required</p> <table style="border:2px green thick;"> <tr> <td width="170px"><span class="field_title"{error:username}><span style="font-size:small;font-weight:bold;">*</span>{language:username}</span></td> <td><input type="text" name="username" value="{username}" /></td> </tr> <tr> <td><span class="field_title"{error:password}><span style="font-size:small;font-weight:bold;">*</span>{language:password}</span></td> <td><input type="text" name="password" value="{password}" /> <input type="checkbox" name="generate_password" value="1" /> {language:generate_password}</td> </tr> <tr> <td><span class="field_title"{error:email}><span style="font-size:small;font-weight:bold;">*</span>{language:email}</span></td> <td><input type="text" name="email" value="{email}" /></td> </tr> <tr> <td><span class="field_title"{error:language}><span style="font-size:small;font-weight:bold;">*</span>{language:language}</span></td> <td><select name="language"> {language_list} </select></td> </tr> <tr> <td><span class="field_title">{language:firm}</span></td> <td><input type="text" name="firm" value="{firm}" /></td> </tr> <tr> <td><span class="field_title">{language:lastname}</span></td> <td><input type="text" name="lastname" value="{lastname}" /></td> </tr> <tr> <td><span class="field_title">{language:firstname}</span></td> <td><input type="text" name="firstname" value="{firstname}" /></td> </tr> <tr> <td><span class="field_title">{language:street}</span></td> <td><input type="text" name="street" value="{street}" /></td> </tr> <tr> <td><span class="field_title">{language:zipcode}</span></td> <td><input type="text" name="zipcode" value="{zipcode}" /></td> </tr> <tr> <td><span class="field_title">{language:city}</span></td> <td><input type="text" name="city" value="{city}" /></td> </tr> <tr> <td><span class="field_title">{language:phone}</span></td> <td><input type="text" name="phone" value="{phone}" /></td> </tr> <tr> <td><span class="field_title">{language:fax}</span></td> <td><input type="text" name="fax" value="{fax}" /></td> </tr> <tr> <td><span class="field_title">{language:mobilephone}</span></td> <td><input type="text" name="mobilephone" value="{mobilephone}" /></td> </tr> <tr> <td><span class="field_title">{language:referer}</span></td> <td><input type="text" name="referer" value="{referer}{referer_name}" /></td> </tr> </table> <br /> <input class="button" type="submit" value="{language:registerbutton}" /> </form>

Sign In

Posts

Joined

Last visited

Contact Methods

Profile Information

A1SURF.us's Achievements

Newbie (1/5)

Reputation

PHP variable designation

PHP variable designation

PHP variable designation

PHP variable designation

PHP variable designation

PHP variable designation

How to put MySQL in Tables with Rows

How to put MySQL in Tables with Rows

Insert Array Error

Insert Array Error

Hit Counter Help

HTML XHTML? Any difference?

designer

iframe to display form

How do I get this PHP code to show up in a .tpl file form

Browse

Activity

Important Information