18,960 Topics
my insert php cannot save data to phpmyadmin when it enter the details. localhost:locahost , username:root password: databasename:b_database tablename:my_library tablecolumn:2 contains : isbn(primary key) and title. index.php <html> <head> <meta name="description" content="Php Code for View, Search, Edit and Delete Record" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Search Library Record</title> </head> …
hi guys, am trying to make a simple PHP form submission and insert some data to MySQL, my tables are: category: -id -category_name table1: -category_id(FK) -title -description table2: -table1_id(FK) -filetype -filesize -filedate -filename Form: -Date -Title -description -category(drop down) -upload file (get the file info like type,ext,size,filename) Or is there …
I get this message quite often and it has popped up again here, any ideas as to why? Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\.... on line 76 line 76 is this line in bold. [CODE] $productlist = ""; $sql = mysql_query("SELECT * FROM products …
I have a page to add products. On this page is a 'categorey' dropdown and a 'subcategory' dropdown. The subcategory dropdown should fill with the options based on the category dropdown selection. The code I have so far does not fill the subcat dropdown, can anyone see a problem? code …
hey guys... i know this is a very common problem and has been posted earlier also... but nobody seems to have figured out a solution... i am making a program using PHP/MySQL. I need to update 3 columns in a table. when i use a single UPDATE-SET command(using commas/AND etc …
Hi! Got errors on site... Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/header.php on line 30 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/config.php on line 4 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/index.php on line 16 …
Hello. I created a little recover page. Users write the email and a random password is sent to them. The random password is successfully send in their emails but when they login with the new password it doesn't login. I think the new password does not updates in my database. …
How to do the code for design and develop an PHP/MySQL application involves insert, view, search, delete, update/modify a record from a database
Design PHP/MySQL application that involves insert, view, search, delete, update/modify a record from a database. "The application is mylibrary and we have to insert, view, search, delete, update/modify the isbn(length:13) and title of the book (length:128)" Can someone show me the code ? I already done mine but I want …
I am trying to read XML file and store in sql table. I got two errors. PHP Warning: XMLReader::open(): Unable to open source data Warning: XMLReader::read(): Load Data before trying to read // In addition, Please let me know the filename in below cases. case 1: Code: Select all $reader->open($topdir."/nap/".$code->no()."_city.xml"); …
I have these templates: temp1(id,country_id,county_id,town_id,location_id,street_id) country(country_id, language,country_name) county(county_id, language,county_name) town(town_id, language,town_name) location(location_id, language,location_name) street(street_id, language,street_name) For now i am joining all these for the selected language to find the names of temp1 id's location. Is there a better way to retrieve the informations? Would be better to make a table …
A friend asked me to rewrite a program for him. Though the problem is it s using a rdb database, i am assuming this is a dec/oracle rdb database. Which i honestly never used and have no knowledge of. So i was wondering if there is any way to convert …
i am new to study web development..can anyone help me to how i can connect my website with the database..what are the requirements..very basic please.!!
<?php $query = "SELECT studinfos.lname, studinfos.fname, studinfos.mname, studinfos.suffix, studenroinfos.yearLevel, studenroinfos.sy FROM studinfos INNER JOIN studenroinfos ON studinfos.idNumber=studenroinfos.idNumber WHERE (studinfos.idNumber='$searchString') OR (studinfos.lname='$searchString') OR (studinfos.fname='$searchString')"; $result = mysql_query($query); echo "<table border=0 style='border-collapse: collapse' width=95%>"; while ($record = mysql_fetch_array($result)){ $name= $record['lname'].', '.$record['fname'].' '.$record['mname'].' '.$record['suffix']; /* when sql is modified already i can insert …
Hi there, I have a really irritating site problem that I just can't get my head around. I only have fairly basic coding skills and hope that someone here can help crack my issue. I own a small php/mySQL based job board which I have moved from hosting to hosting …
Hi All, I am currently working on a MySQL database, and am using mySQL Workbench to create a local server. From this computer(the one that is hosting the server) i have no problem connecting to the mysql server through 127.0.0.1:3306, however when I try to connect from another computer, I …
This is the code I am using but it keeps giving me this error: Failed to run query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near …
I am trying to learn SQL programming in my spare time, but I'm running into some issues. I currently have Visual Basic Studio 2010 installed, as well as Microsoft SQL Server 2008/2012. I've been told that I should be using MySQL to practice the coding. Should I lean towards MySQL …
how to delete in lisview base on selected items help pls this is my sql code for delete Try If identifier = Nothing Then MessageBoxEx.EnableGlass = False MessageBoxEx.Show("Please Choose an Item to Delete", "Specialized Training", MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Exclamation) Else Select Case MessageBox.Show("Are you sure you want to delete?", "Specialized Training", MessageBoxButtons.YesNo, …
I've been trying to use mysqli instead of mysql. I have a file from another site which will fit nicely to this site im doing now, but i havent a clue what i need to do to convert it to mysqli. This is the file <?php include 'connect.php'; //populate form …
Show me example design PHP/MySQL application involves insert, view, search, delete, update/modify a record from a database
PHP help , please asap , need your email to email you my problem
I am working on a mapping system to support pathfinding over areas that are too large to hold in memory. The problem i have run into is how to load only a small part of the map when its all linked together and then dynamicaly load more of the map …
I have a mysql query that seperates an array of variables and uses each variables to compare inside the database. The query uses a OR clause and I want to make it so it can also use an AND clause. The trick is I want the left side of the …
hello, i have below code and i need to change the status to inactive when i press the delete button. it happens that when i use the code below, the status does not change at all. can anyone tell me where am having an error in the code? <?php session_start(); …
hello guys, i have spent one week on this problem but untill now my proplem does not soloved. my code is about rating system and i can not insert vote for question that i voted for, throught this code vote will insert for the all displays question. note that i …
im using wampserver and i want to put password in the database. i check some video tutorias but when i try it it is not working in my case. can anybody please help me give some ideas. thanks
Hello, I have a members area on my website. I'm trying to check if a user with a specific username and id has logged in, and then echo a string of text on page B (members area page) if its them. The user logs in on page A (login page). …
hi guys, 1. i use this script from w3schools it works with real escape string. But my problem is it is slow displaying the table and i dont know how to check the problem. assuming password and table is correct. 2. can i change the "ajax_demo" value or delete? reference: …
how can detect if the username is already exist?? i don't what is lacking in my code. this is my code: <?php include( "db.php" ); $first = strip_tags(mysql_real_escape_string($_POST['first'])); $last = strip_tags(mysql_real_escape_string($_POST['last'])); $username = strip_tags(mysql_real_escape_string($_POST['username'])); $password = strip_tags(mysql_real_escape_string($_POST['password'])); $password2 = strip_tags(mysql_real_escape_string($_POST['password2'])); $passwordmd5 = md5($password); if( empty($first) || empty($last) ||empty($username) || empty($password) …
Hi I have a php header file that displays a random image from a mysql table each time the page is reloaded. I have done this just using rand() in the query. But doing it like this means that the same image could come up 3,4,5 times in a row! …
I have a form that shows images whos paths are stored in mysql. The form has 'hide' and 'show' submit buttons for each image. Pressing the hide button should set the value of the 'status' field to 2 (hidden). But it does nothing, my queries don't seem to execute. Here …
can you help me in 1 cell in a row can handle many data ? for example in the picture for costumer 1, he order a banana, it cost 50 apple, it cost 60 orange, it cost 70 and my program will retrieve the datas and it will get the …
Am creating an Online house rent system that will enable tenants to pay house rent online,check statements,a caretaker to write reports,landlord to write statements,add new tenants. I welcome all your ideas on how to go about it.The database requires either Ms-Excel or Mysql.
<?php $mysql_host = "***"; $mysql_database = "***"; $mysql_user = "***"; $mysql_password = "***"; mysql_connect($mysql_host,$mysql_user,$mysql_password); mysql_select_db($mysql_database); $query = "SELECT * FROM people coming"; $result = mysql_query($query); while($w=mysql_fetch_array($result)) { echo $w['Name']; } ?> this doesnt work--Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource y?
Hi All, I have a table of about 120,000 records which are mostly chemical products all with 100 byte varchar for the 'name'. I've indexed the 'name' and looked at the list here http://www.ajaxline.com/32-tips-to-speed-up-your-mysql-queries for ideas. But can't really find a solution because it's taking about 20 seconds to retrieve …
hi guys, This topic might be a little bit common sense but I do also believe it can help so much to beginners and experts. As a developer, I always have great interest in other languages although time and effort to learn is to be strictly applied and manage. My …
i have database with tables like these: t_09_students t_10_students t_11_students where 09, 10, 11 show year and this table will increase over the year. how do i select all the data from the tables (using union) with flexible table name? ask me, if it is not clear yet
it is possible for the database that a certain id number will handle or occupy 2 or more rows and then when it called it will take both rows like on the picture .[Click Here](https://fbcdn-sphotos-h-a.akamaihd.net/hphotos-ak-frc3/v/1056791_636382299706472_1144322928_n.jpg?oh=7160bd41f914616aa1a0c59be0821a9a&oe=51F21D0D&__gda__=1374895465_5046fd7250a283eac7faabc35a10c324)
So here is what I want. if (tracks, the db) (user_id, the row) for '".$_SESSION['user']['id']."' = equal (tracks, row) in (users, the db) for '".$_SESSION['user']['id']."' exit else update (users, the db) (tracks, the row) to match. This isn't the script as I don't know where to start but I am …
  hi everyone can anyone give me a coad for the form of search inside the php i mean they belong in the same page ? here's my php command for the pagination and results //Count the total number of row in your table*/ $count_query = mysql_query("SELECT …
I am getting the following error on my home page. I am new to php code and this one is looking pathetic on my wordpress site. any help would be highly appreciated. The error is as below: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given on line 39 …
i am building a message system for website.i have two table one store user_detail and other store message sent to each other users. you can see main.jpg file where inbox sent etc.. will be display and action takes accordingly. $query='select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, user_detail.user_id as userid, user_detail.username …
Hi all, How come this class doesnt connect to the database..? class credentials { private static $config = array(); const DB_USER = 'root'; const DB_PASS = ''; const DB_HOST = 'localhost'; const DB_NAME = 'dev_dcs'; public function __construct() { self::$config['user'] = self::DB_USER; self::$config['pass'] = self::DB_PASS; self::$config['host'] = self::DB_HOST; self::$config['name'] = …
hello fellas i'm stuck in this function: function getDataForPagination() { $sql = "select * from t_book limit 1, 15; $result = mysql_query($sql); if (!$result) return false; $num_rows = mysql_num_rows($result); if ($num_rows == 0) return false; $result = dbResultToArray2($result); return $result; } i want to make the above function more flexible …
Hopefully this will make sense and there is a solution in a single query... if not, I'm sure i can do it using multiple queries. I wrote a query that I thought would work, but didn't take into consideration that some of the records won't have data coming from one …
Hi Folks, Recently I installed WAMP server for web development, during my first run I tried My Sql Console, but I was gettting error while creating a new table. I am surely missing something. I googled for it but cannot get what i was looking for . . . Am …
Gyz i have some serious prob my code. if you find any error plz correct me . My code for Pay Fees (Update) <div id="wb_Form1" style="position:absolute;width:365px;height:270px;"> <form name="update" method="post" action="./Update_Fess.php" id="Form1"> <div id="wb_Text7" style="position:absolute;left:10px;top:15px;width:104px;height:16px;z-index:1;text-align:left;"> <span style="color:#000000;font-family:Arial;font-size:13px;">ISPID#:</span></div> <input type="text" id="Editbox1" style="position:absolute;left:124px;top:15px;width:198px;height:23px;line-height:23px;z-index:2;" name="ISPID" value=""> <div id="wb_Text9" style="position:absolute;left:10px;top:45px;width:104px;height:16px;z-index:3;text-align:left;"> <span style="color:#000000;font-family:Arial;font-size:13px;">August 2013:</span></div> <input type="text" …
Hi I have been trying for about a week to connect VB6 to MySQL and have so far been unsuccessful. What I am trying to do is have a login system in VB6 which, when the login button is pressed, searches the "userlogin" table in MySQL. If a matching result …
Hello, I have one query, $sql_query = db_select('Int_schedule_Table', 'c'); //name given as **c** $sql_query->fields('c',array('Int_Schedule_Id', 'cand_id', 'Int_Panel_Id', 'Interview_Date', 'Interview_Time','Interview_feedback_status', 'Interview_for_vacancy', 'hr_name', 'Int_Type')); //took fields from C $sql_query = $sql_query->extend('TableSort')->extend('PagerDefault')->limit(20); // I fired qury here $result = $sql_query->orderByHeader($header)->execute(); // after this I have simply applied my logic of displaying fields on $result. …
The End.