39,323 Topics

Member Avatar for
Member Avatar for gotboots

Hi all, pretty new to sql. have made code already for showing, adding and deleting data from database but can't seem to make the update work. any help is much appreciated. here's what I have: [CODE]<html><body><form action="update.php" method="post"> <label>Person ID:<br></label> <input type="text" name="personID" size="40" value="" maxlength="150" /> <label>Customer Name:<br></label> <input …

Member Avatar for gotboots
0
183
Member Avatar for Shernykens

<?php $id=$result; $res=@mysql_query("Select * from t_stores where user_id='$id'"); print "<label>Select Company/Store </label>"; print "<select name=\"store_id\">\n"; print "<option value=''>\n"; while($row=mysql_fetch_assoc($res)){ $store_id=$row; $store_name=$row; print "<option value='$store_id'>$store_name\n"; $store=$_GET; // a noob way that above to get store_id but it wont work--> } ?> //how do i get the $store_id in the print above …

Member Avatar for divyakrishnan
0
178
Member Avatar for erik216

Hi All, I am using phpexcel to open a excel worksheet to insert some data. But I have some validation in this worksheet. I want to continue to use all validation. How can I do?

0
59
Member Avatar for vampshay

hi someone help me with this error:( Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\CDX\class_lib.php on line 57 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\CDX\class_lib.php on line 57 [CODE] <?php class contactdirectory{ private $db_host = 'localhost'; // Database …

Member Avatar for divyakrishnan
0
267
Member Avatar for masterjiraya

In my full program. I managed to finish my own thesis project from a certain bookshop company. It's features has: 1.) CMS ( Catalog, Gross Revenue, Number of Users, Number of Orders, Contact details of customers, Multiple admin Accounts, update-able Currency Foreign Exchange (from Oanda.com), paypal module, one-to-one and one-to-many …

Member Avatar for masterjiraya
0
326
Member Avatar for preston326

Hi, this works well on my localhost but when I upload it to my web server I get: Parse error: syntax error, unexpected T_STRING in /home/zupa/public_html/grafika.php on line 1 This whole xml thing is new to me and I really dont know why doesnt it work on my server (while …

Member Avatar for preston326
0
249
Member Avatar for johnniegee

I am reading data from a mysql db to my webpage. I wish to make a google pi-chart but have no idea how to pass the data from php (html?) to javascript(?) to populate the graph. I'm reading the rows into the html page ok, they are dispaying in a …

Member Avatar for Ichcha
0
210
Member Avatar for garymae14

evening !! i just want to ask if can you help me on how to create graph using php ?

Member Avatar for masterjiraya
0
105
Member Avatar for Ichcha

[ATTACH]22040[/ATTACH] the following code displays output as in attachment.. it skips some of the value.. in the above output, am not getting group name for DTA. but if i add [CODE]where groupid='DTA' in query[/CODE], it displays groupname. what went wrong here? please help.. thanking in advance. [CODE] while($rowmain=mssql_fetch_array($resultmain)) { $course …

Member Avatar for Ichcha
0
98
Member Avatar for fifarulez

I can't seem to get my register page working with a password. This is the query I executed: [CODE]CREATE TABLE dbUsers ( id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, username VARCHAR(16) unique, password CHAR(16), email VARCHAR(25) );[/CODE] It only registers if there is no password filled..

Member Avatar for fifarulez
0
186
Member Avatar for mpw5013

I'm making a simple box in the header of Joomla that displays the total quantity and total value of the cart. It works perfectly in VirtueMart, but once I leave the storefront the (Total) value is removed. How do I fix this? I would like to set a permanent super …

Member Avatar for mpw5013
0
127
Member Avatar for fifarulez

I'm almost done making my registration system on my home server. Thanks to everyone for your help. The last thing I would like to know is why it says: Error: [U]User not added to database.[/U] This is part of my register code: [CODE] // Fields are clear, add user to …

Member Avatar for fifarulez
0
151
Member Avatar for Feriscool

I've created an html page with forms, and what I need is for each new person that clicks the 'submit' button, have the text in the fields print to a [B]new line[/B] in the output.txt file on the web host. This is what I have so far: [CODE]<?PHP $filename = …

Member Avatar for diafol
0
161
Member Avatar for AngelosP

Hello everybody!!! I am trying to make a site where a user can select various checkboxes and see all the products of the categories he has checked. What i have done is create as many chkboxes as the categories are <input type="checkbox" name="ch1" value="movies" /> <input type="checkbox" name="ch2" value="music" /> …

Member Avatar for Morta
0
75
Member Avatar for asif49

I have a commenting system on my website which displays the date and time of when something was commented. I have used this method to do it at the moment: [CODE] date_default_timezone_set("Europe/London"); echo $date = "posted on " . date("Y-m-d") . " at " . date("H:i:s") . "<br><br>"; [/CODE] I …

Member Avatar for asif49
0
135
Member Avatar for fifarulez

Hello, like before, I'm still trying to make a register page with login and logout. Here's the link to my server (If I'm not allowed to share links please remind me.) [url]http://fifarulez.dyndns.org/hacks4all.wapzan.com/registration/[/url] After the registration it will give 2 warnings. ( ! ) Warning: mysql_query() [function.mysql-query]: Access denied for user …

Member Avatar for diafol
0
272
Member Avatar for chris_j_haines

Hi I have an occasional problem with the following scripts Here is the file upload form [CODE] <?php session_start(); if(isset($_SESSION['username']) == false){ header("Location: login.php"); exit(); } if(($_SESSION['userlevel']) != 'admin'){ header("Location: login.php"); exit(); } ?> <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> …

Member Avatar for stoopkid
0
175
Member Avatar for mownam

<?php include "db/config.php";?> <?php function loginCheck($username,$password) { $sql=mysql_query("select UserId, UserName, Password from user_login where UserName= '$_POST[username]' and Password= '$_POST[password]'"); $name=$sql['UserName']; //echo"hi".$name; //select * from user_login where UserName='mownam' and Password='welcome' $result =mysql_query($sql); //$uname=$_REQUEST["username"]; if(mysql_num_rows($result) > 0) { echo "<center>successfully logged<br />".$uname; } else { ?><div align="center" style="background-color: #FFFFCC"style="font:"Courier New" , Courier, …

Member Avatar for stoopkid
0
229
Member Avatar for nikita.chandra

Hi, I have installed Netbeans IDE 7.0.1 for php application and created a demo application. When i executed the application in the browser following url [url]http://localhost/CSR/index.php[/url] and error : Oops! Google Chrome could not connect to localhost Please help. Thanks, Nikita

Member Avatar for diafol
0
236
Member Avatar for jacksantho

Hi, If i turned OFF in php.ini file magic_quotes_gpc = Off; my code is working finely, when by using unserialize. Problem here: If i turned ON in php.ini file magic_quotes_gpc = On; [CODE] echo "<br>"; echo "<table>"; echo "<tr><td><b>confirm</b></td><td><a href='test.php?cname=confirm&cid=".base64_encode($id)."&code=".base64_encode($pcode)."&pname=".serialize($name)."'>Confirm</a></td>"; echo "</table>"; [/CODE] ($name is an array).Not unserialised--problem here [CODE] …

Member Avatar for diafol
0
277
Member Avatar for cgull

Hello, Does anyone know how can I setup an email server on my local machine, with google or my host's server? Or do you know of any site that explains how to do that? Thanks

Member Avatar for cgull
0
86
Member Avatar for jenberden

Hello! i would like to ask some codes in voting system using php, can select and determine the winner. Thank you...

Member Avatar for pritaeas
0
114
Member Avatar for Nahiyan

Hello, I am experiencing a problem with running javascript code when ajax calls a file. I have a file named 'index.php' which simply loads some comments by using the file 'comment.inc.php' and run some javascript code to change the id of some div. I don't know how to let the …

Member Avatar for Nahiyan
0
495
Member Avatar for nats01282

Hello, im unsure how to fetch a database row that includes php, i have a row in my database that displays a marquee saying 'welcome $username' i have connected to the database but the php on page shows 'welcome $username' how would i get it to state the username instaed …

Member Avatar for cgull
0
212
Member Avatar for uselessninja

hi everyone .... how to graph data from MSSQL database using php? i research in google and i found phpgraphlib but it only graph the value of the array

Member Avatar for uselessninja
0
129
Member Avatar for spawn2004

hi, everyone, i have a question abbout pdf and php. I use php , mysql and ajax in my page. After upload the pdf files i go in this page and get to data in table with paging. My question is hot to load the pdf files in same page …

Member Avatar for pritaeas
0
86
Member Avatar for fifarulez

Hello, I've always liked coding and lately I've learned a little but more of it. Now I also understand sql and db a little more. My problem is that my register.php file seems to give me a notice. Notice: Undefined index: op in C:\wamp\www\hacks4all.wapzan.com\registration\register.php on line 11 and Notice: Undefined …

Member Avatar for pritaeas
0
448
Member Avatar for extemer

HI guys i have a little problem while i post the data that is class_id and subject_id to my db with it extra field is generated having zero in class_id and subject_id e.g below [B]Edit Delete 0 0 Edit Delete 315 1[/B] beside the original ids.here is my code below …

Member Avatar for cgull
0
127
Member Avatar for anusanker

Hi, I am trying to get search result("Reg.nr:" field on the left menu) from this site, using curl method Site Url: http://nbk2.autodata.no/ To get the search result actually the user need to login with the site, the login is working properly with the curl function. The actual problem is that …

0
66
Member Avatar for 007tron

hello all, I am trying to create an istock kind of pagination of pictures, I am trying to find out how to do this in php (using divs or tables? not sure which is more suitable)and mysql.(ps is it a bad idea to store pictures in mysql database). I have …

Member Avatar for 007tron
0
151

The End.