gunzbry
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: 1 Footer widget not showingOkay , Nevermind, I added the footer widget in by editing footer.php.
But how do I align it to the far right?Forum: Fixing WordPress
In reply to: Website URL /site cant be removedI can access this.
I have returned it back to my default settings for now.Do you need me to set it back to what I did just now? I have kept a logged in WordPress dashboard in another tab. Because If I close it , or lose connection to it.. I wouldnt be able to access the dashboard. Thats why Its working for now at mysite.com/site
The end result I want to achieve is just mysite.com without any /site url extension
and all other links like about us page to be mysite.com/about-us
Forum: Fixing WordPress
In reply to: Website URL /site cant be removedI want all my pages to not have the /site extension.
with the already working HTTPS and wp-login.php.
Because prvious tries have broke my wp-login/php without a theme and unable to loginForum: Fixing WordPress
In reply to: Website URL /site cant be removedI have tried all of those. And even changed the Siteurl in the database via phpmyadmin.
Thanks for taking your time to help .. But Im still facing:
When I update the site address to mysite.com
and update the permalink structure .. My pages work.
But : Https doesnt wokr anymore , and I cant access WP-Login.php. It keeps redirectingForum: Fixing WordPress
In reply to: Website URL /site cant be removedI used a plugin called WP-Clone.
And restored the backup of my test site to my main site.
Does this help?Forum: Fixing WordPress
In reply to: Website URL /site cant be removedHI Krishna! Thanks for the link.
I Have done all as followed. But now, My wp-login.php cant be accessed.
I enter URL : mysite.com/wp-login.php.
but redirects to mysite.com/site/wp-login.php and keeps redirecting and cant enter wp- dashboard.Any suggestions?
Forum: Fixing WordPress
In reply to: Search query for MySQL Database on WebsiteAlright. Thanks for taking the time to help me and appreciate it lots. I will Take my time to slowly read on and better understand before trying all this out.
Thanks again!
Forum: Fixing WordPress
In reply to: Search query for MySQL Database on WebsiteI dont know where to plug this in … I have experimented around and cant seem to figure out
pardon me for my newbieness..<?php //Variables for connecting to your database. //These variable values come from your hosting account. $hostname = "testcert.db.10462171.something.com"; $username = "testcert"; $dbname = "testcert"; //These variable values need to be changed by you before deploying $password = "xxxxx"; $usertable = "certs"; $yourfield = "ID"; //Connecting to your database mysql_connect($hostname, $username, $password) OR DIE ("Unable to connect to database! Please try again later."); echo "Connected to MySQL</br>"; mysql_select_db($dbname) or die(mysql_error()); echo "Connected to Database</br>"; //Fetching from your database table. $query = "SELECT * FROM $usertable"; $result = mysql_query($query); echo "ID\tName</br>"; while($row = mysql_fetch_array($result)) { echo $row['ID'] . "\t" . $row['Name']; echo "</br>"; } echo "</table>"; ?>Will Print:
Connected to MySQL
Connected to Database
ID Name
1 Alex
2 Alvin
5 Jane
3 Jack
4 Mr Wong
6 Judy
7 Wei Teng
8 Candy
9 Andy
10 Mr LeeHow do I select Individual ID to be Displayed?
Forum: Fixing WordPress
In reply to: Search query for MySQL Database on WebsiteAh , I mixed up the $usertable and $userfields.
Now my website displays this :
Connected to MySQL
Connected to Database
Name: Alex
Name: Alvin
Name: Jane
Name: Jack
Name: Mr Wong
Name: Judy
Name: Wei Teng
Name: Candy
Name: Andy
Name: Mr LeeSo , it shows that it is connected now , but I dont want it to just list it. is there a way to Have a search function where I Type in Serial, and the Name, ID, Course, and Desc are shown .
I will be going throught the php link you provided Thanks!
Forum: Fixing WordPress
In reply to: Search query for MySQL Database on WebsiteAhh I see. Thanks alot!
So far. It is able to connect to my database.
It displays
Connected to MySql
Connected to Database.What functions do I need to have a search query to query Serial number and get info from there?
Forum: Fixing WordPress
In reply to: Search query for MySQL Database on Website<?php $hostname = "testcert.db.10462171.something.com"; $username = "testcert"; $dbname = "testcert"; //These variable values need to be changed by you before deploying $password = "xxxx"; $usertable = "testcert"; $yourfield = "certs"; //Connecting to your database mysql_connect($hostname, $username, $password) OR DIE ("Unable to connect to database! Please try again later."); echo "Connected to MySQL</br>"; mysql_select_db($dbname) or die(mysql_error()); echo "Connected to Database"; //Fetching from your database table. $query = "SELECT * FROM $usertable"; $result = mysql_query($query); if ($result) { while($row = mysql_fetch_array($result)) { $name = $row["$yourfield"]; echo "Name: $name"; } } ?>This is what I have currently . Where do I go From here? I am quite new to PHP and MYSQL but I have read somewhere that $wpdb is only used for wordpress tables?
Please advise thanks!
Forum: Fixing WordPress
In reply to: Search query for MySQL Database on Websitein my Database :
There are these fields :
ID
Course
Name
Serial
DescHow can I search for a Serial and get all the other data according to that serial?
Forum: Fixing WordPress
In reply to: Querying an External DatabaseThanks for the reply Bemdesign!
wow.. is it really a security breach if I just allow users to enter a serial number and query data according to the specific data too?
And thanks for sharing the plugin. I will check it out =).
I didnt know reading data from an external database would require injections and security breaches.. haha
Forum: Fixing WordPress
In reply to: Self Assessment / Recommendationcool! i wil look into that. Any other people have experience with similar quiz makers?
Forum: Fixing WordPress
In reply to: Sidebar Links not workingTHANKS GUYS!!!