Jump to content

cffood

Members
  • Posts

    15
  • Joined

  • Last visited

cffood's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Does not matter anyway now I have found what i am looking for.
  2. I am looking at builing my own web app. but seen in some they have a updater feature where if the author has created a new update it will let you know and you can download and install it from the web app itself. something like this http://maxmorgandesign.com/simple_php_auto_update_system/ but i cant get this one working. i have looked but with no success with finding a good one. and anyone help me please
  3. cffood

    unsure

    perfect thank you for your response
  4. cffood

    unsure

    Unsure is totally me today...user if this is correct thread to ask about my issues... I am creating a social networking site. All going well... I am hit I can’t figuare this out i am sure wether it’s a mouseover or hover... In facebook when you have a married status it shows the link to the person you have selected. When you hover over the link it shows a table with the users cover images, name and message or see friends, ETC I am trying to find a code similar to this but I am unsure what I am looking for to help me. Any help much appreciated
  5. thank you its been awhile since i studied sql...totaly forgot about ALTER TABLE
  6. so my database table already exists but i need to add new columns to the table so this is how the table looks now CREATE TABLE IF NOT EXISTS `users` ( `id` int(255) NOT NULL AUTO_INCREMENT, `birthday` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1-1-1990', `comment_privacy` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone', `confirm_followers` int(11) NOT NULL DEFAULT '0', `current_city` text COLLATE utf8_unicode_ci NOT NULL, `follow_privacy` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone', `gender` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'male', `hometown` text COLLATE utf8_unicode_ci NOT NULL, `message_privacy` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone', `post_privacy` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone', `timeline_post_privacy` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; and this is what I need it to look.... but every time I insert in the sql to do the update but it does not do it as the table already there... CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT NOT NULL, `job_title` mediumtext COLLATE utf8_unicode_ci NOT NULL, `job_at` mediumtext COLLATE utf8_unicode_ci NOT NULL, `birthday` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1-1-1990', `comment_privacy` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone', `confirm_followers` int(11) NOT NULL DEFAULT '0', `current_city` text COLLATE utf8_unicode_ci NOT NULL, `relationship` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Not Applicable', `relationship_to` mediumtext COLLATE utf8_unicode_ci NOT NULL, `follow_privacy` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone', `gender` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'male', `hometown` text COLLATE utf8_unicode_ci NOT NULL, `message_privacy` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone', `post_privacy` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone', `timeline_post_privacy` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'everyone', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; how can I do this update>? its ok i know how to do this.. but the code i sell needs this update but i cant get them to delete there table as there mybe data already in the table
  7. thank you.. changed it but getting this error now? Parse error: syntax error, unexpected 'endif' (T_ENDIF) in C:\wamp\www\fmp\admin\controller.php on line 390
  8. Notice: Undefined index: amount in admin\controller.php on line 382 Call Stack # Time Memory Function Location 1 0.0080 421320 {main}( ) ..\controller.php:0 I am not sure what this means: if (isset($_POST['addClientFunds'])): /*line 382 */ $amount = floatval($_POST['amount']); $userid = intval($_POST['addClientFunds']); $totalnow = getValue("credit", "users","id = $userid"); $data['credit'] = ($totalnow == 0.00 and $amount < 1) ? '0.00' : floatval($totalnow + $amount); $db->update("users", $data, "id='" . $userid . "'"); print $data['credit']; endif;
  9. Done it : with a code of <?php if ($core->offline == 0) header("Location: public/maintenace.php"); else header("Locatioon: public/index.php"); ?> and some functions..
  10. <?php require_once("includes/db_connection.php"); ?> <?php $system = '{$offline}'; $query = "SELECT system FROM "; $query .= "offline" ; return $query; if ($system == 1) { header("Location: public/maintenance.php"); } else { header("Location: public/index.php"); } ?> ok struggling a little with redirecting. If offline in the database is set to true or 1 i want it to be redirect to the public/maintenace.php or if false to be sent to public/index.php with this code i made it just shows a blank white screen with no errors! I am learning php still so if the code is wrong I do apploagise but any help would not be gone un-noticed.
  11. if I take disabled="disabled" of the input then it wokrs fine..but it means they can change their username. which means if they change it they will never see what they inputted
  12. I have a form that posts into the database but not the username. I have for the form <td><input name="username" type="text" disabled="disabled" class="inputbox" value="<?php echo $row['username'];?>" size="45" /></td> to fetch the username from the database so they don't have to insert it as I will be making another code to echo the username's inputs so they can track what they have inserted. but its not inserting the username back in to the database. any while will do
  13. hi am learning php and new to it. I have found a really nice user membership form and database. I can code into etc. I wanting to add a insert weight and date. so people can keep track of there weight.. and a food diary. I kind get the grips of it but lost when I make a form to input the date and weight but how do I get it so it goes into the users database and echo it so hey can track it.
×
×
  • 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.