[mysql] Forum Topics

What is wrong with this signup code? > process.php: <?php $host=""; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name=""; // Database name $tbl_name=""; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("Cannot connect to server. Try again later."); mysql_select_db("$db_name")or die("Cannot connect …

I've just started php and mysql.trying this code to check if mysql account is correct or not. <?php $usr=$_POST['username']; $psw=$_POST['passwd']; echo ' body tag, other things and a message: Logging in! '; echo $usr; $connection = myqsl_connect('localhost',$usr,$psw); if (!$connection){ die('<p>Stopped : ' . mysql_error()); echo '<br /><a href="index.html">Retry</a></p>'; } else …

I've recently found that 1and1, my host, doesn't allow for remote access to MySQL databases and tables, and access is only possible via a slow and cumbersome web UI. Is there any workaround? I don't want to have to spend ten minutes browsing PHPMyAdmin every time I need to timestamp …

Hi. I have been working on a project that displays data in an XML file. (It's kind of like an API). I know how to parse XML with PHP, and how to make an XML file in PHP, but they don't work together. :) Basically, I have two files: `parse.php` …

I am using the followng code, to import csv into mysql. if($_POST['sform'] == "1") { $fname = $_FILES['upload']['name']; $chk_ext = explode(".",$fname); if(strtolower($chk_ext[1]) == "csv") { $filename = $_FILES['upload']['tmp_name']; $row = 1; if (($handle = fopen($filename, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $row++; $data_entries[] …

There are two tables - posts and comments: create table posts ( id integer not null primary key auto_increment, body text not null ); create table comments ( id integer not null primary key auto_increment, body text not null, post_id integer not null references posts(id) ); Now I want to …

kindly send me a vb / .net code for sync 2 mysql databases on localhost. I need only 1 way syncing. Thanks and Regards: Umair-Hassan

Hi, i got tis trigger CREATE PROCEDURE updateG AFTER INSERT ON gnojidba FOR EACH ROW BEGIN DECLARE box int; SELECT quantity INTO box FROM stock WHERE name = NEW.name; IF (box >= NEW.Qty_value) THEN UPDATE stock SET quantity = (quantity-NEW.Qty_value) WHERE name = NEW.name; ELSE UPDATE 'Error!' SET x=1; END …

Below is the code in which I am creating the list of URL s with the information of hotels in a city, the problem is when click on the URL no values are being displayed. please let me know how should i modify the code. <?php include ('connectdb.php'); $query = …

I am, trying to write a PHP-Mysql code which fetches the important places in a city and displays the results as links, when i click on the city it should display all the details like name, place, address, phone number etc, but in this case results are not being shown. …

Hi I am trying to create a stored procedure to list node titles with either a Y or a N if there is a coresponding record in another table, I am very new to stored procedures and am not sure how I get the data out and into a list, …

Guys, need some guidance here... i have this php codes that copies all the value in a table to another table....some sort of table replication now, the problem is when i tried copying them, keep getting an error Database down **1054: Unknown column '124928F014007570' in 'where clause'...** the codes dataverification.php …

hi All, I have two tables table-1:customeramount table-2:customerpurchaseamount table1 have customers bonus amount and table 2 i have customers purchase amount now i need to calculate balance bonus amount i tried with following query but It shows unexpected result , could any one guide me.. SELECT CM.`custid`, SUM(CM.`amount`) - SUM(CP.`Amount`) …

I'm having trouble deleting this file... keep getting this error : Warning: unlink(Gate_pass.csv) [function.unlink]: Permission denied in C:\wamp\www\SVS\copydata.php on line 31 i search trough some sites, they said replace the $myFile with the orginal name Gate_pass.csv, but still getting the same error...can someone guide me on this matter. thank you …

Hello, I need to create a JDBC that connects to a mySQL database, retrieves the data from a table and displays it into a JTable. I have done this successfully, but have ran into a problem. The initial values I entered into the database (for testing) are permament. If I …

Hi guys, I’ve written an application and I’m trying to utilise a database behind it. I’ve created a mysql database, and table which all appears to work correctly. I appear to have connected to the db correctly too. And hit a bit of a brick wall. As a side-note, within …

Hello, I want to edit record in mysql and ive got problem with UPDATE command its giving me syntex problem here is the code: <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("dbname", $con); $sql="UPDATE users SET (userid, firstname, lastname, email, username, password, role) …

Hello, I am new in all this and i was hoping you could help me with a little thing so here it is ive got 2 files one is for showing movies from database and there is "delete" button that is taking an a id and deleteing the raw display.php …

That is my query. I am trying to select the item details for the items the user has in their inventory, but I DO NOT want to select the ones that are in their collection. So I'm trying to say where item_id IS NOT in the user_collection with their user …

Hello, I try to call a header A if a user is logged in, and a header B if a user is not logged in on some pages I haven't managed to do so, I've tried to create a php function, but didn't manage to make it work. Then, I …

Hello, I'm trying to get results from a mysql database based on values in an array. My tables look like this 1. id | articles | thumbs | etc 2. tag_id | tag_name | article_id I'd like to get related articles based on the tags for that particular article. So …

Hi there, I am making a spell checker program with php with words stored in mysql. I use it to check unicode languages. But I do not get good suggestions with similar_text with percentage above 82. But if I decrease this percentage, I get many useless words. How can I …

I have a starting query that displays appointments and I am trying to expand to get different statistics: SELECT apt.user_id, apt.appt_id, apt.client_id, apt.time_start AS stime, FROM_UNIXTIME(apt.time_start,'%Y-%m-%d') AS ftime FROM tl_appt apt LEFT JOIN tl_rooms r on r.room_id = apt.room_id WHERE apt.appt_id IS NOT NULL AND apt.appt_status_id = '3' AND FROM_UNIXTIME(apt.time_start,'%Y-%m-%d') …

Hello! how can i sync or replicate my 2 db's on localhost xampp on windows. I want to replicate themselves as customer order something on my site and i am able to update his order and criteria as aearly as possible and also for security purpose. That if incase any …

Hi I pull data from a MYSQL database to populate a Drop down <td class="<?php print $Bank_ca_error;?>">Bank Name</td> <td> <select name="Bank" id="Bank" tabindex=24 style="color: <?php print $TextColour;?>"/> <option><?php print $_SESSION['Bank_ca'] ;?></option> <?php //Get Data to populate drop down $BankQuery = "SELECT BankName FROM tblbank ORDER BY BankName"; $BankResult = mysql_query …

hi, just want to maek sure some thing. so i have a table called user. in user table i want to add a field called date of birth. but i dont know which type to choice. it has int, varchar, date, datetime etc. but no date of birth. do i …

I am developing an java application for for login autentication form, I have pre saved username and password in my database. When admin enter his credetials, it validates to my DB and gives access to actual application Now, my application is used by admin and database is managed by DBA. …

Hi , I am trying to display images stored in database. Actually, i have stored image names with extenstion in the database, images are stored in my root directory images folder. Now i want to display all the images with other filelds in that table, in same page. I have …

I have two tables namely student and subject joined by a table called student_subject. With the following structure student: +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | student_ID | int(11) | NO | PRI | NULL | auto_increment | | studentCode | …

Hi, every members, I am Nur, i want make a complete MLM site. i try to MLM Binary tree downline View on php code. it will be difficalt for me to make MySQL database or php coding. please help me any on. i add a link to example: 1) MLM …