10,940 Topics
 | |
| | I want to make option to approve users before they can login or to ban them, here is code [CODE]<HTML><HEAD><TITLE>Fakultet informacionih tehnologija</TITLE> </HEAD> <BODY TEXT="#ffffff" BACKGROUND="fakultet/Assets/bg.jpg" LINK="#FFFF00" VLINK="#CDCD00" BGCOLOR="#000000"> <CENTER><TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH="700"> <CENTER> <FONT SIZE=+4 FACE="arial,helvetica"> Fakultet informacionih tehnologija <HR> </CENTER> <?php session_start(); // dBase file include "dbConfig.php"; … |
 | Hey Im going to use some federated tables that I need but I know that the engine does not support foreign keys. Im thinking of alternatives and this is the one so far: Tables from the remote side and related related with a foreign key on the local side. Its … |
| | hi.. This is form validation code..im getting errors.. 1. I have to check whether all the field r empty and for certificates,photo,biodata field shud be validated for type,size,whether field is empty.. 2. how to validate the datepicker i used javascript <?php session_start(); if(isset($_POST['Role'],$_POST['Name'],$_POST['datepicker'],$_POST['gender'],$_POST['activity'],$_POST['Address'],$_POST['Photo'],$_POST['Biodata']$_POST['certificates'],$_POST['Salary'])) { $errors=array(); $Emp_Save=$_POST['Emp_Save']; $Emp_Cancel=$_POST['Emp_Cancel']; $Role=$_POST['Role']; $Name=$_POST['Name']; $datepicker=$_POST['datepicker']; … |
| | Hi all! Does anybody know a cool and cheap site where I could host my web application (jsp+Mysql)? Thanks in advance! Kind Regards |
 | I have very limited use of using MySql - but I am trying to fix this code and it seems to be corrent. But I am still getting the error. The website is a web directory, and the code itself checks to see the websites that arent linking back to … |
| | highlight listview item from mysql search statement then get the index  |
| | I am currently using MySQL so people can send my a message that shall be stored in the database. The only issue is I have no idea how to protect against SQL Injection, below is my HTML: [CODE]<form action="Action.php" method="POST" /> <p>Name: <input type="text" name="Name" /> </p> <p>Comment: <input type="text" … |
| | Hi I am using the fallowing code to give some information back to the user after running some queries. The information will be displayed in row only. [Code] $result1 = mysql_query("SELECT * FROM bookings WHERE bookingID='$last_insert_booking_id'"); echo "<table border='1'> <tr> <th>ID</th> <th>Firstname</th> <th>Lastname</th> <th>address1</th> <th>address2</th> <th>town</th> <th>postcode</th> <th>telephone</th> <th>email</th> <th>Arrival</th> … |
| | Hi Please take a look at my code snippet. Works fine, however I don't know how to get the number of rows returned so that I can handle it accordingly. Any ideas please? [CODE] <?php require ('mysqli_connect.php'); // Connect to the Db. $sql = "CALL customers_for_rep(?, ?)"; $stmt = $dbc->prepare($sql); … |
| | Hi.. this is code to display the datas from db to web page .. im not getting the outputphp,mysql <?php $host="localhost"; $username=""; $db_name="dbname"; . mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $query="SELECT * FROM database"; $result=mysql_query($query); $num=mysql_num_rows($result); mysql_close(); echo "<b><center>List Of Employees</center></b><br><br>"; $i=0; while ($i < $num) { …  |
| | Hello How do I go on about calling from Java stored procedures (which have variables going in and out) and transactions in MySQL? For a stored procedure example, something like 2 variables in that are numbers and the third going out that is the result. Thanks |
| | Hello Using MySQL, I have DB 1 with table T1 on Server 1 and DB 2 with table T1 on Server 2. Not on the same network and T1 contain the same columns with the same datatypes. I want to create a trigger on DB 1 so when there is … |
| | hi...... i created my login page...everything is working fine. i want to know whether we can get the login date for each users when they login.. and when they login the date shud be posted in the database?? how to implement this... |
| | Hey guys, I'm new to writing SQL and I need a bit of help. What I'm trying to achieve is getting my Java application to successfully send the high score of a specific user to a database. I'm not sure how I would write the SQL code so it will … |
| | I have a table where there is about 1 milliard record. when my website is on high traffic, there is more than 100 requests/second on this table. so request respond time is between 2-4 seconds, which leave a bad impression. is there any suggestion how to minimize the request respond … |
| | please correct the syntax[CODE]$sql = "INSERT INTO products WHERE cat_name = '".$_POST['cat_name']."' (cat_name,pro_name, file_name, manufacturer, manufacturers_code,detail,page_title,page_keywords,page_description,active,featured) VALUES( '" . $_POST['cat_name'] . "','" . $_POST['pro_name'] . "','" . $_POST['file_name'] . "', '" .$_POST['manufacturer'] . "', '" .$_POST['manufacturers_code'] . "', '" .$_POST['detail'] . "','" .$_POST['page_title'] . "','" .$_POST['page_keywords'] . "','" .$_POST['page_description'] . … |
| | I began to develop a simple coupon site. my db design Contains 4 tables: users deals category city when user purchasers a coupon i connect to getway payment service. in my accont at the getway service i can see all the transaction from my site. does it's meen that i … |
| | I have a php/mysql/html table of results The query is [CODE]$result = mysql_query(' Select var1, sum(var2) round(Avg(var3),0) round(Min(Price),2), round(Max(Price),2), round(Avg(Price),2) as AvgPrice, Country, From table Where country = "Australia" Group By var1 having var3 > 5 Order By var3 DESC') or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); print "<table width=800 … |
| | Hi Guys, Can someone help me. I am using FCK Editor when I add a new news article to my website. When entering each new article, I have included an option where there is a drop-down list to select a particular news category. In the front-end of the website the … |
| | Hello everyone, I have a problem with this code php: [CODE]<?php $sql = mysql_query("select * from news left join categories on news.category_id = categories.id group by category order by categories.id "); while($row=mysql_fetch_array($sql)){ ?>[/CODE] html: [CODE]<div class="title" align="center"> <?=$row['category']?> </div> <div class="headlines"> <span style="float:left;"><?=$row['subject']?></span> <span style="float:right;"> <?=$row['date']?> </span> </div>[/CODE] the problem … |
| | please help me!!! im restarting the mysql server from putty: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld when i checked mysql status, unused running unused running what's the problem?? im using putty in configuring mysql server thanks in advance.  |
| | hello guys, please give me any idea about solving this problem. I have two tables categories: id .... category .... parent ________________________________ 1 .... general .... 0 2 .... news .... 0 news: id .... headline .... category_id ________________________________ 1 .... headline1 .... 1 2 .... headline2 .... 2 3 … |
| | Hi people, well i am a computer science student and my dissertation title is "An Agent Based Tutoring System" and i am using JADE to do it and MySQL for the database. Can any one help me in doing it?? I want you people propose me some ideas so as … |
| | [CODE]Imports MySql.Data.MySqlClient Imports System.Data.SqlClient Module connection Public conn As MySqlConnection Public Sub xconnect() conn = New MySqlConnection conn.ConnectionString = "Server=localhost;User=root;Database=test;pwd=;" Try [U][B][COLOR="Red"]conn.Open()[/COLOR][/B][/U] MsgBox("Success") conn.Close() Catch ex As MySqlException MsgBox(ex.Message) Finally conn.Dispose() End Try End Sub End Module System.TypeInitializationException was unhandled Message="The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception." Source="System.Transactions" TypeName="System.Transactions.Diagnostics.DiagnosticTrace" … |
| | i got 3 users to be registered in the registration form through radio button admin,manager and employee... after registration of a admin the other 2 raadio buttons shud only enable in the registration form... admin shud be disable............ how to implement this in php........... |
| | [CODE] $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password1'; $dbname = 'DB01'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql for First Database'); mysql_select_db($dbname, $conn) ; [/CODE] This first connection is where the php file is stored. [CODE] $dbhost02 = '192.168.0.16'; $dbuser02 = 'root'; $dbpass02 = …  |
| | how to increase my mysql databse server partitioned in /var/lib/mysql using putty?? my server is linux open suse. can i have a step by step procedure??thnks. |
| | i have mysql xml field like this [CODE]<?xml version="1.0" encoding="UTF-8"?> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim"> <leader>00764nas </leader> <controlfield tag="221">011258</controlfield> <datafield tag="578" ind1=" " ind2=" "> <subfield code="a">jaun</subfield> </datafield> <datafield tag="356" ind1=" " ind2=" "> <subfield code="a"></subfield> <subfield code="c"></subfield> </datafield> <datafield tag="333" ind1=" " ind2=" "> <subfield code="d">ali</subfield> <subfield code="p">22</subfield> </datafield> <datafield tag="222" … |
| | I have two tables that I'm using in this query. We'll call the first one "userGroups" and the second "links". I've included their structure below. I have one system that is running an older version of MySQL, and I also have a system running a newer version. Older Version: 5.0.91-community-log … |
| | guys, can anyone help me on this problem? i have two tables then what I want is that, when an identical item is found in table2, it will not be displayed. Example: [CODE] Table1 Table2 item1 other1 item2 other2 item3 item2 item4 item3 [/CODE] Condition: if we use this query: … |
The End.